Go Back   OC3D Forums > [OC3D] Off Topic > Off Topic Chat > Serious Discussion
Reply
 
Thread Tools Display Modes
 
  #1  
Old 04-04-18, 09:36 AM
demonking's Avatar
demonking demonking is offline
OC3D Crew
 
Join Date: Sep 2011
Location: UK
Posts: 902
Any Excel Pro's?

Hi all,

Im useless with Excel. I have a formula that contains several augments, most importantly a Vlookup. Problem is I can't change the formula to count the results. I keep getting errors of too many augments. Formula pasted below if anyone knows a fix?

=IF(ISNA(VLOOKUP($B$1&B9,'Delivery Schedule'!B:H,7,0)),"0",VLOOKUP($B$1&B9,'Delivery Schedule'!B:H,7,0))

Unfortunately I can't show any of the details of the spreadsheet contents without getting in a lot of trouble.

If anyone can help I will never forget it, Thanks guys.


* resolved, Cheers anyway guys and girls

Reply With Quote
  #2  
Old 14-04-18, 07:47 AM
RobM's Avatar
RobM RobM is offline
OC3D Elite
 
Join Date: May 2016
Location: Durham
Posts: 1,369
IF can only use 2 arguments and your calling it with more
__________________
ASUS Prime x370 Pro | Ryzen 5 1600 | Antec 240 AIO | Corsair Vengance RGB 3000 2 x 8Gb | Asus Strix RX 470 | Samsung Evo 120gb ssd | Seagate Baracuda 1tb storage | EVGA 500w | Phanteks Entho ProM Acrylic Window | Windows 10 and Linux Manjaro
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump










All times are GMT. The time now is 05:55 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.