Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← All functions

IFNA

Logic & error handling

Catch only #N/A — so a missing lookup is handled but real errors still surface.

Difficulty

Amateur

Excel file

1What is it?

IFNA returns a value when a formula produces the #N/A error, and the formula's normal result otherwise. It's the surgical version of IFERROR: where IFERROR swallows every error (including the #REF! or #DIV/0! that signals a genuine bug), IFNA catches only the 'not found' case that lookups throw — so a legitimately missing match gets a clean fallback while a broken formula still shows its error and gets your attention.

2What it looks like

IFNA(value, value_if_na)

value: The formula that might return #N/A — usually a lookup.
value_if_na: What to show instead when it's #N/A, like "Not found" or 0.

3When you use it

Give a lookup a friendly miss: =IFNA(VLOOKUP(…), "Not found").
Return 0 for an unmatched key while keeping other errors visible.
Wrap INDEX/MATCH so a missing row doesn't cascade #N/A through a model.

4See it in action

Change the inputs — the formula and result update live. Prefer the real thing? Download the Excel file and open it in Excel.

Look up a code and return its name — but give a clean message when the code isn't in the table. Try 9999.

=IFNA(VLOOKUP("9999", A2:B4, 2, FALSE), "Not found")Not found

	A	B	C
1	Code	Name	Result
2	4000	Product revenue	Not found
3	4100	Service revenue
4	5000	Cost of goods sold

The lime cell holds the formula — click it (or any cell) to see its contents in the bar above, just like Excel. Edit the blue cells to watch it recompute.

Look up code

5Common errors

Real errors slip throughYou expected IFNA to catch a #DIV/0! or #VALUE!.

Fix: By design it only catches #N/A — use IFERROR if you truly want to catch everything.

Still #N/AThe error isn't actually #N/A (it's #REF! from a deleted column).

Fix: Fix the reference; IFNA won't (and shouldn't) mask that.

6Better functions & alternatives

IFERROR — Catches every error type, not just #N/A — broader but blunter.
XLOOKUP — Has a built-in if_not_found argument, so you often don't need IFNA at all.
ISERROR / ISNA — Test for the error explicitly when you need the boolean.

Want IFNA already wired into a model? Wauvel's free tools download as branded, formula-driven Excel.

Learn the moves here — or let Wauvel run them on your numbers.

Get my free report →