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.
Bookmarks