How to find piece of specific text and return specific text.

[ngabriel]

Hello everyone, I am working on project and having hard time to find piece of text and return specific text. My formula works only with two variable, and I need to add one more. If column A contains piece of text "*MLTC*" return "MLTC", if contains "*NYIAP*" return "NYIA", if does not contain NYIA or MLTC return "MMC". Here is my formula:
=IFERROR(IF(SEARCH("*MLTC*",A2,1),"MLTC"),IF(SEARCH("*NYIAP MMC*",A2,1),"NYIAP"))

How should I add if cell does not contain NYIAP and MLTC return MMC. Thank you

A	B
NYIAP MMC Initial	NYIAP
MMC Initial NYIAP	NYIAP
MMC Initial	MMC
MLTC Initial	MLTC
Peds Initial	MM

 

[ETAF]

a sample sheet would help here

I need to add one more. If column A contains piece of text "*MLTC*" return "MLTC", if contains "*NYIAP*" return "NYIA", if does not contain NYIA or MLTC return "MMC". Here is my formula:

=IF( ISNUMBER(Search("MLTC",A2,1)), "MLTC", IF( ISNUMBER(Search("NYIAP",A2,1)), "NYIAP", "MMC"))

 

[AliGW]

That's exactly what I just suggested on ExcelGuru:

How to find piece of specific text and return specific text.

Hello everyone, I am working on project and having hard time to find piece of text and return specific text. My formula works only with two variable, and I need to add one more. If column A contains piece of text "*MLTC*" return "MLTC", if contains "*NYIAP*" return "NYIA", if does not contain...

forums.excelguru.ca

 

[vletm]

ngabriel​

As You've read from (both sites) Forum Rules before start to posting:

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Please, reread

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

These rules are for everyone.

 

[ngabriel]

Thank you so much everyone for your help and quick response!!!!!