IFNA Function in Google Sheets

Handle

IFNA Function

The IFNA function in Google Sheets returns a custom value if a formula results in the #N/A error, otherwise it returns the result of the formula.

Syntax

IFNA(value, value_if_na)

Examples

  1. Basic #N/A Handling

Handle #N/A error in VLOOKUP:

=IFNA(VLOOKUP(A1, B:C, 2, FALSE), "Not Found")

This will output ‘Not Found’ if the lookup value is not found and the VLOOKUP returns #N/A.

Notes

  • The IFNA function is specifically designed to handle #N/A errors.
  • It is similar to IFERROR but only handles #N/A errors.
  • IFERROR: Returns a custom value if a formula results in an error.
  • ERROR.TYPE: Returns a number corresponding to the error type.