# ISNA function in Excel

> ISNA returns TRUE only for the #N/A error, the one MATCH, VLOOKUP and XLOOKUP return when a value isn't found.

Source: https://spreadsheetpractice.com/functions/isna · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** ISNA returns TRUE only for the #N/A error, the one MATCH, VLOOKUP and XLOOKUP return when a value isn't found.
- **Syntax:** `=ISNA(value)`
- **Most common use:** `=IF(ISNA(MATCH(D2,A2:A5,0)),"Not in price list","Listed")` returns Listed (B-210 is in the list)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **Returns:** TRUE if the value is #N/A, FALSE otherwise.
- **Google Sheets:** Available in Google Sheets with the same argument.

## What it does

ISNA returns TRUE only for the #N/A error, the one MATCH, VLOOKUP and XLOOKUP return when a value isn't found. Use it to turn a failed lookup into a clear "not listed" message while letting real errors, like a typo in a function name, still show.

## Syntax

`=ISNA(value)`

| Argument | Required? | What it is |
|---|---|---|
| `value` | Required | The value, cell or formula to test. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | `=IF(ISNA(MATCH(D2,A2:A5,0)),"Not in price list","Listed")` | Listed | B-210 is in the list |
| E3 | `=IF(ISNA(MATCH(D3,A2:A5,0)),"Not in price list","Listed")` | Not in price list | Z-999 isn't, so MATCH returns #N/A |
| F2 | `=SUMPRODUCT(--ISNA(MATCH(D2:D4,A2:A5,0)))` | 2 | Two of the three order SKUs are missing |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | SKU | Price |  | Order SKU | Check | SKUs not in the list |
| 2 | A-100 | $39 |  | B-210 | Listed | 2 |
| 3 | B-210 | $89 |  | Z-999 | Not in price list |  |
| 4 | C-330 | $54 |  | X-500 |  |  |
| 5 | D-440 | $29 |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Not found when the item is clearly there | Lookups return #N/A for extra spaces or for numbers stored as text. Clean the data with TRIM or VALUE before blaming the formula. |
| The lookup runs twice | IF(ISNA(VLOOKUP(…)),"",VLOOKUP(…)) repeats the lookup. IFNA(VLOOKUP(…),"") does it once. |
| Other errors still show | ISNA ignores everything except #N/A, so a #REF! or #VALUE! passes through. That's usually what you want; fix the cause rather than hiding it. |

## Tips

- Test whether a value exists in a list: =NOT(ISNA(MATCH(D2,A2:A5,0))).

## Related functions

- [IFNA](https://spreadsheetpractice.com/functions/ifna): IFNA returns a fallback only when a formula results in #N/A, the error lookups give when a value is missing.
- [MATCH](https://spreadsheetpractice.com/functions/match): MATCH returns the position of a value in a row or column: 3 means the third cell.
- [ISERROR](https://spreadsheetpractice.com/functions/iserror): ISERROR returns TRUE for any error value, such as #N/A, #VALUE!, #REF!, #DIV/0! or #NAME?.

## Questions

### What is the difference between ISNA and IFNA?

ISNA returns TRUE or FALSE. IFNA returns the value, or your fallback when the value is #N/A. Use IFNA to replace the error and ISNA to test for it.

### How do I check if a value exists in a list?

=NOT(ISNA(MATCH(D2,A2:A5,0))) is TRUE when D2 is in the list. =COUNTIF(A2:A5,D2)>0 is another way.

## Practice

A graded ISNA exercise ("New or listed?") is on [the ISNA page](https://spreadsheetpractice.com/functions/isna). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
