依季查调价日期後单价 (9745)

H2=IFERROR(LOOKUP(1,0/((LEFT(G3,FIND("-",G3)-1)&"月1日")-C$3:C$8>=0)/(B$3:B$8=F3),D$3:D$8),VLOOKUP(F3,B:D,3,))