Copy matching data from lookup Excel table to main one

Merge Tables Wizard for Excel

Handy add-in to look up and copy matching data from Excel lists. E.g. you can merge matching rows from an Excel table of product numbers and prices to the table with product IDs and descriptions..

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

15-days fully-functional trial version

2.1 MB

3 possible ways to find and match in Excel:

1. Find matching data, then copy and paste them manually.
   It is absolutely free, but calculate the time wasted on processing thousands of rows. And, are you sure you made no mistakes?
2. Use of standard Excel functions, such as Excel's Match, Lookup, or Vlookup, will probably bring you the result you need. But, you will have to study these functions first (Excel help and Microsoft knowledge base), 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

Merge Tables Wizard in detail

With the Merge Tables Wizard for Microsoft Excel you can quickly find matching data in one Excel list and copy them to another.

For example, if you have a price list of product numbers and prices in one Excel worksheet and just product numbers in an invoice worksheet, the Merge Tables Wizard for Microsoft Excel will match the numbers in the invoice to those in price list.

Lookup and copy matching data in 4 easy steps

Open the Merge Tables Wizard by pressing Ctrl+Shift+M hotkey, or go to Excel Menu Tools -> Merge Tables Wizard.

3 - Select matching columns

1 - Select your Master Table

2 - Select a Lookup table

The Merged Excel table

4 - Action for matching data

Enjoy the results

What Merge Tables Wizard for Microsoft Excel gives you:

1. Finding and merging matching data in seconds.
2. Using one or several columns as matching criteria.
3. Comparing Microsoft Excel lists from different workbooks.
4. Adding new columns to the main table or updating data in existing columns.
5. Highlighting updated data in color.
6. Adding a column that shows which rows were updated, and then filtering updated or non-updated columns.
7. 100% support of Microsoft Excel 2007: Ribbon interface, one million of rows and so on.

Merge Tables Wizard for Microsoft Excel works with

• OS: Microsoft Windows® Vista (x32, x64), Windows 2003, Windows XP, 2000, ME, 98
• Microsoft Excel 2007, Excel 2003, Excel XP, 2002, and Excel 2000.

Download Merge Tables Wizard for Excel

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

See also in "Excel - Find / Select Excel data"

• Advanced Find & Replace for Excel - Find and Replace in all opened Excel workbooks & worksheets.
• Advanced Excel Select - Select Excel spreadsheet cells with the same format by one click.