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 2010 32-bit, 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 and name. You want to merge them into one table or update the 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 the selected rows 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" and they both have a column with the "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 time consuming? Probably it is such 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 the matching data in Excel worksheets a breeze. This handy vlookup add-in quickly merges two Microsoft Excel tables into one by matching values in the necessary columns.

The two tables can be located in the same Microsoft Excel file or in two different Excel files. The intuitive and easy-to-understand wizard will guide you through the merge process. Rows from 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 (Number 3 on the picture below). You can add a status column that will reflect all changes made to your master table after merging. You can color the 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 the matching criteria.
• Compare Excel lists from different workbooks.
• Add new columns to the main table or update the data in existing columns.
• Add non-matching rows to the end of the table below all other data.
• Highlight the updated data in any color.
• Update only empty cells in your Master Table if you don't want to overwrite the existing values;
• Add a Status column to the Master table that will reflect the changes and mark rows as: "Updated", "Non-updated", "New row".
• 100% support of Microsoft Excel 2007 and 2010: Ribbon interface, one million rows and so on.

How Merge Tables Wizard works

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

Merge Tables Wizard for Excel is compatible with

• Operating System: Microsoft Windows 7 (x86, x64), Windows Vista (x86, x64), Windows 2003, Windows XP.
• Microsoft Office Microsoft Excel 2010 32-bit, 2007, 2003, XP (2002), 2000.

Try before you buy

Download a fully-functional 15-day evaluation version of Merge Tables Wizard for Excel and try for yourself.