Search for text in a cell from a lookup table and return that text when a match is made

Hi there

Newby here with moderate excel skills, slowly going mad over a project I really please need help with! I have searched this forum and Google with no luck.

I have a XLS with 20,000+ rows and I need to check if words match a table of 200+ options. If there is an exact match with the the table I need to return the match data.

I have attached a the XLS with an extract of the data set and the desired results

Ideally I would like to avoid going down an array path if possible but if it is the only solution that's ok.

Any help would be much appreciated, my sanity is at stake!

Cheers Paul