Vlookup with multiple occurances, return a "Y" if the value appears at least once

[bluefish44]

Hi all - thanks in advance.

I think this is fairly straightforward with an array formula but can't get it to function. If I have a column that has multiple occurences of a word, and the second column contains either a "n" or a "y", if any of the the occurences contain a "Y" I want the formuala to return a "Y".
See below for example

DATA	DATA		FORMULA
Baseball	n	Baseball	y
Baseball	n	Football	y
Baseball	y	Golf	n
Football	y	soccer	y
Football	y
Golf	n
Golf	n
Golf	n
Golf	n
soccer	y

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

How about
=IF(COUNTIFS(A:A,C2,B:B,"y")>0,"Y","N")

 

[bluefish44]

It looks like that did the trick! Thank You - guess I didn't need the array

 

[Fluff]

You're welcome & thanks for the feedback