Need fast Arrayformula for index match


#1

Guys
I create an index match formula that copy down all the way to 1000 rows. That makes it so slows. Is a way to speed it up? M2 match to range $B$2:$B$1000 is a datetime and match type is 1

=iferror(INDEX($A$2:$A$1000,MATCH(M2,IF(($C$2:$C$1000=N2)*($D$2:$D$1000=O2)*($E$2:$E$1000=P2)*($F$2:$F$1000=Q2)*($G$2:$G$1000=R2),$B$2:$B$1000),1)),"")

Thank very much


#2

@desmondlee do you have a live example to play with?