How to fix #N/A in Excel and Google Sheets
What you see
- Cell displays #N/A
- Often appears after VLOOKUP or XLOOKUP
Common causes
- The lookup value is not in the other table
- Extra spaces or different spelling in the two lists
How to fix it
- Confirm the value exists in the lookup column
- Trim spaces with TRIM if text looks the same
- Use IFERROR to show a friendly message instead of #N/A
Example formula
=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,FALSE),"Not found")