區間取值 多條件 (13756)

K3{=OFFSET(D$2,MATCH(,0/(A$3:A$20=I3)/(J3<C$3:C$20),)-1,H3=E$2)

另解=LOOKUP(1,0/(J3>=C$3:C$20)/(J3<=B$3:B$20)/(I3=A$3:A$20),IF(H3=D$2,D$3:D$20,E$3:E$20))