Thread: lookup or search text in sentence that match with keyword

hi, need some help in search or lookup this case.

i have list in A2:A4 (description) and B2:B4 is the Group of.

now i want B2:B4 fill using E2:G2 (group list which is Animal, transportation and fruit) if one of the key word in E3:G5 found in A2:A4

A2: people like to eat apple
A3: car is very expensive
A4 : dog is human best friend

E2: Animal, F2 : transportation, G2: Fruit

E3:E5 = dog, cat, horse
F3:F5 = train, ship, car
G3:G5 = apple, banana, watermelon

result i want is :
B2 :Fruit,
B3 : transportation
and B4 is animal

thanks for helping

edit: sample attached

Hi

Which is the number of words that you use for searcing(I mean that in your example, in E3:G5, you use 9 words. Are these all???)