Hi!
I'm trying to find if a cell contains a partial text match to a list of text values in a range of cells.
For example,
Let's say cell a1 contains a really long text-value:
A1
="If horse-racing is the sport of kings then surely bowling is a… very good sport as well"
And cells b1:b3 are
="bowling"
="lacrosse"
="badminton"
if I want to check to see if any of the words in b1:b3 are contained in a1, is there a way to do that? It's sort of like a mini-database lookup.
I've searched for a long while, and, over the years this site has been invaluable to me, but I haven't been able to find any solutions for this one as of yet.
Thanks!
Bookmarks