Excel returns a small, fixed set of error values. Each one tells you exactly what kind of thing went wrong — a missing lookup, a wrong data type, a broken reference. This reference covers all of them, including the newer dynamic-array errors, with the cause and the fix. Bookmark it or print it.
“Not available” — a lookup function could not find the value you asked for. It is the most common Excel error and usually a data problem, not a formula bug.
"101" text vs 101 number).TRIM() and match types; use VLOOKUP(...,FALSE) for exact match. To show a friendly default instead of the error, use XLOOKUP(...,"not found") or IFNA(VLOOKUP(...),"—"). Use IFNA rather than IFERROR so you only hide missing lookups, not real bugs.Wrong type of argument — Excel expected a number (or a specific type) and got something it cannot coerce, like text where a number belongs.
=A1+10 where A1 is "abc".VALUE() or --; clean imported data with TRIM()/CLEAN(); check that ranges fed to array operations are the same size.Invalid cell reference — a formula points to a cell that no longer exists, almost always because rows, columns or sheets it referenced were deleted.
#REF! cannot be recovered by wrapping — the reference is gone. Prefer structured table references and named ranges, which survive row inserts better than raw A1 addresses.Division by zero (or by an empty cell, which Excel treats as zero).
0 or blank.=IF(B1=0,0,A1/B1), or =IFERROR(A1/B1,0). For averages over a possibly-empty range, AVERAGEIF with a condition avoids counting blanks.Excel does not recognize text in the formula — a misspelled function name, an undefined named range, or missing quotes around text.
=VLOKUP(...) instead of VLOOKUP.=FIND(hello,A1).XLOOKUP in Excel 2016).Invalid numeric value — a calculation produced a number Excel cannot represent, or an iterative function failed to converge.
=SQRT(-1) — square root of a negative.=SQRT(ABS(A1)) if negatives are expected); supply a better guess to iterative functions; check the magnitude of the result.An intersection of two ranges that do not actually intersect — usually a missing comma between arguments, which Excel reads as the intersection operator (a space).
=SUM(A1:A5 B1:B5) — a space instead of a comma.=SUM(A1:A5,B1:B5). If you meant a union, use a comma; if you meant intersection, ensure the ranges overlap.A dynamic-array formula (Excel 365 / 2021+) cannot spill its results because the spill range is blocked. Newer Excel only.
#SPILL! is a layout problem, not a logic problem.A calculation error in the dynamic-array engine — most often an array function asked to operate on an empty array. Excel 365 / 2021+ only.
FILTER with no matching rows and no if_empty argument.FILTER a third argument for the empty case: =FILTER(A:C,B:B="x","none"). Guard upstream functions so they never return an empty array.Not an error at all — the column is too narrow to display the number or date, or a date/time is negative.
A temporary placeholder shown while Excel fetches data from an external source (a data model, cube, or linked workbook). It resolves on its own when the data arrives.
IFNA to hide only missing lookups, and IFERROR only when you genuinely want to suppress every error type. Blanket IFERROR around a whole formula can mask real bugs — fix the cause first, then decide what to hide. For hands-on practice with error handling, see the free practice workbook.