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