Formula for searching multiple text strings
Hello,
I've had a look around the threads and can't find the answer I'm looking for (or more accurately can't apply the answers into the formula I need).
What I need to do is say:
If C2 contains "*Syd*", or "*UTS*", or "*Mel*"... (total of 11 possible text strings) then put a YES in this cell.
I've tried the IF(OR(ISERROR(FIND... but even when one of the possible text strings are present, the only result I get is "No", so I've got something wrong. Any help would be most appreciated.
Thank-you!
your string is in cell A2.
then insert this formula in B2:You would need to enter all your 11 possible texts (I only entered 3)
Please Login or Register to view this content.
Click on the star if you think I helped you
This may be shorter with more condition:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"syd","mel","uts"},C2)))>0,"YES","NO")
Replace SEARCH with FIND for sensitive case.
Quang PT
Cheers to you both!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks