ISNA

The ISNA function in Google Sheets checks whether a value or formula result is the #N/A error, returning TRUE or FALSE. It's frequently paired with lookup functions to catch missing matches gracefully. Dive into our comprehensive guide to master its use.

Parameters

• value: The value or cell reference to check for the #N/A error.

Step-by-Step Tutorial

1. Checking for a #N/A error from a lookup:

   • Example: If A1 contains =VLOOKUP("missing", B1:C10, 2, FALSE) and returns #N/A, then =ISNA(A1) will return TRUE.

2. Checking a normal value:

   • Example: =ISNA(42)
   • Result: FALSE

Use Cases and Scenarios

1. Lookup Error Handling: Detect when VLOOKUP, HLOOKUP, or MATCH fail to find a match, so you can display a custom message instead of #N/A.
2. Data Validation: Flag rows where expected lookup values are missing from a reference table.
3. Conditional Logic: Combine with IF to build formulas like =IF(ISNA(VLOOKUP(...)), "Not Found", VLOOKUP(...)).

Related Functions

• IFNA: Returns a specified value if the formula results in #N/A, otherwise returns the formula's result.
• ISERROR: Checks whether a value is an error.
• IFERROR: Returns a specified value if the formula results in an error, otherwise returns the formula's result.

Related Articles

No related articles available for the ISNA function.