Hello!
I'm trying to look up a column of keywords looking for any term containing specific word e.g. 'suit' and display that keyword in another worksheet with the values for the keyword in the same row next to it.

I've tried vlookups, match, index etc and they didn't work. I've got a feeling I need to add a couple of formulas together but I'm not sure how to do that.

Thanks,
Nick