Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I'm wanting to create a list of strings to search for in Column A. Example "Cafe", "Restaurant", "Shop X"...
Then if a string in another cell (example: "Robert Harris Cafe") contains any of the values in column A, I want it to return true.
Similar to COUNTIF but but with a REGEXMATCH. Count it if it contains any of those values in column A.
To get a true/false result:
=0 < counta(
iferror(
filter(
A2:A,
search(A2:A, B2)
)
)
)
To get a count:
=counta(
iferror(
filter(
A2:A,
search(A2:A, B2)
)
)
)
To list the keywords that match:
=filter(
A2:A,
search(A2:A, B2)
)
true, or like3, or likeCafe,Shop,Service. Please edit your question and insert a table of sample data together with another table that shows your manually entered desired results.