Excel Function

IFNA

Returns fallback value for #N/A errors.

IFNA(value, value_if_na)

Arguments

value

Required

Enter an expression such as comparison or calculation.

value_if_na

Required

Specify the value returned when the result is #N/A.

Practice Preview

Use IFNA to return "N/A" when XLOOKUP("Not found",B2:B8,D2:D8) returns #N/A.

Example Table

#	ALearner ID	BName	CScore
2	U001	Tanaka	82
3	U002	Sato	67
4	U003	Suzuki	91
5	U004	Takahashi	55
6	U005	Ito	78
7
8

How to Use (Formula)

=IFNA(XLOOKUP("Not found",B2:B8,D2:D8), "N/A")

Result

N/A

Practice This Function

Start Function Practice Back to Function List

IFNA FAQ

How do I use IFNA in Excel?

Use IFNA when you want to show a fallback only when no match is found. Enter Value, Value if N/A in that order, then add optional arguments when needed.

Where can I practice IFNA?

Use the "Start Function Practice" button to jump straight into IFNA drills.

What arguments does IFNA use?

The main arguments are Value, Value if N/A. Enter them in order.