最接近的單價 不分大於或小於與需小於 二種 (13364)

H2{=INDEX(C:C,RIGHT(MIN(IF((A$2:A$16=E2)*(B$2:B$16=F2),ABS(C$2:C$16-G2)/1%+ROW($2:$16))),2))

I2{=MAX(IF((A$2:A$16=E2)*(B$2:B$16=F2)*(C$2:C$16<=G2),C$2:C$16))