Resources > Formula Help
How Do I Fix #N/A Errors in Excel?
Last Updated: June 2026
Quick Answer
The #N/A error usually means Excel cannot find the value you are searching for. It commonly happens in formulas like XLOOKUP, VLOOKUP, MATCH, and INDEX/MATCH.
Common Causes of #N/A Errors
- The lookup value does not exist in the lookup range
- There are extra spaces in one of the values
- Numbers are stored as text
- The lookup range is incorrect
- The formula is searching in the wrong column
1. Check If the Value Exists
Start simple. Make sure the value you are looking for actually appears in the lookup range.
For example, if your formula is:
=XLOOKUP(E2,A:A,B:B)
make sure the value in E2 exists somewhere in column A.
2. Remove Extra Spaces
Extra spaces are one of the sneakiest causes of #N/A errors.
=TRIM(A2)
Use TRIM to remove leading and trailing spaces.
3. Check for Numbers Stored as Text
Excel may treat 123 and "123" differently. If one value is stored as text and the other is stored as a number, your lookup may fail.
Try converting the value using:
=VALUE(A2)
4. Use IFNA to Display a Cleaner Message
Instead of showing #N/A, you can return a friendly message:
=IFNA(XLOOKUP(E2,A:A,B:B),"Not found")
5. Use XLOOKUP's Built-In Not Found Argument
XLOOKUP can handle missing values directly:
=XLOOKUP(E2,A:A,B:B,"Not found")
When #N/A Is Not Actually Bad
Sometimes #N/A is useful. It tells you that a value is missing from your data. In reporting, that may indicate a real data issue that needs to be fixed.
Need Help Fixing Excel Errors?
If your workbook has multiple lookup formulas and errors, I can help identify the cause and clean up the spreadsheet.
