+ Post New Thread
Results 1 to 6 of 6
Office Software Thread, vLookup in Technical; Hi, I'm trying to get a table to do a vlookup and it isn't working right. When I enter a ...
  1. #1

    Join Date
    Jun 2009
    Location
    Birmingham
    Posts
    598
    Thank Post
    92
    Thanked 72 Times in 64 Posts
    Rep Power
    24

    vLookup

    Hi,

    I'm trying to get a table to do a vlookup and it isn't working right.

    When I enter a number in cell 5c it is picking up the wrong data from the array but I can't see why, can anyone help?

    Cheers

    Rich
    Attached Files Attached Files

  2. #2
    TheLibrarian
    Guest
    Take the trailing spaces off the first column of the lookup.

  3. Thanks to TheLibrarian from:

    Tricky_Dicky (16th November 2009)

  4. #3

    Join Date
    Jun 2009
    Location
    Birmingham
    Posts
    598
    Thank Post
    92
    Thanked 72 Times in 64 Posts
    Rep Power
    24
    Coloumn M? It doesn't have any spaces, just centre aligned. Is that what you mean?
    Rich

  5. #4
    TheLibrarian
    Guest
    The value "3c" in cell M19 is actually "3c ", there are a few values with trailing spaces, they will all fail the way you indicate.

  6. Thanks to TheLibrarian from:

    Tricky_Dicky (16th November 2009)

  7. #5

    Join Date
    Jun 2009
    Location
    Birmingham
    Posts
    598
    Thank Post
    92
    Thanked 72 Times in 64 Posts
    Rep Power
    24
    With you now, thank you. I wasn't looking close enough.

    Cheers

  8. #6
    TheLibrarian
    Guest
    Glad I could help.

SHARE:
+ Post New Thread

Thread Information

Users Browsing this Thread

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

Posting Permissions

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