Nested IF Statement with VLOOKUPS = Too Many Arguments

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

Try this in your IF formula;

Formula:

Please Login or Register  to view this content.

You had too many arguments for the IF statement. Only 3 arguments for an IF.

Formula:

Please Login or Register  to view this content.

Kersplash, you rock! Thank you so much!