Combining IF and ISNUMBER functions to alter statuses

Hello Frederick AB,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

Hi,

I've been anlaysing exported ticket data in excel and need to show a simplified version of our 6 On Hold & 3 Work In Progress statuses, the other statuses dont need to be simplified they can remain 'as is'.

I've come across a few articles about ISNUMBER & SEARCH as an alternative to 'contains partial text string' as excel doesn't offer this functionality, in the below screenshot I've listed some example data (column A-C), all the status variables in column E and a formula I've been toying with as another alternative - I'm aware the formula in the screenshot wont work its just to show what i'm trying to achieve - which is to: Show any On hold - TBC status as On Hold, any WIP - TBC status as WIP and return all others with original status.

Screenshot 2020-06-09 at 18.47.46.png

I've not found a formula that works yet and would prefer to not have to add all 12 statuses to get a result, plus I need to return more than 2 options.

Welcome any feedback!

Thanks, Karen