Excel Error Guide - Fix Common Formula Errors

Learn how to fix common Excel errors like #N/A, #VALUE!, #REF!, #DIV/0!, #NAME?, and more with practical examples.

Fix Excel errors by type

  • [#N/A](/errors/na/) — lookup value not found (VLOOKUP, XLOOKUP, MATCH)
  • [#VALUE!](/errors/value-error/) — wrong data type in a formula
  • [#REF!](/errors/ref/) — deleted cells break a reference
  • [#DIV/0!](/errors/div0/) — division by zero
  • [#NAME?](/errors/name/) — Excel does not recognize the function name

Lookup error workflow

  • Start with the [#N/A guide](/errors/na/) checklist.
  • Then read [VLOOKUP returning #N/A](/problems/vlookup-returning-na/) if you use VLOOKUP.
  • Compare [XLOOKUP vs VLOOKUP](/compare/xlookup-vs-vlookup/) before migrating formulas.

Common Excel errors

  • #N/A: This error occurs when a value is not available to a function or formula. It's most common in lookup functions when the search value cannot be found.
  • #VALUE!: This error occurs when a formula has the wrong type of argument or operand. It typically indicates a mismatch between expected and provided data types.
  • #REF!: This error occurs when a formula refers to a cell that is not valid. Often happens when cells are deleted that were referenced by formulas.
  • #DIV/0!: This error occurs when a formula tries to divide a number by zero or an empty cell.
  • #NAME?: This error occurs when Excel doesn't recognize text in a formula. Usually caused by misspelled function names or missing quotation marks.