Quote Originally Posted by patsir View Post
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....
It appears that you want the WIP No. as your result, but in looking at your data, the matching value for first item has a blank for its WIP No., so what did you want returned from the formula in that case? Also, what if there are two or more rows that match your search criteria... what did you want returned in that case?