Data Match/Unmatch amongst two sheets

Hi,

I’d like to know how quickly and accurately I can create or manupulate the data.
There are two worksheets (Report 1 and Report 2), both contains ‘Product Name’, 'Location’, and ‘Value’.

I would like to see on Report 1:
1) ‘Location’ being a key
1-1. Location data that matches on both Report 1 and 2.
1-2. Location data that is not on Report 2 (only on Report 1)
1-3. Location data that is not on Report 1 (only on Report 2)

I tried by using VLOOKUP and ISERROR inside IF, it kind of did jobs partially but I didn’t find conclusive.


2) ‘Value’ being a key
For above 1-1, whether the value is same or not.
I tried by using AND inside IF. However I couldn’t really be completely happy as the above 1 manipulation was not complete to begin with.


I can send you an excel with simple example of sheets, please let me know how to provide you if you'd like one.


Best regards,
Kuniko