Name Error in Excel

The dreaded name error, what does it mean. Well its not simple answer as the #NAME error can occur for several reasons:

Why does it happen

It could be:

  • You have used a range name that Excel does not recognise because its been defined.
  • You have used a range name but misspelled.
  • You have called a function but have misspelled it.
  • The range your are calling does not make sense.
  • Could be other reasons.

But usually the Name error is all about spelling.

To fix you just need to examine every part of the formula and look for misspellings or out of range arrays.


Back to blog