vLookUp problem. can't figure out a table

[EX650R]

I'm trying to do a vlookup on sheet "Product List". I have to look up all the matching part numbers in column A on "sheet2"

Once I find all matching part numbers I need to update the HTS codes in column F of sheet "Product List" with the respective HTS code in column C of sheet2.

I've tried vlookups, Match, Lookup. I can't figure out what process will get me my answer.

Guru's, please any help?

[Paul]

Hi EX650R,

A standard VLOOKUP should work just fine, e.g.

=VLOOKUP(B2,Sheet2!A:D,3,0)

You will get an #N/A error in any row where the lookup value from column B is not found in column A on Sheet2. In your sample data, row 111 works (code 1005072).

[EX650R]

Thanks a lot Paul.

The Guru's on this forum work Magic with Excel!

[rcm]

I tested match()using the "text" version of the leftmost 7 digits for product code in sheet2 and gave me some matches

disregard the smaller version (485K)