You can put this array* formula in C2:

=INDEX(E$2:E$12,MIN(IF(ISNUMBER(SEARCH(E$2:E$12,B2)),ROW(E$2:E$12)-1)))

then copy down.

*Note that an array formula needs to be committed using the key combination Ctrl-Shift-Enter (CSE), instead of the usual < Enter >.

Hope this helps.

Pete