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
[TABLE="width: 571"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD][/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]Baseball[/TD]
[TD]n[/TD]
[TD]Baseball[/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]Baseball[/TD]
[TD]n[/TD]
[TD]Football[/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]Baseball[/TD]
[TD]y[/TD]
[TD]Golf[/TD]
[TD]n[/TD]
[/TR]
[TR]
[TD]Football[/TD]
[TD]y[/TD]
[TD]soccer[/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]Football[/TD]
[TD]y[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Golf[/TD]
[TD]n[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Golf[/TD]
[TD]n[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Golf[/TD]
[TD]n[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Golf[/TD]
[TD]n[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]soccer[/TD]
[TD]y[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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