取上月之前的最后一次价格 (12159)

E2=RIGHT(MAX(IF(EOMONTH(A2,-1)>=A$2:A$13,A$2:A$13/1%+D$2:D$13)),2)*1

另解=LOOKUP(,0/FREQUENCY(9^-9,(EOMONTH(A2,-1)+1-$A$2:$A$13)*($B$2:$B$13=B2)),$D$2:$D$13)