Results 1 to 4 of 4

Thread: Google sheets vlookup

  1. #1
    New Member
    Join Date
    Mar 2017
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Google sheets vlookup

    I have a vlookup in Google Sheets that isn't making sense to me.

    =MID(A3,search("(",A3,1)+1,6)
    returns 263972

    =vlookup(263972,$S$3:$X$158,3,0)
    returns the expected result

    =vlookup(MID(A3,search("(",A3,1)+1,6),$S$3:$X$158,3,0)
    returns N/A. (
    Did not find value '263972' in VLOOKUP evaluation.)





    Does anybody know why I can't combine the two formulas? Is this just a downside to using Google?

    Thanks for your help!

  2. #2
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,644
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Google sheets vlookup

    I really can't say a lot about Google sheets, but in Excel, you might have an issue with comparing a text value with a numeric value. Try:

    =vlookup(MID(A3,search("(",A3,1)+1,6)+0,$S$3:$X$158,3,0)

    The +0 converts a number stored as text into a number.
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

  3. #3
    New Member
    Join Date
    Mar 2017
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Google sheets vlookup

    **** you're good!

    It worked. Thanks a lot!

  4. #4
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,644
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Google sheets vlookup

    Happy to help!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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