I have some key words i want to search for in a text string using a comma delimitated list. Is there a good way to do this? I've been using a function like this, =IF(ISNUMBER(SEARCH(substring,text)), "Yes", "No")
I'd like to replace the substring with the comma delimited list.
I've uploaded an example sheet that shows what result I'm looking for.
Thanks for the help!
=LOOKUP(2,1/SEARCH($E$3:$E$5,A2),$E$3:$E$5)
in e3:e5 your words
Thanks
I need to be able to search this list in comma delimited form though. Is that possible?
Thanks
No doubt, I'll be proved wrong in a few moments... but no: I don't think that it's possible.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
hi ian2. based on your eg with the assumption i only have a string of keywords and only 3 inside it, maybe:
Formula:
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
@ ian2
In A3 what determines the preference of "Grape" over "Cherry"? They are both in the key word string.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks