ngabriel
New Member
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
=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 |