Vlookup and matchint values

[mirinjawbro]

Hello again.

I have 2 tables.

Both have item numbers and locations

I need to find which item numbers are in both but do not have the same locations.

Some item numbers appear more than once in both tables. Some item mumbers with location may appear more than once.

Thanks

 

[mirinjawbro]

Solved. Was more of a how to sort the data than the lookups etc.

I made a new tab.

Kept table 1 data the same. Then added only the data that was in both next to jt ( item number and location) Then vlookup for both. Thanks