Vlookup - Search for text within a string

I am trying to perform a vlookup searching for a string of text within a column.

Example:

B2 = "Blue"
In column C, there is a phrase "I want a blue horse".
D:D = my return values after lookup

How would i perform a vlookup on the value of B2 within column C and return the value of D?