內插植 數字介於二數字之間 取平均值 (13575)

C2=OFFSET(G$1,MATCH(B2,F:F),)-(OFFSET(F$1,MATCH(B2,F:F),)-B2)*LOOKUP(1,0/FREQUENCY(B2,F$3:F$4-0.1),(G$3:G$5-G$2:G$4)/(F$3:F$5-F$2:F$4))

另解=OFFSET(G$1,MATCH(B2,F:F),)-(OFFSET(F$1,MATCH(B2,F:F),)-B2)*SUM(N(OFFSET(G$1,MATCH(B2,F:F)-{0,1},))*{1,-1})/SUM(N(OFFSET(F$1,MATCH(B2,F:F)-{0,1},))*{1,-1})