Finding text amongst longer text using vlookup (Take 2)

Unlike my previous post, I have attached a small sample file that does relate to the data mentioned below.
In this sample I would like to have the VLookup formula return a value of "C:\Bill" which is the desired folder.
I would like the VLookup to search Column B to see if it contains the text in the partial column (i.e Reaper).
Could someone tell me what the VLookup is or if I may need to use Index, MATCH.
Thank you for any help offered.