I have been trying to figure out a problem and while there are a number of similar questions on this forum, I haven't found one that exactly answers the issue I am trying to resolve.
I have in column A a list of 20 terms (A2 to A21) of one to two words each (e.g., alcohol, winery, distillery).
I have in column B business descriptions of 100 companies (B2 to B101) of two to three paragraphs of text each.
What I am trying to do in column C is that if a term in column A is mentioned in the business description of a particular company in column B, return 1, otherwise 0.
Is there an easy way to do this?
Bookmarks