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.

Download (15163 KB) Website Link to this page