Vlookup - Search for text within a string

[PY_]

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?

[davesexcel]

Possibly this
=VLOOKUP("*" & B2 & "*",$C$2:$D$4,2,0)

[PY_]

That works great. I was not aware i could use wildcards in vlookup. Good to know!

Thank you davesexcel!