place text in row for all matching instances in range

[saralouise]

here's what I'm trying to accomplish:
if any of the same ID number in column B have Type 1 and Type 2 in column c, mark all rows associated with that same ID number with "priority" in column A

i have =IF(AND(B3=B4,C3<>C4),"PRIORITY","") in column A and have been trying to use it as a helper column, but i can't figure out how to check to see if the ID number in the row with "PRIORITY" is matched anywhere else in column B and then also place the text for all matching instances.

A	B	C
	ID #	Type
	1	Type 1
	1	Type 1
PRIORITY	2	Type 1
	2	Type 2
	9	Type 1
	9	Type 1
	9	Type 1
	9	Type 1
	9	Type 1
	9	Type 1
	9	Type 1
	9	Type 1
	9	Type 1
	9	Type 1
	9	Type 1
PRIORITY	9	Type 1
	9	Type 2
	9	Type 2
	9	Type 2
	12	Type 1
	16	Type 1
	16	Type 1
	16	Type 1
PRIORITY	16	Type 1
	16	Type 2
	13	Type 2
	14	Type 2
	15	Type 2

<colgroup><col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> </colgroup><tbody>
</tbody>

open to VBA or formula.

thank you!

 

[Firesword]

Hi Saralouise, If I've understood your request then this should work
=IF(SUMIFS($B:$B,$B:$B,B3,$C:$C,"Type 1")>0,IF(SUMIFS($B:$B,$B:$B,B3,$C:$C,"Type 2")>0,"PRIORITY",""),"")

 

[saralouise]

yes, thank you!! so simply elegant that i hadn't occurred to me - i got down the rabbit hole of far more complicated solutions.