Get Formula for searching text between 2 columns and show result

[Anantha Krishna]

Hello All,

I need help to get formula for below scenario.

for the Product if there is no mention N on Delta column then on Result column should come as No

If for the Product having N on Delta column then on Result column should come as Yes

Product	Delta	Result
35314133 Base	N	Yes
35314133 Base	Y	Yes
35314133 Chassis	N	Yes
35314133 Chassis	Y	Yes
35314133 Graphics	Y	No
35314133 Graphics	Y	No

Thank you in Advance

Regards,
Anantha Krishna

 

[ETAF]

how about
=IF(COUNTIFS($A$2:$A$7,A2,$B$2:$B$7,"N"),"YES","NO")

 

[Anantha Krishna]

Hello ETAF,

This helps a lot, thank you

 

[ETAF]

you are welcome