Find substring in range and categorise cells in range based on substring found

Hi there forum,
I have a list of transactions that I am trying to allocate a category and sub-category to.
The transaction list consists of a string as the Description, part of which can be the same for each transaction, but with a variable code attached at the end, no consistent length of the string.
Is it possible (with formula) to use a reference table to look for a substring in the Description string then allocate a category & subcategory to the transaction based on the substring found?
Cheers, S.

Thanks Mrrrr!
Working a treat