Go Back   OC3D Forums > [OC3D] Off Topic > Off Topic Chat > Serious Discussion
Thread Tools Display Modes
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
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

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 03:42 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.