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.