Formula Table Trouble...
Prep for a pre-employment Excel test with Job Test Prep
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.

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
  •  

 

 
DMCA.com