#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.
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.
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.
A formula that produces it
=NA()