Try

=LOOKUP(2,1/(ISNUMBER(SEARCH($C$2:$C$4,A2))),$D$2:$D$4)

adjust ranges to suit.