demonking
New member
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
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
Last edited:
