Excel IFNA function🔀 Replace not-found
The IFNA function: Replace not-found. Pair with VLOOKUP, XLOOKUP, MATCH. This page shows the syntax, a worked example with its result and how the formula reads.
What does IFNA do?
Replace not-found. Pair with VLOOKUP, XLOOKUP, MATCH
IFNA syntax
=IFNA(value, value_if_na)
Arguments in square brackets [ ] are optional · argument names follow Microsoft's documentation
IFNA example with the result
=********
👑 Ready-to-use example formula for VIP supporters only · Become VIP
Formula in cell E3 Yellow cells = result
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Code | Item | Look up | ||
| 2 | P1 | Coffee | Code | P9 | |
| 3 | P2 | Tea | Result | Not found | |
| 4 | P3 | Snack |
How it reads: VLOOKUP cannot find P9 and gives #N/A · IFNA shows Not found instead
Frequently asked questions about IFNA
What does IFNA do?
Replace not-found. Pair with VLOOKUP, XLOOKUP, MATCH
What does the IFNA example return?
The example formula in cell E3 gives Not found.
Which Excel versions have IFNA?
Excel for Microsoft 365 and Excel 2013 or later, according to Microsoft's function list. Older versions show #NAME?.
🕸️ More logic formulas and related ones
Source: support.microsoft.com
Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning