Select the error cell and inspect the full formula in the formula bar.
Formula troubleshooting guide
How to Fix #N/A, #VALUE!, and #REF! in Excel
Excel errors usually point to a specific kind of problem: a missing lookup match, incompatible data type, or broken cell reference. Fixing the cause is better than hiding the error with IFERROR.
Step by step
A reliable workflow you can repeat.
Trace referenced cells and confirm that ranges still exist.
Check whether numbers are stored as text or contain hidden spaces.
Test lookup keys and exact-match settings for #N/A errors.
Use error handling only after the underlying formula works correctly.
Keep the result accurate.
- #REF! often appears after deleting referenced rows, columns, or sheets.
- #VALUE! frequently comes from text inside a calculation.
- #N/A in a lookup usually means the key is missing or formatted differently.
Move from the guide into the working tool.
Use the relevant workflow, review the preview carefully, and export only after the result matches your source data and business rules.
Open Formula CenterFAQ
Common questions about this workflow.
Should I wrap every formula in IFERROR?
No. IFERROR is useful for presentation, but it can hide real data problems if added too early.
How do I find text stored as numbers?
Compare alignment, use VALUE, or inspect the cell type before calculation.
Why does a lookup fail when values look identical?
Leading spaces, nonbreaking spaces, text-number differences, or different date serials can make them unequal.