Lookdown Formula??

[MESHACK]

Need help with a formula. I have 1 column. Lookup value in below chart would be "Cat" and I would it to return the cell right below, in this case "3". Thank you in advance!!!



[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl64, width: 64"]Dog[/TD]
[/TR]
[TR]
[TD="class: xl63"]6[/TD]
[/TR]
[TR]
[TD="class: xl64"]Cat[/TD]
[/TR]
[TR]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl64"]Bird[/TD]
[/TR]
[TR]
[TD="class: xl63"]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[Weazel]

if there aren't any duplicates maybe something like...

=SUMIF(A1:A5,"cat",A2:A6)

 

[MESHACK]

Weazel,
There are no duplicates and this formula is working perfectly!!!!!!!
Thank you so much!!