Search cell text for specific values

I am trying to find specific text in a cell then based on the text identify the item.

the formula I have partially works, I can get it to identify the item if is exactly as stated in formula.

=IFS(A2="serv123","SERVER",A2="wksta123","WORKSTATION",A2="lptp123","LAPTOP",A2="tblt123","TABLET",A2="iph123","PHONE",TRUE,"")

I understand the formula is specifically seeking the text, but I need to find it anywhere in cell

Any assist would be appreciated

this would be one way...
=IFERROR(IFS(ISNUMBER(SEARCH("serv123",A2)),"SERVER",ISNUMBER(SEARCH("wksta123",A2)),"WORKSTATION",ISNUMBER(SEARCH("lptp123",A2)),"LAPTOP",ISNUMBER(SEARCH("tblt123",A2)),"TABLET",ISNUMBER(SEARCH("iph123",A2)),"PHONE"),"")

Glad I could help, AND thank you for the rep!

IMO, I would like to create table of Search and Result and use vlookup (or Index / Match) or others functions instead of IF (Excel 2016 didn't support IFS).
Because I can add more Search and Result when needed.

From your sample file.
I've create table at H3:I7

and use this formula at row 2
=INDEX($I$3:$I$7,AGGREGATE(15,6,(ROW($H$3:$H$7)-ROW($H$2))/(1/FIND($H$3:$H$7,A2)>0),1))

Regards.

Another way, please try

Formula:

Please Login or Register  to view this content.

Or with a table (as menem has done), please try

Formula:

Please Login or Register  to view this content.

In B2, copied down:

Formula:

Please Login or Register  to view this content.

This formula could easily reference a table instead of literal arrays. That would simplify upkeep if you need to change lookup or return values.

Originally Posted by HansDouwe

Formula:

Please Login or Register  to view this content.

Hans - I really like your use of SIGN here. But why is everyone using FIND, which is case sensitive, instead of SEARCH, which is not?