Replace Nested IF with ( Trim. offset.vlookup) to calculate faster

[wellous]

Hello Experts,

I have a file that calculate the MIN/ Avg/ Mode/ Max points for some providers the file is working good but very slow when you include all the needed records (around 50k records)
i think this is due to repteaded long nested IF - i am attaching a sample as well - here is the formula i would like to do but without nested IF:

=MIN(IF((Sheet1!$J$2:$J$7933=A2)*(Sheet1!$DK$2:$DK$7933=B2)*(Sheet1!$O$2:$O$7933=C2)*(Sheet1!$DJ$2:$DJ$7933=D2)*(Sheet1!$AA$2:$AA$7933=E2)*(Sheet1!$F$2:$F$7933=F2)*(Sheet1!$AC$2:$AC$7933=G2)*(Sheet1!$CB$2:$CB$7933=H2)*(Sheet1!$L$2:$L$7933=I2),Sheet1!$DX$2:$DX$7933))

Appreciate for your help,
many thanks,
Wellous