Search cell for multi strings

I need to search cell a2 for the following text

POBO
ROBO
VA
Virtual Accounts

If the cell contains any of those four texts, return "Found"

Many thanks
Seamus2626Asked:
Who is Participating?
 
ProfessorJimJamConnect With a Mentor Commented:
assuming the cell you are looking into is A1 then use the following formula.   it is case sensitive , if you do not want case sensitive then replace FIND with SEARCH

=IF(SUMPRODUCT(--ISNUMBER(FIND({"POBO","ROBO","VA","Virtual","Accounts"},A1)))>0,"Found","Not Found")

not case sensitive then
=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"POBO","ROBO","VA","Virtual","Accounts"},A1)))>0,"Found","Not Found")
0
 
Seamus2626Author Commented:
Thanks Professor!
0
 
ProfessorJimJamCommented:
you are welcome seasmus2626. i am glad i was able to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.