Vlookup - Searching for text within a cell

Hi all,

I'm trying to set up a vlookup, that looks to see whether a word is in a cell, and then returns a code. See the attachment.

I basically want the vlookup to check the first cell in the description column to see if it matches any of the Key, and then if it did, I want the solution of the formula to be the one letter code shown in column E.

Eg. for cell A2 the answer would be O, cell A3 the answer would be R.

Appreciate any tips!

This will pick up most of them. Probably would need VBA to do a fuzzy match. Formula is an Array Formula

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Here is a regular formula

Formula:

Please Login or Register  to view this content.

or if you need remove errors

Formula:

Please Login or Register  to view this content.