How to use Excel ERROR.TYPE Function

Quick Intro

By using Excel ERROR.TYPE Function you will able to evaluate the value for error & get a specific number if an error occurs in that value. And, if an error doesn’t occur it will return #N/A.

Following are the numbers you will get for an error.

ErrorNumber
#NULL!1
#DIV/0!2
#VALUE!3
#REF!4
#NAME?5
#NUM!6
#N/A7

Syntax

ERROR.TYPE (error_val)

  • error_val Value you want to evaluate for error & require error number in return.

More Information on Excel ERROR.TYPE Function

  • You can use it with other function to test errors.

Examples

In the below example, I have used ERROR.TYPE with VLOOKUP Function to show a relevant message whenever an error occurs. You can use this method to deliver a relevant message to the user.

Examples For Excel ERRORTYPE Function

You have to include IFERROR Function with this function because if there is no error, error type will return an error. Using ERROR.TYPE is very helpful in case of complex formulas. You can also use it with IF Function.

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel ERROR.TYPE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have IFERROR function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.



  • I have not used this function so far. It is interesting. Thanks for sharing.

    • Puneet Gogia

      Welcome Dinesh.