Lookup and merge matching data in Microsoft Excel worksheets.

Merging Microsoft® Excel® tables by matching values - vlookup add-in.

Merge Tables Wizard for Microsoft® Excel®

For Microsoft Excel 2007, Excel 2003, Excel XP (2002), Excel 2000 .

Just imagine this: you have two Microsoft Excel worksheets with common columns e.g. personal number or name. You want to merge them into one, or update information in your main spreadsheet. If you decide to do it manually, you will have to go through each row in the main spreadsheet to identify the matching row on the second spreadsheet. After that you will spend even more time on updating selected rows sourced from the second spreadsheet, or on adding some columns from the lookup table to the main list.

For example, suppose you have 2 Microsoft Excel tables (lists) - "Orders" and "Prices", they both have a column "Product ID". You want to update prices and add product descriptions from the Second table (lookup table) to your Main table (master table).

The task sounds too complicated and task consuming? Probably yes, if you try to do it with standard Microsoft Excel Match, Lookup, or Vlookup. But definitely not, if you have the Merge Tables Wizard for Microsoft Excel.

Our Merge Tables Wizard for Microsoft Excel makes finding and copying matching data in Microsoft Excel worksheets a breeze. This handy vlookup add-in quickly merges two Microsoft Excel tables into one by matching values in corresponding columns.

The two tables can be located in the same Microsoft Excel file or in two different Microsoft Excel files. The intuitive and easy-to-understand wizard will guide you through the merge process. Rows from the two tables with different number of columns will be matched perfectly without copying and pasting.

Merge results will be exactly as you expected

To ensure that you get exactly the results you need, the Merge Tables Wizard provides a number of really wonderful features. For example, you can choose to have the rows that appear only in the lookup table added to the end of the master table (Figure 3 in the picture below). You can add a status column that will reflect all changes made in your master table after merging. You can color updated cells so that you can see all changes at a glance, and more.

With Merge Tables Wizard for Microsoft Excel you can

• Find and merge matching data in 2 tables in seconds following 5 easy steps of the Wizard.
• Use one or several columns as matching criteria.
• Compare Microsoft Excel lists from different workbooks.
• Add new columns to the main table or update data in existing columns.
• Add non-matched rows to the end of the table after all other data.
• Highlight updated data in any color.
• Add a Status column to the Master table that will reflect changes and mark rows as: "Updated", "Non-updated", "New row".
• 100% support of Microsoft Excel 2007: Ribbon interface, one million of rows and so on.

Merge Tables Wizard for Microsoft Excel is compatible with

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

How Merge Tables Wizard words

See 5 steps to find and merge matching data in Excel tables