Find a string contains a substring

[rajtrader]

I have a column name Keyword1 in one table, which contains a single word in each row and a Title column in another table. I want to highlight the Title if it contains any word from the column Keyword1.

For that, I used CONTAINS() function, but it seems like it does not work with a list of words and the second parameter of the formula should be a text. 

How can we find if a string contains a substring from a list or column?

[Suvrutt_Gurjar · Accepted solution]

Could you try

ISNOTBLANK(INTERSECT(SPLIT([Title], " "),  Keyword[Keyword1]))

[rajtrader]

Thanks, problem solved!   

[Suvrutt_Gurjar]

You are welcome. Please take a look at the associated functions' help documents, just in case you have not

SPLIT() - AppSheet Help

INTERSECT() - AppSheet Help

ISNOTBLANK() - AppSheet Help

[rajtrader]

Thanks. I had tried SPLIT, CONTAINS, and FIND functions, but I missed INTERSECT function.