Hi there;

I am facing a problem as below:

I have 2 work sheets: Sheet1, Sheet2. Sheet 1 is prepared by myself and is sent to supplier in return of which supplier send me back Sheet 2.

Now both of the sheets contain 2 columns:

Column A Column B
(Item No.) (Quantity)
MKB231 2
MKT123 1
EZFL16 1
IMF30F 2
IMFL29 5

When supplier sends me the sheet back; I have two objectives: One is to check that no Item is missing. for that i simply put vlookup in my sheet, i.e =vlookup(A1,sheet2!$A$1:$A$100,1,false). This gives me correct result and notifies me if some item is missing.

Second objective is that i should check quantity as well. Note that the quantity of one particular item should match that item in Sheet2 and not with any other. i.e. MKB231 in "Sheet1" has 2 as quantity so it shall match MKB231 quantity cell (in sheet2) and notify me if there is any change.

I applied vlookup but result was not correct in the sense that supplier sent me 1 piece of MKB231 but quantity 1 was already there even though with some other reference so i was not able to judge if it is really correct or not...

does any body has any solution?