Excel: Lookup a text within string and return Yes or No if text exists abhisanto Excel Articles, Excel Tips and Tricks January 2, 2014 1 Minute Excel: Lookup a text within string and return Yes or No if text exists IF(ISNUMBER(LOOKUP(2^15,SEARCH(“SearchString”,G2))),”Yes”,”No”) Share this:TwitterFacebookLike this:Like Loading... Published January 2, 2014