M2=IFERROR(INDEX(Sheet2!$M$7:$M$2382,MATCH(1,INDEX((Sheet2!$C$7:$C$2382=$I2)*(Sheet2!$G$7:$G$2382=$J2)*(Sheet2!$F$7:$F$2382=$L2)*(Sheet2!$H$7:$H$2382=$K2),0),0)),"")
OR
M2=SUMIFS(Sheet2!$M$7:$M$2382,Sheet2!$C$7:$C$2382,$I2,Sheet2!$G$7:$G$2382,$J2,Sheet2!$F$7:$F$2382,$L2,Sheet2!$H$7:$H$2382,$K2)
TRY THIS AND COPY TOWARDS DOWN
Bookmarks