Finding strings in vlookup value, embedded in larger strings within the table array

I need to do a vlookup that takes a string from one cell and then tries to find that string (embedded in a larger string) in the table array

Essentially I imagine this involves the FIND funtion at some point.

Attached is an incredibly simplified example of what I’m looking for.

Thanks in advance, for your help