Turbo Excel Lookup
Buy nowAbout the Software
Turbo Excel Lookup matches, merges, joins, deduplicates and cleans Excel and CSV data without formulas. Load two files, choose the key columns, pick a match mode and run.
The result is a static table with counts of matched and unmatched rows. It avoids the usual VLOOKUP problems: brittle ranges, #N/A caused by a stray space, and slowdowns on large sheets.
Screenshots
Features
- Lookup and Merge
- Pull columns from one file into another. Choose first match, last match, all matches or match count, and a fill value such as NOT FOUND.
- Composite keys
- Add a second or third key pair, such as Order ID plus SKU, with no helper columns.
- Join tab
- Left, Right, Inner, Full Outer, Anti, Semi and Cross joins.
- Duplicate finder
- Keep the first or last record, show duplicate groups, or mark duplicates in place.
- Data cleaning
- Trim spaces, remove accents, normalize emails, phone numbers and currency, and change case.
- Fuzzy matching
- A similarity threshold handles approximate text.
- Formula Generator
- Write VLOOKUP, XLOOKUP or INDEX/MATCH formulas into a workbook when you need live formulas.
- Reports
- A timestamped session log records every lookup, join and export.
How to use it
- Load two files.
Choose a sheet if a workbook has several. - Select key columns.
Pick the columns to return. - Choose a match mode and run.
Statistics appear at once. - Preview and export.
Save as XLSX, CSV or TSV.
A dedicated engine built on pandas handles files too large for live formulas. Everything runs offline.
Match modes and statistics
When a key matches several rows, choose First Match, Last Match, All Matches combined into one cell, or Match Count, a quick audit for unexpected duplicates.
Every lookup reports total, matched and unmatched records, duplicate keys, match percentage and processing time. Export a Match Report, or only the unmatched rows to review typos and missing records.
An Anti join finds records in one file but not the other. Run it both ways to list every difference between two files. Workbooks with several sheets show a sheet picker first.
Eight tabs, one workflow
Lookup and Merge, Join, Duplicates, Data Cleaning, Formula Generator, Reports, Help and About share the same loading, preview and export controls, so learning one means knowing them all.
Cleaning and formulas
Most failed lookups come from invisible differences, such as a trailing space, a capital letter or an accent. The Data Cleaning tab fixes these on the columns you choose before you match.
When you need live formulas, the Formula Generator writes VLOOKUP, XLOOKUP, INDEX/MATCH, INDEX/XMATCH, HLOOKUP or IFERROR-wrapped formulas into every row of an XLSX or XLSM workbook, with sheet-name references and an exact-match option.