Free lookup · No formulas · Nothing uploaded
VLOOKUP, without the formula.
Your main file is missing columns that live in another file. Drop both, say which key matches them, tick the columns to bring over — done. No INDEX/MATCH, no #N/A, no Excel.
Your main file is missing columns that live in another file. Drop both, say which key matches them, tick the columns to bring over — done. No INDEX/MATCH, no #N/A, no Excel.
VLOOKUP is the most-searched Excel formula on earth because the need is universal: enrich this file with columns from that one. Here it's three clicks instead of a formula.
The file that needs extra columns goes on the left; the file holding those columns on the right.
Choose the column that identifies the same row in both files — an ID, an email, a SKU. Add a second key if one isn't unique.
Select which lookup columns to pull in. Every row of your main file is kept; rows with no match get blanks (your visible #N/A).
Everything VLOOKUP does, none of what makes it miserable.
No column-index counting, no FALSE flag, no dragging fill handles across 80,000 rows.
VLOOKUP's approximate-match default quietly returns wrong rows; this matches exactly, always.
Unmatched rows stay in your file with empty cells — and the report tells you exactly how many didn't match.
It's a hash lookup, not a per-row formula — 100,000 rows resolve in a blink.