Excel IFNA Function

Logic Function ยท Beginner Level

What is IFNA?

Returns alternative value if expression results in #N/A, otherwise returns the expression result.

Syntax

=IFNA(value, value_if_na)

Example

Formula: =IFNA(VLOOKUP(A1, Data, 2, FALSE), \

Result: Result or 'Not Found'

How It Works

If VLOOKUP returns #N/A, returns 'Not Found'. Otherwise returns lookup result. More specific than IFERROR.

Learn More Excel Functions