ISNA Function

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.

ISNA is most useful in lookup workflows because #N/A usually means "not found" rather than a broken formula. It helps the workbook react specifically to missing matches without swallowing every other kind of error at the same time.

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 example checks one cell for one very specific error type: #N/A. It is not a general error test. It is only asking whether the value means "not available" or "not found."

That precision is why ISNA is useful in lookup-heavy sheets. It lets you treat missing matches differently from other formula problems.

=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 example turns a technical lookup miss into a clearer message for the reader. Instead of showing #N/A directly, the formula explains that the item was not found.

That makes reports easier to understand while still keeping the logic focused on the exact missing-record case.

=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 example uses ISNA as a review flag. If the lookup result is #N/A, the formula marks that row as missing.

That is helpful in exception reports, cleanup work, or dashboards where you want to count or filter the rows that still need a valid match.

=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

ISNA is for the specific case where a value is #N/A. In this lesson, it was used to catch missing lookups and turn them into clearer messages or flags.

Its strength is precision. It only reacts to #N/A, so other error types stay separate instead of getting mixed together.

• 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.