Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
IFNA
IFNA evaluates an expression and returns a specified fallback value only when the result is an #N/A error; all other values — including other error types — are returned as-is. It is commonly used to handle unmatched VLOOKUP, MATCH, or XLOOKUP results without masking real formula errors.
Excel
=IFNA(VLOOKUP(A2,C2:D5,2,FALSE),"Not found")Google Sheets
=IFNA(VLOOKUP(A2,C2:D5,2,FALSE),"Not found")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Write the formula that may produce #N/A as the first argument — for example, a VLOOKUP searching for a value that might not exist.
- 2Enter =IFNA(VLOOKUP(A2,C2:D5,2,FALSE),"Not found") so that 'Not found' appears instead of #N/A when the lookup fails.
- 3Use IFNA in preference to IFERROR when you want only #N/A to be caught, leaving other errors like #REF! or #VALUE! visible for debugging.
Need a version for your data?
Try: “Show 'Not found' instead of #N/A when a VLOOKUP cannot match a value”