Basically, I wanted to find keyword prjtmp and if it is found in given cell, I want to put "DONT WORRY" in the result column. Below was the formula I put in the desired cell and BOOM!!! It worked!!! :)
=IF(ISNUMBER(SEARCH("*prjtmp*",C2)),"DONT WORRY","")
No comments:
Post a Comment