IF 2 criteria in same range

[ExcelNewbie2020]

Please see expected result for better understanding.. thank you

testing.xlsx
	A	B	C	D	E	F	G	H	I
1	NAME	ITEM	CODE	EXPECTED RESULT				CONDITION PER ITEM
2	NAME1	A	XX	YES
3	NAME2	A	YY	YES				XX=1	YES
4	NAME3	B	XX	NO				YY=1	YES
5	NAME4	B	XX	NO				XX AND YY >1	NO
6	NAME5	B	YY	YES
7	NAME6	O	YY	NO
8	NAME7	O	XX	YES
9	NAME8	O	YY	NO
10	NAME9	G	XX	NO
11	NAME10	G	XX	NO
12	NAME11	G	YY	NO
13	NAME12	G	YY	NO
Sheet26

 

[Fluff]

How about

=IF(COUNTIFS(B:B,B2,C:C,C2)>1,"No","Yes")