Excel VLOOKUP and SEARCH combination

Hi,

I'm trying to search for part of a text string, in a column of text and return the values in a second column.


if cell contains text "abc" within then return a specific lookup value.

I.e. column a has the following cells:

zebra black
dog white
elephant blue

In column B I need a formulae that looks in column E but returns values from column F. So if zebra black contains black then return value in column F

Column E Column F
BLACK $100
BLUE $200
GREEN

Thanks in advance for your help.