Summary

ISNA returns TRUE only when a value is the #N/A error. It returns FALSE for everything else, including normal values and other error types such as #DIV/0! or #VALUE!.

That makes ISNA useful when #N/A has a specific meaning in your workbook, such as "not found" or "not available." In many lookup formulas, that is a normal result. A broken reference or another error usually means something different, so it helps to test for #N/A separately instead of treating every error the same way.

Syntax

=ISNA(value)

The function takes one argument: the value, cell reference, or formula result you want to test. Microsoft groups ISNA with the other IS functions and notes that these functions return only TRUE or FALSE based on the type of result they receive.

Arguments

• value - [required] The value, reference, or formula result you want to test.

This can be a direct cell reference like A1 or a formula result such as a lookup. ISNA checks the result exactly as it is returned.

ISNA vs Other Functions

Using ISNA

ISNA is most useful around lookup formulas such as VLOOKUP, MATCH, or other formulas that may reasonably return #N/A when no match is found. In those cases, the error does not always mean the formula is broken. It may simply mean the requested record is not there.

That is where ISNA is more helpful than a broader checker like ISERROR. A missing record can be a normal business case. A #REF! or #VALUE! error often points to a formula problem instead. By checking for #N/A specifically, you can respond to missing data without hiding more serious issues.

ISNA also works well inside IF formulas. You can use it to show a friendly message, create a TRUE/FALSE review flag, or decide whether another formula should continue. This makes it a good helper function when you want to treat "not found" as a special case in the logic of your workbook.

Example 1 - Check for #N/A

This is the direct use of the function.

=ISNA(A1)

If A1 contains the #N/A error, the result is TRUE. If A1 contains anything else, including another error type, the result is FALSE. This makes ISNA a precise test instead of a general error checker.

Example 2 - Show a Missing-Record Message

This is a common pattern when a lookup miss should be explained more clearly to the reader.

=IF(ISNA(B2),"Recenter Search","Data Found")

If B2 is #N/A, the formula returns "Recenter Search". Otherwise it returns "Data Found". This helps turn a technical error into a more readable status without treating every error as the same problem.

Example 3 - Leave Other Errors Alone

ISNA should return FALSE for errors that are not #N/A.

=ISNA(C3)

If C3 contains #VALUE!, #DIV/0!, or another non-NA error, ISNA returns FALSE. That narrow behavior is exactly why the function is useful when you want to keep missing lookups separate from other formula problems.

Example 4 - Audit a Lookup Result

This is a simple way to create a missing-record flag from a lookup result.

=ISNA(A1)

If A1 contains #N/A, the formula returns TRUE and flags the record as missing. That kind of flag is useful in review lists, exception reports, and data cleanup sheets where you want to count or filter missing matches.

Conclusion Recap

• Main job: ISNA returns TRUE only for #N/A.
• Best use: Handle missing lookups and not-available results without hiding other workbook problems.
• Good pair: Use IFNA when you want to replace #N/A directly.
• Broader option: Use ISERROR if you want to catch every error type.
• Important detail: ISNA is precise on purpose, and that precision is what makes it useful.