判斷多條件 找售价 (9181)

J2=SUMPRODUCT((LEFT(B$2:B$10,FIND("-",B$2:B$10)-1)-G2<=0)*(MID(B$2:B$10,FIND("-",B$2:B$10)+1,9)-G2>=0)*(A$2:A$10=F2)*((0&MID(C$2:C$10,{1,9,17,25},1))-H2=0)*((0&MID(C$2:C$10,{3,11,19,27},2))-I2<=0)*((0&MID(C$2:C$10,{6,14,22,30},2))-I2>=0)*D$2:D$10)