I have a list of error message, and I want to consolidate them to their "user friendly" message:
error | friendly_error
failed with error1 | =VLOOKUP(A1, error_table, 1, false)
failed with error2 |
something else error3 |
error 4 failed with error5 |
failed with error1 |
And a table with the friendly values based on it containing of some keyword
contains | friendly_error
error1 | Message for error1
error2 | Message for error 2
etc...
Is there a command that can do this? Or do I need a bunch of if/else comments in a less organized way?
Vlookup would lookup the smaller value in a larger value, but I want to lookup a larger value to see if it contains a smaller value.
Right now I'm doing this, but it grows as I add more possible values:
=IF(ISNUMBER(SEARCH(G3,A1)),
H3,
IF(ISNUMBER(SEARCH(G4,A1)),
H4,
IF (ISNUMBER(SEARCH(G5,A1)),
H5,
A1
)
)
)
"failed with "
before performing theVLOOKUP