#N/A
#N/A
aligned
I’m not sure what you meant by “#N/A.” Do you want help with an error you’re seeing, or did you mean something else?
1/6
#N/A
If you meant the Excel/Google Sheets error "#N/A", here’s a quick summary and common fixes:
2/6
#N/A
What it means - "#N/A" = “not available” — a formula can’t find the value it’s looking for (or NA() was returned intentionally).
3/6
#N/A
Common causes - Lookup value not present (VLOOKUP, MATCH, INDEX+MATCH). - Wrong match type (approximate vs exact). - Data types mismatch (text vs numbers). - Leading/trailing spaces or invisible characters. - Formula purposely returns NA() (to mark missing data). - An array function where some elements are unavailable (propagates #N/A).
4/6
#N/A
How to fix or handle it - Use exact match in lookups: VLOOKUP(lookup, range, col, FALSE) or MATCH(value, range, 0). - Clean data: TRIM(), VALUE(), CLEAN(), remove stray characters. - Convert types consistently (e.g., ensure both lookup and lookup_range are text or numbers). - Wrap in IFNA or IFERROR to show a custom message or blank: - IFNA(VLOOKUP(...), "Not found") - IFERROR(VLOOKUP(...), "") - Use ISNA to test specifically for #N/A: IF(ISNA(MATCH(...)), "missing", "found") - For intentional NA values, use NA() so formulas that expect missing data handle it consistently.
5/6
Here's a couple other options if you’d rather go a different route:
Examples - Exact lookup with a friendly fallback: IFNA(VLOOKUP(A2, Sheet2!A:B, 2, FALSE), "No match") - Test for #N/A: IF(ISNA(MATCH(A2, list, 0)), "Missing", "OK")
6/6
If you meant something else by “#N/A,” tell me more (where you see it, what app, a formula or screenshot text) and I’ll help specifically.
