多條件匹配數據 (14546)

D2{=LOOKUP(1,0/(G$2:G$20=A2)/(H$2:H$20=B2)/(IFERROR(LEFT(I$2:I$20,3)*1,)-C2<=0),J$2:J$20)

另解=LOOKUP(,0/FREQUENCY(C2,{100,200,300}),OFFSET(J$1,LOOKUP(1,0/(A2=G$2:G$20)/(B2=H$2:H$20),ROW($1:$19)),,-4))