XLOOKUP is easier and works in both directions; VLOOKUP works everywhere. Choose the compatible style for Excel 2019 and older.

Why do I keep getting #N/A?

Usually a trailing space or a number stored as text. The generated formula wraps the lookup in IFERROR so those cases come back clean.

VLOOKUP Generator

Say what you want to find and where the answer lives, and get the lookup formula written out with real ranges, exact-match settings and a blank instead of #N/A when nothing matches.

Paste a few rows of your sheet and the column references will match your real layout. Pick the legacy-compatible style and it uses INDEX/MATCH instead of XLOOKUP for older Excel installs.

VLOOKUP Generator

Describe what to look up and get a working VLOOKUP, XLOOKUP or INDEX/MATCH formula with the ranges filled in.

Open the tool — this example is already filled in

Frequently asked questions

VLOOKUP or XLOOKUP?: XLOOKUP is easier and works in both directions; VLOOKUP works everywhere. Choose the compatible style for Excel 2019 and older.
Why do I keep getting #N/A?: Usually a trailing space or a number stored as text. The generated formula wraps the lookup in IFERROR so those cases come back clean.

Related tools

Excel Formula Generator

Describe what you need in plain words and get a working Excel formula, with column references matched to your own sheet.