Help with INDEX & MATCH using several criteria

Please try

H3

=IFERROR(INDEX($D$3:$D$999,MATCH(1,INDEX(($A$3:$A$999=$G3)*($B$3:$B$999=$G$1)*($C$3:$C$999=H$2),),)),"")

N3

=IFERROR(INDEX($D$3:$D$999,MATCH(1,INDEX(($A$3:$A$999=$G3)*($B$3:$B$999=$M$1)*($C$3:$C$999=N$2),),)),"")

์Need to change G1, M1 when copy to next Supervisor


or H3 can copy to all

=IFERROR(INDEX($D$3:$D$999,MATCH(1,INDEX(($A$3:$A$999=$G3)*($B$3:$B$999=LOOKUP(2,1/($G$1:G$1<>$H$1)/($G$1:G$1<>""),$G$1:G$1))*($C$3:$C$999=H$2),),)),"")

Non ARRAY formula in H3 then copied to other ranges.

Please Login or Register  to view this content.