I have a spreadsheet with 200k+ books/descriptions/etc, and I'm looking for a way to search in each full row (A-x) for keywords (sheet2, column a, not case-sensitive) within the text, and when it finds those keywords, it assigns a unique category ID (sheet2 column b) to each row for each match which can be one category ID or several. The end result would combine all those category IDs into one cell (column y), separated by a comma.
Could anyone help to know what this formula or multiple formulas would be? I'm not an Excel guru and would love some help.
Could anyone help to know what this formula or multiple formulas would be? I'm not an Excel guru and would love some help.
