Find text within a string + column and return a value

How can i vlookup the word "blue" in column A and return "2" from column B?


one red car 1
one blue bus 2
five green trucks 3

You can use Wildcards in VLOOKUP, eg:

=VLOOKUP("*blue*",A:B,2,0)

I had to add the following to look up a cell's value and it seems to work correctly.

"*"&D1&"*"

Thank you very much!