Super tricky lookup problem

Hello Excel people,

I have an interesting problem I am trying to solve: We are searching for specific strings of text that are amongst lots of other characters (noise) as in the example below.

whj32Johndddejrj

The main problem is that the strings we are looking to locate in the noise are defined by a reference table (lookup table). Vlookup is not finding it easy to search for the data and is returning the largest value which is of no use.

Find attached the actual example of what I am working with.

Your thoughts on this are appreciated!

Niceguy21