How to Update/Merge Tables By Matching Column From Two Worksheets/Workbooks in Excel?
Tags: kutools, updateormergetablesb
Published: 2020-08-06 10:28:53

---
title: How to Update/Merge Tables By Matching Column From Two Worksheets/Workbooks in Excel?
published: true
date: 2020-08-05 10:43:21 UTC
tags: Kutools,UpdateorMergeTablesb
canonical_url: https://geekexcel.com/how-to-update-merge-tables-by-matching-column-from-two-worksheets-workbooks-in-excel/
---

## Update or Merge Tables By Matching Column From Two Worksheets or Workbooks in Excel:

In this article, we are going to see the steps to **Update or Merge Tables By Matching Column From Two Worksheets or Workbooks in Excel** 365 using **Kutools**.

Kutools has a special function of the **Tables Merge option, ** by using this function you can easily complete your work with several clicks. It will help you to update or merge tables in a short time.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 120 features that are used for completing a difficult task easily. You have to install it before using it.


## How to Update Table With New Data in Another Table By Matching Column in Excel?

Here we come up with the Steps to **update the table with new data in another table by matching column** , do as follows.

- You need to **enable the Merge Tables feature**. On the **Kutools Plus** Tab, Choose the **Tables Merge** option.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-5.png)

- Now, it will open the **Tables Merge – Step 1 of 5 dialog box** , You have to select the finding range/table using the given button under the **Select the main table** section.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/9-1.png)

- Then, Open a new worksheet where create a new table, that is your lookup table.
- **Select** the **range of the lookup table** using **Table Merge 1 of 5 dialog box**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-5.png)

### Notes:

- If your lookup table is in another sheet of the same workbook, go to that sheet and select the table.
- If your lookup table is in New workbook, then select the workbook name from the **Workbook & Sheet** option. It will open the workbook you can easily select the table.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-5.png)

- Now, Click the **Next** button in the dialog box.
- It will display the **Table Merge – Step 2 of 5 dialog box** , select the matching column that you want to update a table based on.
- **Check** the **Case Sensitive** option ( the updated and lookup data identified as case-sensitive ) as your wish.
- Then, click the **Next** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-5.png)

- After clicking the next button, it will open the **Table Merge Step 3 of 5 dialog box** , **select the column** that you want to update, and press the **Next** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/6-5.png)

### Note:

- If the Lookup table contains more columns than the main table, it will open the **Table Merge – Step 4 of 5 dialog**  **box** where you need to select the column and click the **Next** button.
- If you have the same number of columns in the main table and lookup table, it will open the **Table Merge – Step**  **5 of 5 dialog box** automatically.

Here is the screenshot of **Table Merge – Step 5 of 5 dialog box**. Kindly, specify the given options in the dialog box as you need.

- Select any options under the **Add Options** , **Update Options** , and **Highlight Options category**.
- Click the **Finish** button to get the result.
- Refer to the below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/7-2.png)

- Now, you will get the updated table like the below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/8-1.png)

## How to Merge Table With New Data Column By Matching Column in Excel?

To merge the table with a new data column by matching column in Excel, follow the below instructions.

- Select the main table, then on the **Kutools Plus** tab, Choose the **Tables Merge** option.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-6.png)

- It will open the **Table Merge Step 1 of 5 dialog box** , In the Select, the main table option, choose the range by clicking the given button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/11.png)

- Then, Select the Lookup table from another worksheet or workbook. Specify the range of your lookup table in the **Table Merge Step 1 of 5 dialog box.**

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/12.png)

- Now, Click the **Next** button.
- It will display the **Table Merge Step 2 of 5 dialog box** , where you have to select the matching column to update the table.
- Click the **Next** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/13.png)

### Note:

**Check** the **Case Sensitive** option (the updated and lookup data identified as case-sensitive) as your wish.

- After clicking the Next button, it will open the **Table merge – Step 3 of 5 dialog box** , in that dialog box no need to select any column, you can directly click the **Next** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/14.png)

- In the Table Merge – Step 4 of 5 dialog box, select the **Main table columns** option to select all the columns that you want to merge to the main table.
- Then, press the **Next** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/15.png)

- Now, in the **Table Merge – Step 5 of 5 dialog box** , specify the settings options as you need.
- Click the **Finish** button to see the result.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/16.png)

- Now, you can see your main table merged with new columns ( from the lookup table ).
- Refer below example image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/17.png)

### Added Information:

Let’s see the Options in the **Setting Options** dialog box.

1. **Add mismatched rows to the end of the main table** – It will add the unmatched values in the lookup table at the end of the resulted main table.
2. **In Add duplicated matched rows** – It will add the duplicated matching rows at the end of the main table.
3. **Add a status column** – You can mark the updated cells the status column by selecting this option under the **Add Options** section.
4. **Update Options** – You can choose either **Only update the cells when there is data in the lookup table** or **Only update the empty and new cells in the main table** option as you need.
5. **Highlighting options** – You can highlight the updated cells by specifying the **font** or **background** color from the drop-down list.

## Wrap-Up:

In the above article, you can clearly understand how to **Update or Merge Tables by Matching Columns from two**  **worksheets or Workbooks in Excel 365** using **Kutools**. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to find Vlookup and Return the Matching Values from Multiple Worksheets?](https://geekexcel.com/how-to-find-vlookup-and-return-the-matching-values-from-multiple-worksheets/)
- [How to Create a Drop-Down List in Excel 365? -Using Kutools](https://geekexcel.com/how-to-create-a-drop-down-list-in-excel-365-using-kutools/)