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

ABCDE
1CodeItemLook up
2P1CoffeeCodeP9
3P2TeaResultNot found
4P3Snack

How it reads: VLOOKUP cannot find P9 and gives #N/A · IFNA shows Not found instead

💡 Excel version Works in Excel for Microsoft 365 and Excel 2013 or later, per Microsoft's function list · older versions show #NAME?

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?.

Source: support.microsoft.com

Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning

🤖
Posting...
Please wait a moment
Social VIP Classroom
Home
Thai Smiles Profile