+ Reply to Thread
Results 1 to 5 of 5

Vlookup iferror using different lookup columns

  1. 10-30-2019, 03:35 PM #1
    tomdig50
    tomdig50 is offline
    Registered User
    Join Date
    09-03-2013
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    7

    Vlookup iferror using different lookup columns

    I have a formula that is as follows:

    =VLOOKUP(B8,'[2019-10-30 BEST COST COMPLETE_20191026011813_963411.xlsx]BEST COST COMPLETE_'!$A$2:$O$50595,1,FALSE)

    I am getting a result but also gettting a N/A result for which I want to use the following formula to resolve:

    =IFERROR(VLOOKUP(B8],'[2019-10-30 BEST COST COMPLETE_20191026011813_963411.xlsx]BEST COST COMPLETE_'!$A$2:$O$50595,1,0),=IFERROR(VLOOKUP(B9,'[2019-10-30 BEST COST COMPLETE_20191026011813_963411.xlsx]BEST COST COMPLETE_'!$A$2:$O$50595,1,0)

    NOTE that all I am doing is changing the lookup column from B8 to B9 however I am still getting an N/A result and I know that the information in B9 can be found.

    Any suggestions on resolving this?
    Last edited by tomdig50; 10-30-2019 at 03:53 PM.
    Reply With QuoteRegister To Reply
  2. 10-30-2019, 03:40 PM #2
    loginjmor
    loginjmor is offline
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Vlookup iferror using different lookup columns

    Hi -

    The syntax of the statement doesn't look correct. You don't need an = sign in front of the second IFERROR. Also, it doesn't look like the second IFERROR is complete. You should post a sample of your spreadsheet so we can see the actual syntax of the formula you are using and try to diagnose the problem.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
    Reply With QuoteRegister To Reply
  3. 10-30-2019, 03:42 PM #3
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Vlookup iferror using different lookup columns

    You have a close square-bracket after B8, and also an = in the middle of the formula - both of which need to be removed. Also, you don't need the second IFERROR(, which isn't completed anyway. Try it like this:

    =IFERROR(VLOOKUP(B8,'[2019-10-30 BEST COST COMPLETE_20191026011813_963411.xlsx]BEST COST COMPLETE_'!$A$2:$O$50595,1,0),VLOOKUP(B9,'[2019-10-30 BEST COST COMPLETE_20191026011813_963411.xlsx]BEST COST COMPLETE_'!$A$2:$O$50595,1,0))

    As the filename does not include the full path, the formula implies that it is open in the same instance of Excel.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  4. 10-30-2019, 03:52 PM #4
    tomdig50
    tomdig50 is offline
    Registered User
    Join Date
    09-03-2013
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    7

    Re: Vlookup iferror using different lookup columns

    YOU ROCK PETE!! Solved appreciate the assistance!
    Reply With QuoteRegister To Reply
  5. 10-30-2019, 03:57 PM #5
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Vlookup iferror using different lookup columns

    Glad to help, and thanks for marking the thread as Solved.

    You can show your appreciation to those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLOOKUP, LOOKUP, MAX, IFERROR query
    By fumusic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2019, 10:15 AM
  2. IFERROR, LOOKUP and ROUNDUP In the Same Formula?
    By sawyer8870 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-17-2019, 09:32 AM
  3. IFERROR(LOOKUP need help to modify search
    By A440 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2015, 06:47 AM
  4. [SOLVED] Beyond VLOOKUP : Matching 3 columns in a table lookup
    By AdamBecker in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-11-2013, 03:13 AM
  5. [SOLVED] Vlookup if lookup value is between two values from two columns
    By gsrai31 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-27-2012, 06:01 AM
  6. Excel 2007 : IFERROR(LOOKUP, how to return the first value in a row
    By Martin Chamberlin in forum Excel General
    Replies: 2
    Last Post: 11-19-2011, 05:15 PM
  7. Vlookup? - Lookup 3 Columns or more
    By agsankaa in forum Excel General
    Replies: 3
    Last Post: 05-19-2009, 01:51 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1