Alright, there's a lot of similar Q&As out there but I can't get this figured out. I'm trying to categorize the cells in column A according to the list of keywords in column B. I've tried a wide variety of excel and sheets solutions but can't seem to get this.
C2 is an example. How does one create a list of matching tags/categories based off a list?
This is the closet I've gotten:
C2: =TEXTJOIN(", ",TRUE,REPT(b$2:b$99,ISNUMBER(SEARCH(b$2:b$99,A2))))
I know there must be some kind of array formula I can plug in.