The Merge Tables Wizard is an easy-to-understand alternative to Excel Lookup/Vlookup functions. This smart tool can match and merge two worksheets in Excel 2013-2003 in seconds. You can use one or several columns as the unique identifier, update existing columns in the master worksheet or add new from the lookup table, add non-matching rows to the end of the table after all other data if needed. Free download at http://www.ablebits.com/mergeexcel
Publisher description
With Ablebits.com Merge Tables Wizard you can lookup and combine matching data from 2 Excel worksheets in seconds. The add-in is an easy-to-understand alternative to Microsoft Excel Lookup and Vlookup functions. It perfectly merges matching data from two tables whether they are located in the same or in two different Microsoft Excel files. The intuitive and smart wizard provides a step-by-step guidance through the join process while additional capabilities and advanced options of the add-in ensure exactly the results Excel users need. Those who do a lot of data analysis in Excel will definitely appreciate the following capabilities of the Merge Tables Wizard: - Ability to find and copy matching data in seconds. - Auto-detecting all matching columns. - Using one or several columns as matching criteria. - Comparing Excel lists from different workbooks. - Adding new columns to the main table or updating values in existing columns. - Highlighting updated data in any color. - Updating only empty cells so that the existing content won't get overwritten. The add-in works in all versions of Microsoft Excel from 2003 to 2013 (32- and 64-bit). Get started with a free download at http://ablebits.com/mergeexcel
Related Programs
Split Table Wizard for Microsoft Excel 1.0
Split a worksheet into several tables
Excel Join (Merge, Match) Two Tables Software 7.0
Combine two tables in MS Excel.
Merge Cells Wizard for Excel 3.0.8
Merge Excel cells preserving all data.
Export Excel Worksheet Using Excel to Outlook
Tools for Excel Tables 4.0.4
Manage huge tables in Excel quick and easily.