Hello,

I'm trying to figure out a formula that will check if a string contains any words from a separate array of strings (aka if a cell contains one or more keywords from a list.) The formula should return TRUE any of the keywords appears in the string regardless of case or position of the keyword in the string, and FALSE otherwise.

1. For a match I don't want to have to consider case (i.e. if the keyword is "CAT" and the string contains "cat" I would like to return TRUE.)
2. It should be considered a match if the keyword is contained anywhere in the string we are checking (i.e. if the keyword is "Cat" and the string is "Cat/hat" or "bobcat" I would like to return TRUE)


I have checked around the forums and have only found cases that don't account for the lack of case or carrying of positing.

I really appreciate any help on this!

Thanks!!