Excel File Shows #VALUE!, #REF!, or #NAME? Errors
Cells in your Excel or XLSX spreadsheet show error codes like #VALUE!, #REF!, #NAME?, or #N/A instead of calculated results.
Last updated
Excel Formula Errors Explained and Fixed
Excel shows error codes when a formula can't compute a valid result. Each code has a specific meaning.
#VALUE! Error
Meaning: A formula is trying to do math on text, or uses a function argument in the wrong data type. Example: =A1+A2 where A2 contains "hello" (text, not a number) Fix: Check that all cells referenced in the formula contain the data type the formula expects. Use =ISNUMBER(A2) to test.
#REF! Error
Meaning: A formula references a cell that no longer exists — usually because rows or columns were deleted.
Example: =SUM(A1:A10) after rows 5–8 were deleted
Fix: Click the cell and look at the formula bar. Find the #REF! part and replace it with the correct range.
#NAME? Error
Meaning: Excel doesn't recognize a function name — often a typo, or the function requires an add-in. Example: =VLOOKUP misspelled as =VLOKUP Fix: Double-check the function name spelling. Make sure the formula doesn't contain unrecognized text (like a named range that was deleted).
#N/A Error
Meaning: A lookup function (VLOOKUP, INDEX/MATCH, XLOOKUP) can't find the value it's looking for. Fix: Check that the lookup value exists in the lookup range. For VLOOKUP, make sure the lookup column is the first column and the match type is correct (0 for exact match).
#DIV/0! Error
Meaning: The formula is trying to divide by zero or by an empty cell.
Fix: Use =IF(B2=0, 0, A2/B2) to return 0 instead of an error when the divisor is zero.
How to Find All Errors at Once
In Excel: Go to Home → Find & Select → Go To Special → Formulas → Errors. This selects all error cells simultaneously.
Advertisement
Frequently asked questions
What causes #VALUE! errors in Excel?
#VALUE! means Excel is trying to calculate using a cell that contains text instead of a number, or vice versa. Common causes: a cell contains a hidden space or character that looks empty but is text, a date was pasted as text, or a formula expects a number but received a string like "N/A" or "--".
What causes #REF! errors in Excel?
#REF! means a cell reference is pointing to a cell that no longer exists — typically because a row or column the formula depended on was deleted. Press Ctrl+Z to undo the deletion, or update the formula to point to the new correct location.
What causes #NAME? errors in Excel?
#NAME? means Excel does not recognise a function name or range name in your formula. Common causes: a function name is misspelled (e.g. "SUMM" instead of "SUM"), a named range was deleted or renamed, or text that should be in quotes appears without them (e.g. =IF(status=done,...) instead of =IF(status="done",...)).