Vlookup - if there are multiple occurances, is one of them not equal to 0?

[bluefish44]

I am looking to create a vlookup where if there is at least one occurance that is not 0, then there is a match and the vlookup it will return a "Y"

example:
Lookup value is Panda

Column A I have the following words going down with corresponding values in column B
Panda, 0
Tiger, 0
Panda, 0
Lion, 1
Panda, 1
Tiger, 0
Panda, 0

If I do a regular vlookup on Panda it will go to the first one which shows a 0, so the formula will not return a "Y" even though there are multiple occurances of the word Panda and at least one of them has a value that is not 0?

Any ideas?

 

[mole999]

cute, they have names