Excel Error Codes Explained
Understand common Excel errors, their causes, and how to fix them. Error names shown in English, French, Spanish, and German.
Value not available - the formula cannot find the requested data.
- VLOOKUP/XLOOKUP cannot find the lookup value in the range
- MATCH function finds no matching value
- Missing data in the referenced cells
Use IFERROR to handle missing values gracefully, or verify your lookup value exists in the data.
Wrong type of argument or operand - the formula received unexpected data.
- Trying to add text to a number without conversion
- Using a range where a single value is expected
- Text in cells that should contain numbers
Check that all cell references contain the expected data type. Use VALUE() to convert text to numbers.
Unrecognized formula name - Excel doesn't understand a name in the formula.
- Misspelled function name (e.g., SUMM instead of SUM)
- Missing quotes around text strings
- Using a named range that doesn't exist
Check spelling of function names and ensure text values are enclosed in double quotes.
Invalid cell reference - the formula points to cells that no longer exist.
- Deleted rows or columns that the formula referenced
- Pasted over cells that were part of a formula
- Circular reference between cells
Undo the deletion or manually correct the cell references in the formula.
Division by zero - the formula is trying to divide by zero or an empty cell.
- Dividing by a cell that contains zero
- Dividing by an empty cell
- AVERAGE of an empty range
Use IF or IFERROR to check if the divisor is zero before dividing.
Invalid numeric value - the formula produces a number that Excel cannot handle.
- Result is too large or too small for Excel
- Square root of a negative number
- IRR or RATE cannot find a valid result
Check input values are within valid ranges. Use ABS() for values that might be negative.
Incorrect range operator - ranges in the formula don't intersect.
- Space used instead of comma between ranges
- Two ranges with no common cells
- Incorrect use of intersection operator
Use comma (or semicolon) to separate ranges instead of space.
Spill range blocked - a dynamic array formula cannot expand into adjacent cells.
- Non-empty cells blocking the spill range
- Merged cells in the spill area
- Table boundaries blocking expansion
Clear the cells where the formula needs to spill its results.