Excel IFNA Function
IFNA returns a fallback result only when a formula returns #N/A.
Use it when missing lookup matches should be handled cleanly, while other formula errors should remain visible for debugging.
IFNA syntax & arguments
Syntax
=IFNA(value, value_if_na)
-
1
value
RequiredThe formula, expression, or value Excel should evaluate first.
-
2
value_if_na
RequiredThe fallback result to return only when
valueevaluates to#N/A.
Example
=IFNA(VLOOKUP(A2, E2:F10, 2, FALSE), "Not found")
Return the matching VLOOKUP result, or Not found when VLOOKUP returns #N/A.
IFNA caveats
IFNA is narrower than IFERROR, which makes it better when only missing values should be replaced.
-
It only catches #N/A
Errors such as
#VALUE!,#DIV/0!,#REF!, and#NAME?still show up. -
It is especially useful for lookups
Missing matches often return
#N/A, so IFNA can replace expected misses without hiding broken formulas. -
Blank fallbacks can be ambiguous
Returning
""keeps a cell visually blank, but it can make a missing lookup hard to distinguish from valid blank data.
Using modern lookups? XLOOKUP also has an if_not_found argument for missing-match fallbacks so IFNA is not needed.
Intro IFNA practice problem
Solve the intro problem directly here, or open it on its own page.
Advanced IFNA practice problems
Use IFNA alongside other Excel functions in realistic, less-prescriptive challenges.
