Search cell for words in table and then return table header

Hi,

I have a list of transactions. I need to label them with a type by checking them against a table and then returning the column header.

I have something that is working (which somebody on here helped me with already)

..however, my current solution searches the table for words on the transaction list. If the exact match isn't on the list then it doesn't work. For example, if I have Tesco on the data table but my list says "Tesco 1234", i don't get a match.

I think I need to be searching the list for words from the table instead (so searching the list for "Tesco" instead of searching the table for "Tesco 1234") ...or something like that. But I can't figure it out.

See attached example.


Thanks in advance for any help!