Syntax
IFNA(Expression, Value if #N/A!)
Expression (required) – This is part of the formula that is checked for an #N/A error.Value if #N/A! (required) – This is the value that is returned if the expression results in an #N/A! error.
Example
In this example we use the IFNA function with a VLOOKUP function. If the VLOOKUP function results in an #N/A! error (ie the lookup value was not found), then the IFNA function will return the text “Item not found”.
![IFNA function - 35](http://cdn-5a6cb102f911c811e474f1cd.closte.com/wp-content/uploads/2016/06/IFNA.png)