+ Reply to Thread
Results 1 to 3 of 3

Nested IF Statement with VLOOKUPS = Too Many Arguments

  1. #1
    Registered User
    Join Date
    11-14-2018
    Location
    Colorado
    MS-Off Ver
    365
    Posts
    16

    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
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Nested IF Statement with VLOOKUPS = Too Many Arguments

    Try this in your IF formula;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    You had too many arguments for the IF statement. Only 3 arguments for an IF.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-14-2018
    Location
    Colorado
    MS-Off Ver
    365
    Posts
    16

    Re: Nested IF Statement with VLOOKUPS = Too Many Arguments

    Kersplash, you rock! Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1