Vlookup that searches for text within a cell that is listed in a table arrary

Hi,

I want to create a vlookup formula that will search within the text of a cell for any word that is listed in a table array. Then if text is found that is listed in the table array, return the relevant column.

I want to use this formula to allocate lines from a bank statement to a category quickly and without having to manually select each line.

In this example I would want the formula to search for any text within column B that is listed in the table in column F. If yes, return column G. If not, error out.
Capture.PNG

As "Golf" is contained in cell B2, the formula should return G2 "1-2300"

I have tried a combination of formulas but cannot wort this out. Your help would be appreciated.

Ross

Thanks! that's exactly what I was after