# #N/A

a value is not available — usually a lookup that found no match.

## what it means

#N/A means "no value available here". Lookup functions return it when the search key is absent, and it also propagates through any formula that references such a cell.

## common causes

- VLOOKUP/XLOOKUP/MATCH could not find the lookup value
- the lookup value and the data differ by type or whitespace ("42" vs 42, trailing spaces)
- an exact-match lookup over unsorted data that expected a sorted range
- NA() used deliberately to mark missing data

## how to fix it

- supply a fallback: =XLOOKUP(key, keys, vals, "not found")
- wrap in IFNA: =IFNA(VLOOKUP(...), "")
- normalise the key with TRIM/VALUE before looking it up

## related

#REF! · #VALUE!

## navigate

- [all error values](https://deepcalc.com/errors.md)
- [function index](https://deepcalc.com/functions.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/errors/na