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 Elite
 
Join Date: Sep 2011
Location: UK
Posts: 1,027
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,554
IF can only use 2 arguments and your calling it with more
__________________
ASUS ROG Crosshair VII wifi | Ryzen 5 3600 | Custom Loop | Patriot Viper Steel 4133 @ 3600 2 x 8Gb | Asus Strix RX 470 | Samsung 500gb nvme | Samsung 1Tb nvme | Samsung Evo 120gb ssd | Seagate Barracuda 1tb storage | Toshiba 1Tb HDD | EVGA 500w | Phanteks Entho Pro Tempered Glass | 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 07:13 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.