+ Reply to Thread
Results 1 to 6 of 6

Vlookup #n/a error

  1. #1
    Registered User
    Join Date
    08-20-2017
    Location
    Istanbul, Turkiye
    MS-Off Ver
    2016
    Posts
    74

    Vlookup #n/a error

    Hi,
    I am unable to use vlookup on BL page on yellow cells. They refer to other sheet. I need your help, thank you.

    https://docs.google.com/spreadsheets...it?usp=sharing

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,986

    Re: Vlookup #n/a error

    I dont use google sheets, but it looks like you have not included a row number for the 2nd part of the range?
    =VLOOKUP($B$1,OPS!A2:AW,2,0)

    Also, why are you going all the way to AW when you want the value from the 2nd column?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-20-2017
    Location
    Istanbul, Turkiye
    MS-Off Ver
    2016
    Posts
    74

    Re: Vlookup #n/a error

    FDibbins,
    it looks like you have not included a row number for the 2nd part of the range? => i couldnt catch what you mean, would you pls clarify?
    why are you going all the way to AW when you want the value from the 2nd column? => because in original document, there are data ending in AW. i limited in this version to D column.
    waiting your kind help, thank you

  4. #4
    Forum Expert
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    1,809

    Re: Vlookup #n/a error

    The data is text in the lookup table, so you need:

    =VLOOKUP(""&$B$1,OPS!A:D,2,0)

    for example.
    Rory

    "I hate quotations. Tell me what you know." -Emerson

  5. #5
    Registered User
    Join Date
    08-20-2017
    Location
    Istanbul, Turkiye
    MS-Off Ver
    2016
    Posts
    74

    Re: Vlookup #n/a error

    Thank you very much Rory

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,986

    Re: Vlookup #n/a error

    Quote Originally Posted by turkanet View Post
    FDibbins,
    it looks like you have not included a row number for the 2nd part of the range? => i couldnt catch what you mean, would you pls clarify?...
    Normally a range includes a starting cell ref (col & row) and an ending ref (col & row), or just col refs Col:Col). the 2nd part of your range looks like it is missing the ending row
    =VLOOKUP($B$1,OPS!A2:AW,2,0)
    maybe that should have been either...
    =VLOOKUP($B$1,OPS!A2:AW100,2,0)
    OR
    =VLOOKUP($B$1,OPS!A:AW,2,0)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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