More than 7 nested search if statments

[duckie123]

Hello,
I am having trouble figuring out how to search within the description below to find the type of animal. I have tried using If and Search functions but I know If statements can only be nested 7 times and there are more than 7 types of animals. Can anyone help me come up with a formula or macro to do this? Thanks in advance!

<table style="width: 220px; height: 301px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 92pt;" width="123"> <col style="width: 73pt;" width="97"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 92pt;" width="123" height="20">description</td> <td class="xl65" style="border-left: medium none; width: 73pt;" width="97">type of animal</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">brown dog</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">dog</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">orange cat</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">cat</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">yellow bird</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">bird</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">chicken with spots</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">chicken</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">red fish</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">fish</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">small box turtle</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">turtle</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">gray and black cat</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">cat</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">orange fish</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">fish</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">fuzzy hamster</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">hamster</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">brown mouse</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">mouse</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">gray dog</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">dog</td> </tr> </tbody></table>

 

[duckie123]

Thank you everyone! This works perfectly!!