If you just have couple texts use them inside an Array like,
=IF(COUNT(SEARCH({"wxy.","abc"},A1)),"Found","Not Found")
Or enter all texts in a range, say in F1:F2, then use,
=IF(ISNUMBER(LOOKUP(9E300,SEARCH(F1:F2,A1))),"Found","Not Found")
If you just have couple texts use them inside an Array like,
=IF(COUNT(SEARCH({"wxy.","abc"},A1)),"Found","Not Found")
Or enter all texts in a range, say in F1:F2, then use,
=IF(ISNUMBER(LOOKUP(9E300,SEARCH(F1:F2,A1))),"Found","Not Found")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks