Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Feb 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VLOOKUP Issue / Formula Result Incorrect

    My VLOOKUP is not working... It shows the formula result as the correct value, but when I hit enter it reverts to 0. I don't know why or how to fix it. Ideas before I throw my laptop through the window?
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,593
    Thanks
    44
    Thanked 77 Times in 72 Posts
    Could you post the Excel workbook? What's the format for the O column?

  3. #3
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Try moving the table array to begin in Column A. Sometimes, the vlookup does not work unless the unique key is in the far left of the spreadsheet. Good luck!

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,354
    Thanks
    4
    Thanked 229 Times in 210 Posts
    Do you see any mention of Circular references in the status bar at the bottom?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,442
    Thanks
    166
    Thanked 651 Times in 619 Posts
    Hi

    Try making sure that what you are looking up actually matches exactly the item in the range.
    If you have trailing spaces in the names, this can cause the problem.

    zeddy

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    3,038
    Thanks
    166
    Thanked 800 Times in 729 Posts
    Try sorting your table array in an ascending order. If it can't be sorted, try the following formula

    In cell O2 =INDEX(I2:L62,MATCH(N2,I2:I62,0),4)

    HTH,
    Maud

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,442
    Thanks
    166
    Thanked 651 Times in 619 Posts
    or in cell O2 =INDEX(L:L,MATCH(N2,I:I,0))

    ..and if you get a #N/A, then your names aren't the same, i.e. have spaces

    zeddy

Tags for this Thread

Posting Permissions

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