ERRORTYPE function
ERRORTYPE returns the number corresponding to an error value occurring in a different cell. With the aid of this number, you can create an error message. If an error occurs, the function returns a logical or numerical value.
Syntax
ERRORTYPE(reference)
reference contains the address of the cell in which the error occurs.
Example
If cell A1 displays Err:518, the function =ERRORTYPE(A1) returns the number 518.