Hi
I would like to add a second "logical test" to the IF statement to add YELLOW. so IF(OR(RED=b3:b10, YELLOW = b3:b10
I've tried SMALL(IF(OR but couldn't get that too work
=INDEX($C$3:$C$10, SMALL(IF("Red"=$B$3:$B$10, ROW($B$3:$B$10)-MIN(ROW($B$3:$B$10))+1, ""), ROW(A2)))
Much appreciated...