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,470
    Thanks
    30
    Thanked 62 Times in 58 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,280
    Thanks
    3
    Thanked 191 Times in 177 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
    2,832
    Thanks
    136
    Thanked 484 Times in 461 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
    2,639
    Thanks
    115
    Thanked 651 Times in 593 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
    2,832
    Thanks
    136
    Thanked 484 Times in 461 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
  •