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.
- 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.
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.
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.
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.