Hi.
I have a formula which looks for keywords in one cell, compares to a list on another sheet and then returns a string from another list. This was created by a forum user on this thread 1254914
The problem I'm having is that the keywords can show up in cells that are not appropriate (eg 'Flash' should only refer to the DC Character, but the cell relating to David Bowie's 'Flash' logo is also included).
So how can I change the search to look for combinations of keywords? So 'flash' is only accepted if the cell also contains 'DC Comics'?
I've attached a sample of the sheet for clarity.
Bookmarks