Skip to content
ExcelExcel 2013+

IFNA function in Excel

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression

=IFNA(value, value_if_na)

IFNA syntax and parameters

Two arguments, two required.

  • valueanyRequired

    The argument that is checked for the #N/A error value.

  • value_if_naanyRequired

    The value to return if the formula evaluates to the #N/A error value.

IFNA examples

Formulas you'll actually reuse.

  1. Catch ONLY #N/A — unlike IFERROR, a real mistake such as #REF! still shows:

    =IFNA(VLOOKUP(F2, A2:D200, 4, FALSE), "Not found")

    Result"Not found"

  2. A position of 0 for keys that aren't in the list:

    =IFNA(MATCH(F2, A2:A200, 0), 0)

    Result0

IFNA in Google Sheets

Same name — your formula ports as-is.

Try IFNA in the playground

Edit the example — nothing to install.

Preloaded with the IFNA formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.