Conditional Logic

Excel formula for VLOOKUP that returns blank, not #N/A

Show a blank (or message) when a lookup finds no match.

Copy this formula

=IFERROR(VLOOKUP(A2, Table, 2, FALSE), "")

How the formula works

Wrapping VLOOKUP in IFERROR replaces the #N/A you get when a value isn't found with a clean blank or a friendly message — perfect for reports and dashboards.

Examples

=IFERROR(XLOOKUP(A2, Ids, Names), "—")→—

Shows a dash when no name is found.

FAQ

XLOOKUP already has an if-not-found argument, right?

Yes — prefer =XLOOKUP(A2, Ids, Names, "") over wrapping in IFERROR when you can use XLOOKUP.

Related formulas

Hide errors with IFERROR Look up a value from another sheet

Functions used

IFERROR VLOOKUP XLOOKUP

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free