matching Items, quantity and price from 2 diferent sheets

Dear all, one of my job is to audit data implimented on two diferent system.
I want to match item code to quantity and sales amount in each of two sheets, and I want to catagorize them at 3 levels
1st no matched item
2nd matching item but diferent quantity
3rd matching item, matching quantity but diferent price

is this possible to do?

Thanks

Hi

I think it is.

Would you like to upload a small sample workbook?

A way to do this, is using these 3 Formulae. One for eatch requietment.

=IF(COUNTIF(Sheet2!$B$3:$B$148;Sheet1!B3)>=1;"Matced";"No")

=IF(AND(COUNTIF(Sheet2!$B$3:$B$148;Sheet1!B4)>=1;SUMPRODUCT((Sheet2!$B$3:$B$148=Sheet1!B3)*(Sheet2!$C$3:$C$148))>=1);"Matced";"No")

=IF(AND(COUNTIF(Sheet2!$B$3:$B$148;Sheet1!B5)>=1;SUMPRODUCT((Sheet2!$B$3:$B$148=Sheet1!B4)*(Sheet2!$C$3:$C$148))>=1;SUMPRODUCT((Sheet2!$B$3:$B$148=Sheet1!B3)*(Sheet2!$C$3:$C$148=Sheet1!D3)*(Sheet2!$D$3:$D$148<>Sheet1!E3))>=1);"Matced";"No")

Then, use Auto filter and if you want, copy-paste as 3 different lists.

Let me know...