# Google Sheets ISNA Function: The Ultimate Guide for 2024

May 8, 2024

## Google Sheets ISNA Function Explained

ISNA is a function used to check if a cell contains the #N/A error, which often arises when data is not found, especially in functions like VLOOKUP, HLOOKUP, or MATCH. The ISNA function returns TRUE if the value is the #N/A error and FALSE otherwise.

Here's how you can use the ISNA function in Google Sheets:

=ISNA(value)

value: The value or expression to be checked for the #N/A error.

## How to Use the ISNA Function in Google Sheets

Follow the steps below to use the ISNA function in Google Sheets.

### Step 1: Choose a Cell

Click on any cell where you want the result of the ISNA function to appear.

### Step 2: Type the ISNA Function

Type =ISNA, and you'll see Google Sheets suggests the ISNA function.

### Step 3: Enter the Cell Reference or Expression

After =ISNA, specify the cell reference or expression you want to check. For example, A1 or VLOOKUP(...). After specifying the cell or expression, close the parenthesis.

### Step 4: Press Enter

Press the Enter key, and you will see the result. It will show TRUE if the cell or expression results in #N/A, and FALSE otherwise.

## Example

Here's a simple example of how to use ISNA with VLOOKUP:

Suppose you have a simple product inventory in Google Sheets with the following data:

Now, you want to look up the price of a product by its name and handle the case where the product name might not exist in the list.

Let's say you want to look up the price of "Banana" and handle the case where the product might not be in the list.

### Step 1: Select a Cell

Click on the cell where you want the result (e.g., E1).

### Step 2: Run VLOOKUP

You start with a VLOOKUP function to find "Banana" in the range B1:C3 and return the corresponding price from the 3rd column.

=VLOOKUP("Banana", B1:C3, 2, FALSE)

This would normally return 0.75 as the Banana's price.

### Step 3: Use ISNA and IF for Error Handling

Now, wrap the VLOOKUP with ISNA to check if the result is #N/A. Combine with IF to display a friendly message if not found.