What if formula if one condition is met

[pto160]

I have a credit card dispute report. I am trying to write a what if formula that if a certain condition is met then to fill in yes for all instances of the order number.
In this example, that if an order has a PRE-ARB, then to put in yes for all instances of the order number that has PRE-ARB. So order 100 has a PRE-ARB, then I want YES (has PRE-ARB) for order 100. Here is the data.

Book1
	A	B	C
1	Order	TYPE	PRE-ARB?
2	100	DISPUTE	YES
3	200	DISPUTE	NO
4	100	REVERSAL	YES
5	300	DISPUTE	NO
6	100	PRE-ARB	YES
7	500	DISPUTE	NO
Sheet1

 

[Joe4]

Put this formula in cell C2 and copy down:

=IF(COUNTIFS(A:A,A2,B:B,"PRE-ARB")>0,"YES","NO")

 

[Scott Huish]

Try this:

Book1
	A	B	C
1	Order	TYPE	PRE-ARB?
2	100	DISPUTE	YES
3	200	DISPUTE	NO
4	100	REVERSAL	YES
5	300	DISPUTE	NO
6	100	PRE-ARB	YES
7	500	DISPUTE	NO
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=IF(COUNTIFS(A:A,A2,B:B,"PRE-ARB"),"YES","NO")

 

[pto160]

This is exactly what I am looking for. Fantastic. Thank you so much to everyone. This will really help me with my report.

 

[Joe4]

You are welcome.
Glad we were able to help!