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.