Matching 2 different data sets with client data

Hi MrMilo 

Not mandatory but easier, format the data in your 2 files https://support.microsoft.com/en-us/office/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370. For below steps it's assumed your tables are named (https://support.microsoft.com/en-us/office/rename-an-excel-table-fbf49a4f-82a3-43eb-8ba2-44d21233b114) respectively Table1 and Table2

From a new workbook (assuming this is what you want):
- Go to Data (tab) > Get Data > From File > From Excel Workbook > Select 1st file
- In the Navigator > Select Table1 > At the bottom click on the arrow down next to "Load" > Load To... > Only Create Connection > OK
- Go to Data (tab) > Get Data > From File > From Excel Workbook > Select 2nd file
- In the Navigator > Select Table2 > At the bottom click on the arrow down next to "Load" > Load To... > Only Create Connection > OK

On the right side of your screen you see the Queries & Connections pane with 2 queries:

- Right-click on Table1 > Merge

- Follow the steps - Starting at #3 - in shttps://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9