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*”
=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
ABNYIAP MMC InitialNYIAPMMC Initial NYIAP NYIAPMMC InitialMMCMLTC InitialMLTCPeds InitialMMC
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*”=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 ABNYIAP MMC InitialNYIAPMMC Initial NYIAP NYIAPMMC InitialMMCMLTC InitialMLTCPeds InitialMMC Read More
