Help Using Power Query to compare

[lgsikaffy]

Hello,

Can someone please advise on how to use Power Query to compare data between two spreadsheets?

I have one spreadsheet that is my Master Data. We have set Center ID's that based on that you would have a specific department, brand, bonus, country, business unit.

Then I have a spreadsheet with data entry records, I need to match each employee records to the master data. If the Center ID is a match, but the rest aren't, I need it to be highlighted somehow.

See my spreadsheet for Reference

[alansidman]

Is the CCID and the Center ID the same. Or is some other field representative of the Center ID. You really need to keep your descriptions orderly. We are not mind readers here.