As an example see the 2 sample sheets below.
They are silly examples but this is similar to what I need to accomplish.
I have a value that is text in an activities column and if there is any match in the text to a lookup value, in the lookup table, then it should return it's corresponding value...