Laurel J. answered • 07/02/19
Install an add-in called Ablebits. Once Ablebits is installed it will appear in the Excel tool ribbon.
Highlight the two tables that you wish to merge (either from two seperate tabs in one Excel file or different Excel files) and then click on Ablebits.
Once you click on Ablebits there willl be a puzzle piece icon that will allow you to merge two tables.
Click on that icon and follow the on-screen prompts that will ask you if you want to add more columns to your main table or update (replace existing info with new info) data in the new table.
The "look up table" is the table where you will be drawing the data that you want to merge into your "main table".
You will be able to match the tables according to column headers - which will help ensure that the merged data aligns with information from the look up table and the main table
