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

Thread: Formula Table Trouble...

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Detroit
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need some help with the VLOOKUP. I have created a table in Colunm A & B like this..

    F8ZZ16054AA YR3316044AA
    F8ZZ16055AA 1R3316045AA
    YR3Z16055AA 2R3316F001AB
    1W1Z16138AA 2W138A297AA
    F4ZZ16707A 1R3316774AA
    XR3Z9B081BA XR339A179AD
    2C3Z16K007AA 3C3416K007AB

    My formula in D1 looks like this.. =VLOOKUP(C1, A1:B7,2) With my input being C1...Problem is when I input the first # and the second # I get the b5 output..not the b1..? When in use A3...i get B7... what am I doing wrong..?

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The column you are looking in , A in your case, must be in ascending order or you will get erretic results. Try sorting you table and see if that helps.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Ontario
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If I might suggest, no need to sort column A if you add a range lookup of FALSE. This will return first exact match even if column A unsorted.
    to add FALSE in your formula, after the 2 add ",false" (without the quotes).

  4. #4
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Neat. I'ld never noticed that in the help file before.

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
  •