Match the right tags

[ramananhrm]

I have a question for the below mentioned issue
I have to find out the right tag from the approriate sub categories in the following sentences
How do we create a formula for this issue?
Please help me out

Pets Wild Birds Insects
Dog Lion Parrot Bee
Cat Tiger Pigeon Fly
Goat Crocodile Love Birds Bug
Sheep Cheetah Duck Ant
Hen Elephant Peocock Mosquito

Subcategories: Sentances
Wild: The Lion king
Pets: Dog is my friend
Insects: The risk insect is Mosquito
Insects: The Ant is always active
Wild: The Cheetah is fastest animal
Wild: The Lion and tiger are wild animals

The output should be as mentioned below

Subcategories: Sentances: Tags
Wild: The Lion king: Lion
Pets: Dog is my friend: Dog
Insects: The risk insect is Mosquito: Mosquito
Insects: The Ant is always active: And
Wild: The Cheetah is fastest animal: Cheetah
Wild: The Lion and tiger are wild animals: Lion, Tiger

 

[Shweta]

Hi Ramananhrm,

Try this:
=LOOKUP(3^15,SEARCH($H$2:$H$7,B2),$H$2:$H$7)

In Column H put TAGS & in Column B enter sentences

Hope this will work.

Shweta

 

[ramananhrm]

Hi Shweta,

Thank you so much for the timely reply.
Im little confused with the solution.
Please help me out how do i attach the excel sheet to show you the correct output.