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



Merge Tables Wizard for Microsoft® Excel®

Microsoft Office Marketplace logo

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



You have two separate Microsoft Excel worksheets with common columns e.g. personal number or name and you want to merge them into one. You need to go through each row in the Main (Master) spreadsheet, identify the matching row (by index fields) on the second spreadsheet and update in the main spreadsheet selected fields sourced from the second (lookup) spreadsheet, or add some columns from the second list 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).

Two Microsoft Excel lists with common column

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.

Download 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 two different Microsoft Excel files. The intuitive and user-friendly interface of the wizard makes the join process fast and easy. Rows from the two tables with different number of columns will be matched perfectly without copying and pasting. Non-matched rows will be added to the end of the table (Figure 3 in the picture below).

Orders table with price & description columns

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





 

Product information

 
Merge Tables Wizard for Excel box
Merge Tables Wizard for Microsoft Excel

version: 1.6.1



Risk free - 30-day money back

Get your money back if not satisfied

1 user license works on 3PCs

At work, at home, and on your laptop

Get delivery in minutes

For credit card payments

All forms of payment

You can pay with any major credit cards, bank/wire transfer, PayPal

Purchase via PayPal

Just select "PayPal" as a Payment option on the purchase page

Volume discounts

You can save up to 30%

Free upgrades

Upgrade to minor version for free and to major version at half price.

Free support

If you need any help, just let us know

$ 29.95



 

Related links

 




 

SPECIAL OFFER

 


 

Product list

 

Ordering information

You can purchase a license of Merge Tables Wizard for Excel online with any major credit cards, bank wire transfer, check, PayPal or order by fax.

You can buy this add-in as part of the Excel add-in collection and save 60% off.

All prices are in US Dollars

Quantity1 license priceVolume discount

1 - 5

$ 29.95

0%

6 - 10

$ 26.95

10%

11 - 30

$ 23.95

20%

31 - 50

$ 19.95

30%

51 & more

Contact us for a special price

Quantity

Sum, $:





Have a question? Feel free to ask

Your Name

Your e-mail

Subject

Please enter the characters shown

  • 30 days moneybackUnconditional 30-day money back guarantee
    If you are not satisfied with any of our products within the first 30 days from your purchase, you can obtain a no questions asked refund.
  • All forms of payment
    Credit CardsYou can pay with any major credit cards, or use other methods of payment: certified check, bank wire transfer, Switch/Solo, cash, PO.
  • Purchase via PayPal
    PayPal logoYou can order our add-ins via PayPal. Just select "PayPal" as a Payment option on the purchase page.
  • Instant delivery
    All of our products can be downloaded immediately so you can have the add-in in minutes if you pay by credit cards.
  • Secure order process
    The ordering process is safe and performed by a well-known e-commerce service, Share-it!, that provides secure order processing worldwide.
  • Free upgrades
    Registered users may upgrade to minor version upgrades for free and to major version upgrades at half price.
  • 1 license = 3 PCs
    With one license of our products you can install and use them on three computers: on your work and home PCs, and on your laptop.
  • Free support
    If you have any questions or troubles with our add-ins, just let us know and we will provide you with a solution.