Excel Search a Cell for a List of Words
- Thread starter aatral
- Start date
pecoflyer
Well-Known Member
aatral
You should reread Forum rules - those are for You tooSite Rules - New Users - Please Read
Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
- When drafting a question, try and lay out the question in a clear and concise way.
- Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
- Don't leave out information more info is better
- For the best/fastest results, Upload a Sample File
- Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
- If you do cross-post, please put that in your post.
- Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
Got the solution from Glenn Kennedy in https://www.excelforum.com/excel-fo...h-a-cell-for-a-list-of-words.html#post5846353
=IFERROR(LOOKUP(1000,SEARCH(J$2:J$41,D2),J$2:J$41),"")
J$2:J$41 - List of text strings
D2 - The cell where it has a sentence.
You can shorten the formula by :
=IFERROR(LOOKUP(1,-SEARCH(J$2:J$41,D2),J$2:J$41),"")
Regards
Peter Bartholomew
Well-Known Member
= FILTER(list, ISNUMBER(SEARCH(list, textCell)))
