How to merge and update table from another table in Excel?

In Excel, if you have two tables on different sheets and need to update one table with data from the other, you can do this quickly and efficiently. This tutorial will show you how to merge and update tables using either the VLOOKUP formula or Kutools for Excel, depending on your preference.

Merge and update table from another one table with VLOOKUP

Merge and update table from another one table with Kutools for Excel

Merge and update table from another one table with VLOOKUP

Here I have a VLOOKUP formula that can handle the job.

1. Select one blank cell next to the table 1 which will be updated, for instance, D2, and type this formula =IFERROR(VLOOKUP($A2,'table 2'!$A$1:$C$5,COLUMN(A1),FALSE),""), then drag autofill handle right and down until blank cells appear.

In the formula, $A2 is the first content in the key column you want to update table based on, 'table 2'!$A$1:$C$5 is the new table, COLUMN(A1) is the key column.

2. Then format the cells as the specified formatting you need

Now both tables are merged and placed in the worksheet of the main table.

Merge and update table from another one table with Kutools for Excel

Kutools for Excel’s Tables Merge also can quickly handle this job.

1. Select the table you want to update, and click Kutools Plus > Tables Merge.

2. In the Tables Merge wizard, select the new table you want to update based on in Select the lookup table section.

3. Click Next, select the key column you want to update based on.

4. Click Next, check the column(s) you want to update.

5. Click Next, check the column(s) you want to add from new table to the main table.

6. Click Next, and set some options about main table, update data(You can ignore this if you do not need).

7. Click Finish. There will pop out dialogs to remind you some information, just close them. Now the main table has been updated.

Demo: Merge and update table from another one table with Kutools for Excel