I would like to be able to match all cells in column A (titles) with one of the comma separated values in column E (key search terms). This will involve at least two steps. 1) Analyze each of the respective key search term cells in an array of cut-off text values (eg cell E10 would be ("substance", "food fluff", "green").) 2) Regular expressions correspond to exact model contained under the column tags (column F).
The desired result in the image below will be a filter allowing only the title of the article "Hate Foods: A Viable Source of Catharsis?" pass through. Note that "Being Cool: A Guide" does NOT make the cut because although it contains the word "food" in the corresponding search keyword cell, it falls within the context of "food fluff" that constitutes a distinct value of "food". isolation.
I might ask myself questions for a moment, but I have a client who needs a quick fix and I have a hard time seeing how to get that result. I think I have completed the first step with the following formula:
ARRAYFORMULA(TRIM(SPLIT(E10, ","))) This shows the analysis of a single cell in a table from its CSV value – in this case, "substance", "food fluff", "green".