How to Merge 2 Microsoft Excel tables?

Step 1 - Select your Main table (Master Table).

Select the Main table to which matching data will be copied.



Tip: Before you run the Merge Tables Wizard, just select a cell of your main table, and the whole table will be selected automatically.

---

Step 2 - Select a Second table (Lookup table).

Select the Lookup table in which matching data will be searched (looked up).

If the Lookup table is not in same worksheet, first select the spreadsheet you need from the opened workbooks tree.

---

Step 3 - Select matching columns.

In the dialog box you see the list of columns from the Main table.

Once you check a column from the Main table, you will see a pop-up menu from which you will select a matching column of the Second table.

Tip: Columns with the same names are selected automatically.

---

Step 4 - Select the action for matching data.

In the dialog box, you see a list of columns from the Second table (Lookup table).

Check a column, and select the action for it:

• Add to the end of the Main table.
• update values in the selected column of the Main table. Updated values will be highlighted in color (you can choose the color from the pop-up in the top-right corner.

If you check the "Insert the column with update status" checkbox in the top-left corner, the add-in adds "Updated" column to your Main table. In this column, updated rows will marked "TRUE", non-updated - "FALSE".

AMerge Tables Wizard for Microsoft Excel

For example, suppose you have 2 Microsoft Excel tables (lists) - "Orders" and "Prices", they both have a column "Product ID". You want to add a correct price and product description from the second table (lookup table) to you main table. Free to try it.