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.
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.