ExcelFlux

IFNA function

Return a custom result for a missing match.

Logical

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Show a useful marker for a missing lookup. IFNA handles the #N/A error specifically.

A worked example from the workbook

RowAB
6ValueComparison
722
855
9990
Record 1
=IFNA(MATCH(A7,$B$7:$B$9,0),"Missing")

Expected result1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=IFNA(NA(),"ID not found")
Turkish Excel · tr-TR
=EĞERYOKSA(YOKSAY();"Kod yok")

Example and expected result

Use this to explain a missing lookup result. Other error types continue to return their own errors.

Expected result ID not found.

Worked examples

Show a useful marker for a missing lookup. IFNA handles the #N/A error specifically.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Value Comparison
7 2 2
8 5 5
9 99 0
Case Formula Expected result
Record 1 =IFNA(MATCH(A7,$B$7:$B$9,0),"Missing") 1
Record 2 =IFNA(MATCH(A8,$B$7:$B$9,0),"Missing") 2
Record 3 =IFNA(MATCH(A9,$B$7:$B$9,0),"Missing") Missing
Microsoft Excel reference