Can you use AND / OR in an INDEX MATCH

Hi David,

More exactly

(A=A2 OR A=T2) AND (B = B2 AND C=C2)

, that was my misprint. In this case array formula could be

=IFERROR(INDEX('Rebate report'!A:A,MATCH(1,((('Rebate report'!A:A=A2)+('Rebate report'!A:A=T2))>0)*('Rebate report'!B:B=B2)*('R'!C:C=C2),0),1),0)

First multiplier in MATCH imitates OR condition, next are with AND