Knowledge base / Excel
ISNA in Excel: identify a specific #N/A error
I flag a missing match while preserving the original lookup result, then explain when IFNA is the shorter choice.

When a lookup cannot find a product, I want to distinguish that case from an invalid reference or division by zero. ISNA identifies the specific #N/A error. Its Polish name is CZY.BRAK, as confirmed by the Microsoft function catalogue. CZY.ND, previously used in the Polish version of this entry, was incorrect.
What ISNA checks
The function takes one argument:
=ISNA(value)
That argument can be a cell or an expression. ISNA returns TRUE for an actual #N/A error and FALSE for other values, including other error types. It does not replace the source value or repair a lookup. The Microsoft IS function reference documents this behaviour.
I use the result as an inspection status. A missing price needs investigation, but TRUE alone does not explain its cause. The product could be new, the catalogue outdated or the key affected by an extra space. The status helps identify the record to inspect without pretending that the underlying data problem has already been resolved.
A small price-list example
These are synthetic data. Place headers in A1:B1 and two products in A2:B3. Prices are illustrative numbers.
| Code | Price |
|---|---|
| P01 | 10 |
| P02 | 20 |
Put P03 in E2. In F2, enter an exact lookup:
=VLOOKUP(E2,$A$2:$B$3,2,FALSE)
P03 does not occur in the catalogue’s first column, so F2 returns #N/A. Microsoft documents missing matches in VLOOKUP. In G2, enter:
=ISNA(F2)
The result is TRUE. Change E2 to P02: F2 becomes 20 and G2 becomes FALSE. You have not added a catalogue price or changed the original result. You have created a separate signal that can help you filter records requiring attention.
A status message and conditional formatting
For a text status, use IF:
=IF(ISNA(F2),"check catalogue","no N/A error")
The second message is deliberately narrow. FALSE from ISNA does not establish that the entire record is correct. F2 could contain another kind of error and still produce FALSE from this test. A message claiming everything is valid would promise more than the formula actually checks.
You can also highlight missing values with a conditional-formatting rule such as =ISNA($F2). For a selected range beginning on row 2, the column stays fixed while the row reference changes. Microsoft explains formula-based formatting rules. The highlight should direct someone towards the entry needing investigation; it does not repair that entry.

When IFNA is more convenient
If the only requirement is replacing #N/A with text, this is usually shorter:
=IFNA(F2,"not in catalogue")
IFNA passes through F2 when it is not #N/A. You can place the lookup directly in its first argument too. There is no need to repeat VLOOKUP once in an ISNA test and again in the successful branch of IF.
In newer Excel versions, XLOOKUP provides an argument for a missing match. With this layout, =XLOOKUP(E2,A2:A3,B2:B3,"not in catalogue") returns the message for P03. XLOOKUP is unavailable in Excel 2016 and Excel 2019. Choose an approach compatible with the versions used by the workbook’s recipients.
ISNA and other error tests
| English name | Polish name | What it tests |
|---|---|---|
| ISNA | CZY.BRAK | #N/A specifically |
| ISERROR | CZY.BŁĄD | Any error value |
| ISERR | CZY.BŁ | Errors other than #N/A |
The names and distinctions are documented in the Microsoft catalogue. CZY.BEZWARTOŚCIOWE, found in the previous Polish text, is not a valid function name. It should not be used as a supposed way of detecting #VALUE!.
Distinguish an error value from text resembling one. An entry explicitly stored as text, for example by prefixing an apostrophe, is different from an actual error. Inspect imported cells rather than relying on their appearance. Two visually similar entries can behave differently in a formula because their stored values differ.
Practice and interpretation limits
Keep F2 as the lookup result and observe the status beside it. Try an existing P01, a missing P03 and a formula containing an invalid reference. Predict ISNA’s result before each change. This shows why the function does not replace a general Excel troubleshooting process.
A missing price does not become a valid zero price when a readable message is added. Retain information about incomplete records and decide whether a summary may omit them. PivotTables have their own display options for empty cells and errors; ISNA is not a general repair for empty PivotTable fields. The example here checks an ordinary worksheet lookup result.
Key takeaways
What is ISNA called in Polish Excel?
CZY.BRAK is the correct name. CZY.ND was an error in the previous Polish entry.
Does ISNA detect every error?
No. It returns TRUE specifically for #N/A and FALSE for other error types.
When should I use IFNA?
Use IFNA to replace #N/A with a chosen value. ISNA is useful when you need a separate inspection status.
AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.
