Forum Discussion
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 ...
Does this do what you intend?
=IF( IFERROR(SEARCH("*NYIAP*",A2,1),FALSE),"NYIAP",
IF( IFERROR(SEARCH("*MLTC*",A2,1),FALSE),"MLTC",
"MMC" ) )(Of course, you do not have to split that across multiple lines, as done here.)
- Thank you so much @Snow Man55. !!!!!! thanks for the quick response !!!!!!
