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 ...
ngabrielyan You may use IFS() function.
=IFERROR(IFS(ISNUMBER(SEARCH("MLTC",A2)),"MLTC",ISNUMBER(SEARCH("NYIAP",A2)),"NYIAP",ISNUMBER(SEARCH("MMC",A2)),"MMC"),"Not found")
Thank you so much Harun24HR!!!! Thank you for your help! 🙂