單價 依數量 (11409)

 H2=IFERROR(LOOKUP(1,0/(F2=A$2:A$17)/(G2>=B$2:B$17),D$2:D$17),VLOOKUP(F2,A:D,4,))



留言