Searching a string within a string

I have a task at hand that I couldn't figure out how to do... There are three columns and two parts to the task

1. Query all the strings in column B into cell "A2" and find if anyone matches it.
2. If there is a match then return the corresponding value from column "C"

e.g. Cell A4 has the string in cell b12 and the outcome should be C12.


There is no defined starting poing and marker, so I can't use Find, Left or midle function.

I know the second part could be done with Vlookup as long as part 1 works. Unfortunately, thats where I am stuck.

I'd very much appreciate if someone can help me with it.

Thanks,
H