Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Vlookup

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi all

    I seem to have an incredibly frustrating problem with VLookups. I rely on it as I need to analyse thousands of part codes, yet I just don't seem to be able to trust it.
    I have taken a sample from the 2 s/sheets concerned where I'm attempting to look up a cost for a part code when the code exists in the other s/s. It returns a #n/a to me when it's blatantly obvious that the code does exist. I suspect some sort of formatting difference but I can't seem to find it myself.
    Could anybody take a look or does anybody know what it could be??
    Thanks

    Matt

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Matt:

    Check out the *Dreaded* Vlookup at:

    http://www.thewordexpert.com/tipwarez.htm#MyVlookup

    It probably explains your problem too.
    ~Anne Troy

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Matt, the data type matters!!!

    "17863" <> 17863

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mark

    Couldn't be a little more specific could you!?

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    there might be spaces after the numbers and/or letters in your source and not in your destination, or vice versa that might not be visible. Use the trim function to remove these space if they exist.


    It's never too late to learn something new.

    Ricky

Some videos you may like

User Tag List

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
  •