Combining Tables in PowerPivot to ID Missing Data

[The Doctor]

Hello Ninjas,

I'm using PowerPivot for the first time thanks to an Excel upgrade at work. I'm now trying to combine 2 tables, the first table includes a complete inventory valuation for the end of the month. The second is a table that combines the individual count sheets from our full inventory count.

I need to compare the two tables to find which lot numbers appear in the final table that are not in the count sheets. If the lot is in the final but not in the count, then I need to see the location where it was counted, which is another column in the final table.

Hoping this is basic PowerPivot functionality.

Thanks,
The Doctor

 

[The Doctor]

A few hours later it occurs to me that a file might help to see what I'm needing. Hopefully, this can help generate a response.

https://www.dropbox.com/s/pjwgd62mswbw1oi/PowerPivot Problem.xlsx


Thanks again,

The Doctor