Quick Navigation
IFNA Function
Summary
The Excel IFNA function returns a custom result when a formula generates the #N/A error, and a standard result when no #N/A error is detected.
Syntax
IFNA(value, value_if_na)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| value | Any |
Yes | The formula or expression to check for #N/A errors |
| value_if_na | Any |
Yes | The value to return if the formula evaluates to #N/A error |
Using the IFNA Function
IFNA is specifically designed to handle #N/A errors, which commonly occur with lookup functions like VLOOKUP when a value is not found.
Common IFNA Examples
Basic IFNA Example
=IFNA(VLOOKUP(A2, B:C, 2, FALSE), "Not found")Returns "Not found" instead of #N/A when the lookup value is not found.
Compatibility
Available in: Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2010 and earlier versions
Content last reviewed: November 24, 2025
Update frequency: As needed
Excel versions tested: Excel 2013+