Excel Spreadsheet Lookup Tool is what Turbo Excel VLookup was built for: match data across workbooks, without opening the formula bar or worrying about column counting, exact-match arguments, or broken external references.
The sections below cover how the matching process works, what's included, who it tends to fit best, and how it compares to writing the equivalent VLOOKUP formula by hand, so you can decide quickly whether it fits your own spreadsheets.
- Open the Base File that needs new data added to it.
- Open the Lookup Table containing the source records.
- Select the shared ID or key column from each file using the dropdown selectors.
- Select the output columns you want copied across from the Lookup Table.
- Run the match and export the completed file as XLSX, CSV, or TSV.
Matching still comes down to the same basic idea as a manual VLOOKUP - given an ID in this table, find the related value in another file:
| Employee ID | Name | Department | Salary |
|---|---|---|---|
| E101 | Asha Rao | Marketing | 54000 |
| E102 | Vikram Shah | Finance | 61000 |
| E103 | Priya Nair | Sales | 48000 |
Instead of writing =VLOOKUP("E102", A2:D4, 3, FALSE), the same result comes from picking the Employee ID column in each file from a dropdown and ticking Department as a return column.
- Left, Right, Inner, Full Outer, Anti, Semi, and Cross join modes
- Combine columns from two files into a single, clean output file
- Automatic handling of column name conflicts between the two files
- A Data Cleaning tab to trim, normalize, and standardize columns before merging
- A full session report of every join or merge that's been run
Useful whenever two related but separate spreadsheets need to become one combined file - a customer list and an order history, an inventory sheet and a supplier catalog.
The join modes make it possible to see not just matches, but also which records exist in only one of the two files.
VLOOKUP can only pull data in one direction and return one column per formula. Proper join modes - Inner, Left, Right, Full Outer - handle cases a single VLOOKUP formula was never designed for, like identifying which records exist only in one of the two files.
Inner join is the right choice when only rows that exist in both files matter; Left or Right join keeps every row from one file regardless of whether a match was found; Full Outer join keeps everything from both files.
When it's unclear which is needed, running an Inner join first and checking the match-rate report is a quick way to gauge how much overlap actually exists between the two files before deciding.
What join types are supported?
Left, Right, Inner, Full Outer, Anti, Semi, and Cross joins are all available.
Can I see which rows exist in only one of the two files?
Yes, Anti and Semi join modes are built specifically to surface that kind of difference.
What file formats are supported?
XLSX, XLS, and CSV files are supported for both input and output.
Does the source file need to stay open while matching runs?
No, both files are loaded directly by the app and don't need to remain open in Excel.
What happens to rows that don't find a match?
Unmatched rows are clearly reported in the match statistics rather than silently left blank or causing an error.
Is a Gumroad license required to use the full feature set?
Yes, a license key activates the full version; activation details are covered on the Support and Activate pages.
Can the same match be re-run later on updated files?
Yes, the same column mapping can be reused any time the source files are refreshed with new data.
Does it work with very large spreadsheets?
Yes, the matching engine is built with parallel processing to handle large files without slowing down.
Is any coding or macro knowledge required?
No, the entire process is handled through a point-and-click interface with no code involved.
Does this replace VLOOKUP entirely, or work alongside it?
It can be used instead of writing a VLOOKUP formula, or alongside existing formulas in the same workbook - there's no conflict either way.
Does it work on both Windows and Mac?
It's a native Windows desktop application; Mac users typically run it through a Windows virtual machine or Boot Camp.
Ready to stop fighting #N/A errors and match your spreadsheets visually?