Look up two files on a key
Add each customer's name and city from the customer file to the orders file: no formula, no copying both files into one workbook, and knowing exactly which keys found nothing.
What this tool does
- The key suggested automatically when a column has the same name on both sides.
- The columns to bring over, your choice, added to the right of the main file.
- The usual causes of failure neutralised: extra spaces, case, a number stored as text on one side.
- Keys that found nothing counted and shown; duplicate keys in the reference flagged.
What it does not do: A duplicate key in the reference returns its first occurrence, as VLOOKUP does. Fuzzy matches ("Smith Ltd" and "Smith Limited") are not made.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Merge Excel files : Files and sheets in a single table, even when the columns are not in the same order.
- Reconcile two lists : Statement and ledger, file and export: what matches, and the differences.
- Split a file : One file per branch, per sales rep, or per batch of rows, header repeated.
- Compare two Excel files : Two versions of the same table: added rows, removed rows, changed cells.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.