Hello,
I am trying to build a nested IF statement with VLOOKUPS but receive the error "Too Many Arguments". A single IF statement with this criteria is successful. Any help is appreciated.
Formula:
=IF(E3="Canadian Tire",VLOOKUP(B7,Sheet3!A:B,2,FALSE), " ", IF(E3="Home Depot CA",VLOOKUP(B7,Sheet3!A:C,3,FALSE), " ", IF(E3="Lowes CA",VLOOKUP(B7,Sheet3!A:D,4,FALSE), " ")))
I have also tried a IFS statement but it produces #NAME error:
=IFS(E3="Canadian Tire",VLOOKUP(B7,Sheet3!A:B,2,FALSE), " ", E3="Home Depot CA",VLOOKUP(B7,Sheet3!A:C,3,FALSE), " ", E3="Lowes CA",VLOOKUP(B7,Sheet3!A:D,4,FALSE), " ")
Ultimately, what I am trying to accomplish is a universal customs doc. D2 is where you select shipping address. E3 has a vlookup to Sheet 2 to see if D2 is a retailer that needs their item # present. A7 is where I am inserting formula. If E3 is one of the three retailers, then I want their item number to pull from the item master on Sheet 3. If E3 is blank, then I want a space returned.
Any ideas on how I can accomplish this? Attached is the file I am working in.
Thanks!
Luke
Bookmarks