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!