Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: vlookup problem

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

    Default

    I have a list of part #s, prices, etc. in sheet 1, and part #s and descriptions on sheet 2. I need to bring the description from the sheet 2 into the corresponding row Column C on sheet 1. I have tried numerous vlookup formulas, but they all return #n/a as if the part # does not exist on the 2nd sheet, when in fact it does.
    The formula I think is right is:
    =VLOOKUP(A2,Sheet2!$A$2:$B$4210,2)
    where A2 = the part # I need the description for, and Sheet2 column a contains a list of part #s, and column B contains the descriptions.

    I'm thinking that the problem has to do with cell formatting, but I have tried everything I know to assure that column A on each sheet share the same formatting.

    Can anyone help?

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did you sort your columns?

  3. #3
    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

    Try =VLOOKUP(A2,Sheet2!$A$2:$B$4210,2, FALSE)

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, however I have both 4 digit and 5 digit part #s, so the 4 digit #s don't sort to the top.

  5. #5
    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

    Make sure that the data type of your lookup_value is the same as the values in the left-most column of your table_array. These values must match in every respect... no trailing spaces allowed.

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Steve,

    I've tried that too... same result.

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Steve,
    I've tried that too... same result.

  8. #8
    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

    On 2002-04-26 13:11, hisdwelling wrote:
    Yes, however I have both 4 digit and 5 digit part #s, so the 4 digit #s don't sort to the top.
    Hint, hint... that's because your numbers are really text (e.g., "1234"). Guess what? "11111" will sort ahead of "1234.

  9. #9
    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

    =VLOOKUP(A2,Sheet2!$A$2:$B$4210,2) should be=VLOOKUP(A2,'Sheet2'!$A$2:$B$4210,2)

  10. #10
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I ran the =trim function on all of the unit# cells. I know there aren't any leading or trailing spaces.

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
  •