How to return another cells content using Index,Match with a IF/OR statement

I want to return another cells contents using index and matching 2 other criteria. One of those criteria can be either of 2 things.

I can get a correct result if I only use strictly 2 criteria without a IF/OR statement:
{=INDEX($F$28:$F$33,MATCH(1,(Sheet3!C5=$C$28:$C$33)*(Sheet3!E5="Yellow"),0))}

But get an incorrect result when using with a IF/OR statement:
{=INDEX($F$28:$F$33,MATCH(1,(Sheet3!C7=$C$28:$C$33)*(IF(OR(Sheet3!E7="Yellow",Sheet3!E7="Red"),0))))}

See cell F7 in attachment and thank you for any advise.