Excel ERROR.TYPE Function

HomeExcel FunctionsExcel ERROR Function (Example + Sample File)


The Excel ERROR.TYPE Function is listed under Microsoft Excel's Information Functions category. It returns a number to which represents the type of error you have in a cell. For each error type in Excel, there is a specific number and if there’s no error it returns #N/A.

How to use it

To learn how to use the ERROR.TYPE function in Excel, you need to understand its syntax and arguments:


ERROR.TYPE (error_val)


  • error_val: The value you want to evaluate for error.


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


To master ERROR.TYPE function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used ERROR.TYPE with VLOOKUP to show a relevant message whenever an error occurs.

You can use this method to deliver a relevant message to the user.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.