Targeting Missing Lookups With IFNA
Handle only NA errors from lookups while leaving others visible.
Why IFNA Exists
IFERROR is powerful, but it hides every error. Sometimes that is too much. If a lookup fails because of bad data rather than a missing match, you want to see that problem, not bury it.
The IFNA function solves this. It handles only the #N/A error and lets every other error show through normally.
This makes it the precise tool for lookups, where #N/A is the expected, harmless error and anything else is a real bug worth seeing.
The IFNA Syntax
IFNA looks just like IFERROR and takes two arguments:
- value the formula to try
- value_if_na what to show only if the result is
#N/A
The pattern is =IFNA(your_formula, fallback). If the formula returns #N/A, you see the fallback. If it returns any other error, that error stays visible.
=IFNA(VLOOKUP(A2,Data!A:B,2,FALSE), "Not found")All lessons in this course
- Understanding Error Types
- Catching Errors With IFERROR
- Targeting Missing Lookups With IFNA
- Detecting Problems With ISERROR