Merge Two Tables is designed to quickly combine Excel worksheets by matching columns. The tables of interest can be located in the same workbook or in two separate Excel files and have different numbers of rows and columns.
With Merge Tables Wizard for Excel you can:
Use one or several key columns as the lookup criteria.
Add new columns to the main table or update the existing ones.
Add non-matching rows to the end of the table after all other data.
Pull additional matches from your lookup table.
Color updated rows or mark the changes in the status column.
Update only empty cells in your main table if you don't want to overwrite the existing values.
Update only if cells from lookup table contain data.