Every Excel user has stared at a cell full of # symbols and wondered what went wrong. The eight error values look cryptic, but each one is a precise diagnostic message. Once you can read them, debugging a spreadsheet stops being guesswork.
Here is what each error actually means, the most common cause, and the fix — verified against a real formula engine, not just folklore.
#N/A — "I looked, and it isn't there"
#N/A means not available. A lookup function searched for a value and did not find it.
=VLOOKUP("banana", A2:B10, 2, FALSE) If "banana" is not in the first column of A2:B10, you get #N/A. This is not a bug — it is the function correctly reporting "no match."
Fix: confirm the lookup value exists and is spelled identically (trailing spaces are a classic culprit — wrap the lookup value in TRIM). If a missing match is expected, handle it gracefully:
=IFNA(VLOOKUP("banana", A2:B10, 2, FALSE), "not found") IFNA catches only #N/A, which is usually what you want for lookups. IFERROR catches everything and can hide real mistakes.
#VALUE! — "wrong kind of thing"
#VALUE! means a formula received the wrong type of argument — usually text where a number was expected.
="abc" + 1 You cannot add a number to text. The same happens when a cell that looks like a number is actually stored as text (common after importing CSVs).
Fix: coerce text to numbers with VALUE(), or check for stray characters. A leading apostrophe or a non-breaking space can make a "number" into text.
#REF! — "the cell you pointed at is gone"
#REF! means an invalid cell reference. It almost always appears after you delete a row, column, or sheet that a formula referred to.
=Sheet2!A1 ' then you delete Sheet2 Fix: #REF! cannot be recovered by editing the formula alone — the referent is gone. Undo the deletion if you can, otherwise rebuild the reference. This is why hard-coded cross-sheet references are fragile; structured tables and named ranges survive deletions better.
#DIV/0! — "you divided by nothing"
#DIV/0! means division by zero (or by an empty cell, which Excel treats as zero).
=A1/B1 ' B1 is 0 or blank Fix: guard the denominator:
=IF(B1=0, 0, A1/B1) For averages over a range that might be empty, AVERAGEIF or IFERROR keeps the result clean.
#NAME? — "I don't recognise that word"
#NAME? means Excel does not recognise text in the formula — usually a misspelled function name, a missing add-in, or an undefined named range.
=VLOKUP(A1, B:C, 2, FALSE) ' typo: VLOKUP Fix: check spelling. If the function is real but still errors (e.g. XLOOKUP on an old Excel version), your version does not support it. Undeclared named ranges also trigger this.
#NUM! — "a number went out of bounds"
#NUM! means a numeric argument is invalid — a negative number where only positive works, or a result too large to represent.
=SQRT(-1) =IRR(A1:A5) ' no convergence Fix: validate inputs (e.g. SQRT needs a non-negative number). Iterative functions like IRR and RATE need a sensible guess argument to converge.
#NULL! — "those ranges don't overlap"
#NULL! is the rarest. It means you specified an intersection of two ranges that do not intersect — usually a stray space between references.
=SUM(A1:A5 B1:B5) ' space means intersection; these don't overlap Fix: you probably meant a comma (union) instead of a space (intersection):
=SUM(A1:A5, B1:B5) ##### — "not an error at all"
A cell full of # is not an error value. It means the column is too narrow to display the number, or a date/time is negative. Widen the column and it resolves.
A quick diagnostic table
| Error | Meaning | First thing to check |
|---|---|---|
#N/A | lookup found no match | spelling / trailing spaces |
#VALUE! | wrong argument type | text stored as number |
#REF! | reference deleted | undo the deletion |
#DIV/0! | divide by zero/blank | guard the denominator |
#NAME? | unrecognised name | function spelling / version |
#NUM! | number out of bounds | input validity / guess arg |
#NULL! | ranges don't intersect | space vs comma |
##### | column too narrow | widen the column |
Try them live
I built a free reference where you can trigger each error in a live in-browser spreadsheet and see the fix side by side — no install, no signup: Excel error codes reference. There are also 81 function labs and a free 30-exercise practice workbook if you want to drill these.
The takeaway: an Excel error is not a failure, it is a label. Read the label and the fix is usually one step away.

