I have a sheet with raw data - from which a pivot table was created for us.
It contains values as such:

Location ID Type of Hardware Number of Units

In a separate sheet, I have location id and number of units.

I want to create a new sheet that compares the location ids in both sheets
and then tell me when there is a discrepency in the number of units.

Help?