Copy matching data from lookup Excel table to main one

Merge Tables Wizard for Microsoft Excel

This add-in can swiftly merge matching data from two Microsoft Excel tables with any number of columns and rows. .

Merge Tables Wizard for Excel is an add-in for Microsoft Excel 2010 (32-bit and 64-bit), Excel 2007, Excel 2003, Excel XP, and Excel 2000.

15-days fully-functional trial version

9.7 MB

3 possible ways to find and match in Excel:

1. Find matching data, then copy and paste them manually.
   This method is absolutely free, except for the time you would spend on comparing thousands of rows. And, how can you be sure you made no mistakes?
2. Use standard Excel functions, such as Excel's Match, Lookup, or Vlookup. ,Of course, you will have to study these functions first, secondly you will have to write new formulas for each new table, and thirdly, what if you need to match data by comparing several columns?
3. Profit by time-saving Merge Tables Wizard for Microsoft Excel and have the results in minutes!

Merge Tables Wizard in detail

With the Merge Tables Wizard for Microsoft Excel you can you can quickly combine data from 2 Excel tables. The add-in flawlessly finds matching data and updates corresponding rows in your main worksheet or adds new rows to the end of the main table.

For example, imagine that you have a Price List with product numbers and prices in one Excel worksheet and only product numbers in the Invoice worksheet. Using the Merge Tables Wizard you can quickly match the product numbers in both worksheets and copy prices and other related information from the Price list into the Invoice worksheet or vice versa.

Lookup and copy matching data in 4 easy steps

Open the Merge Tables Wizard by pressing Ctrl+Shift+M, or click the Merge Tables Wizard button on the Excel Ribbon.

3 - Choose matching columns

1 - Select your Master Table

2 - Select your Lookup table

Your Master table is updated

4 - Choose an action for matching data

Enjoy the results

What you can do using the Merge Tables Wizard for Microsoft Excel:

1. Find and merge matching data in seconds.
2. Use one or several columns as matching criteria.
3. Compare Microsoft Excel tables from different workbooks.
4. Add new columns to the main table or update data in existing columns.
5. Add non-matching rows to the end of the table underneath all other data.
6. Color updated rows.
7. Add a column that shows which rows were updated, and then filter updated, non-updated or new rows.
8. 100% support of Microsoft Excel 2007 and 2010: Ribbon interface, one million of rows and so on.

Merge Tables Wizard for Microsoft Excel works with:

• Operating System: Microsoft Windows 7 (32-bit and 64-bit), Windows Vista (32-bit and 64-bit), Windows 2003, XP, 2000.
• Microsoft Excel 2010 (32-bit and 64-bit), Excel 2007, Excel 2003, Excel XP, and Excel 2000.

Download Merge Tables Wizard for Excel

• 15-days fully-functional trial version (9.7 MB)

See also in "Excel - Merging cells, columns, rows, etc."

• Merge Cells Wizard for Microsoft Excel - Addin for Excel to merge cells, columns, rows.
• Text Manager for Microsoft Excel - Change case in Excel, Join text to one cell, Remove spaces, etc..