Google Sheets
IFNA function in Google Sheets
Evaluates a value. If the value is an #N/A error, returns the specified value. .
=IFNA(value, value_if_na)IFNA syntax and parameters
Two arguments, two required.
- valueanyRequired
- value_if_naanyRequired
IFNA examples
Formulas you'll actually reuse.
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"A position of 0 for keys that aren't in the list:
=IFNA(MATCH(F2, A2:A200, 0), 0)Result
0
IFNA in Excel
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 Google Sheets gets this done.
- ANDReturns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.LogicalExcel
- FALSEReturns the logical value `FALSE`.LogicalExcel
- IFReturns one value if a logical expression is `TRUE` and another if it is `FALSE`.LogicalExcel
- IFERRORReturns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.LogicalExcel
- IFSEvaluates multiple conditions and returns a value that corresponds to the first true condition.LogicalExcel
- LAMBDACreates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares.LogicalExcel