How to check if a cell contains one of several text strings, and return one single separate value

I am looking to search through a single column with over 600K rows, which contains varying text strings. I would like to search for specific text instances within this column, with it returning one of just a few values in the next column.

In conclusion, I want to create VBA code similar to the following IFS nested IF statement. I have attempted to use InStr, but am not proficient enough in VBA to make it work.

=IFS(OR(ISNUMBER(SEARCH("abend", B2)), ISNUMBER(SEARCH("fail", B2))), "Failure", OR(ISNUMBER(SEARCH("Err", B2)), ISNUMBER(SEARCH("error", B2)), ISNUMBER(SEARCH("invalid", B2))), "Error"))))

Many thanks!