Data template

VLOOKUP Alternative Template

Do the lookup by picking two files and a key — no formula to write, no #N/A to chase. Unmatched rows are flagged so you can fix the data, not debug a formula.

Use this template free →Prefer the Excel guide?

Opens in your browser with sample data · export to Excel any time · your data stays yours

Prefer the spreadsheet? Two-Way Lookup (INDEX/MATCH) Template · VLOOKUP to XLOOKUP Template — free with an account, 3 free downloads.

See inside before you download: Two-Way Lookup (INDEX/MATCH) Template · VLOOKUP to XLOOKUP Template

vlookup-alternative · orders × customersJoined

Output rows

Matched

Unmatched

Columns added

Order	customer_id	Amount	Customer	Tier
#1043	C-201	£1,240	Northwind Traders	Enterprise
#1044	C-208	£560	Acme Corp	Pro
#1045	C-201	£2,100	Northwind Traders	Enterprise
#1047	C-199	£430	unmatched	—
#1048	C-208	£1,750	Acme Corp	Pro

One row (C-199) has no match — flagged, not a silent #N/A.

What's inside this template

✓

Lookup without the formulaMatch on a key by picking columns, not typing VLOOKUP.

✓

No #N/AUnmatched rows are flagged and kept, not silently broken.

✓

Exact or approximateMatch on an exact key or the nearest value.

✓

Pull many columnsBring across several fields in one go.

✓

Works both directionsLook left or right — no column-order trap like VLOOKUP.

✓

Export the resultDownload or share the enriched file.

How it works

Pick the two files

The one you have and the one to look up against.

Choose the key

Match on the shared column.

Get the enriched table

Columns pulled in, unmatched rows flagged — export or share.

Related templates

Common questions

What's better than VLOOKUP for matching two lists?

A proper join. You pick the two files and the shared key and the match runs across every row at once — no formula to drag, no lookup column that has to sit to the left, no silent breakage when a column is inserted.

Why does my VLOOKUP return #N/A?

Usually trailing spaces, a number stored as text, inconsistent casing, or the key not being in the first column of the range. A join surfaces those as unmatched rows you can inspect instead of an error code you filter out.

Is XLOOKUP not good enough?

XLOOKUP fixes the left-column and column-insertion problems, but it's still a formula per row that fails silently at scale and still hides non-matches unless you handle them explicitly.

The lookup, without the formula

Pick two files and a key — enriched table out, no VLOOKUP, no #N/A.

Use this template free →

No card required · works in your browser · export any time