I hope you can help me with this challenge
I have a text column A, and two large lists of keywords. Once keywords lookup is done-all keywords should be concatenated in single cell, separated by symbol #.
- Column A contains long text,
- Column B should return keywords-from-list-1(100 keywords) found into the text
- Column C should return keywords-from-list-2(200 keywords) found into the text
A2 = The Frog King, or Iron Henry
B2 = Frog#Henry //as "Frog" and "Henry" are keywords in my first list (100 keywords)
C2 = Iron#King //as "iron" and "king" are keywords in my second list (200 keywords)
thank you for any help you can provide!