Hello,
I am having trouble with a nested IF statement when I try to add a second vlookup. The error is too many arguments.
I am trying to pull the case counts for materials, but the unit of measure has three options. Therefore, I need 2 vlookups. 1 for "PAC" UoM, 1 for "EA" UoM, then just returning value if "CAR" since already cases.
This is currently working for just "EA" and "CAR" with:
There are blank rows in the data, but I dont want a bunch of #N/A, so I have that returning blank. If the material is not listed on case count tab, I have it returning "MISSING" so we can fix.
The new UoM "PAC" inner pack qtys will now be columns D and E in case counts tab.
Attached is a sample sheet, anyone have an idea on how to add the "PAC" lookup to existing formula?
I appreciate you all!
Thanks!
Luke
Bookmarks