How to Handle Not-Found Errors with IFNA in Excel

Catch only the #N/A that lookups return when a value is missing — and let genuine errors still show.

You will learn to

• Replace a lookup’s #N/A with a message
• Use IFNA inside a calculation
• Chain a second lookup as the fallback

How it works

IFNA(value, value_if_na) returns the value unless it is the #N/A error, in which case it returns your fallback. It is made for lookups: =IFNA(VLOOKUP(A2,F2:G7,2,FALSE),"Not listed") shows a friendly message when a code is missing from the price list.

Prefer IFNA to IFERROR around lookups. IFERROR also hides #REF!, #VALUE! and #DIV/0!, which usually mean a broken formula you need to see. IFNA can also chain lookups: if the first table has no match, look in a second table.

=IFNA(VLOOKUP(A2,F2:G7,2,FALSE),"Not listed")