Vlookup with multiple criteria

[patsir]

Hi All,

I am trying to look for a way to VLOOKUP with two value to get a precised match.I tried to search on Web and found that many different way to do similar things, but Im not quite understand the theory behind it.

I have a raw data table like below:
Parts Number Qty ID
12345 1 XYZ
12346 2 ABC
12346 1 XYZ
12345 2 ABC

When I ordered the parts for each order, I have a specific ID for it, then once when I received the parts, I would like to know which ID it belongs to, in the beginning with not much data, I can easily to distinguish it, but when I have too much data, I found that the parts number may have many line and I am not sure which one it is, so I am thinking to VLOOKUP one more value which is the Qty to help me get an exact match. I saw the VLOOKUP+SUMPRODUCT on web for other similar case, and COUNTIF, I really felt confused....