Try:

=LOOKUP(9.999999E+307,SEARCH($B$10:$B$49,B3),$A$10:$A$49)

copied down