=INDEX($AJ$10:$AK$25,MATCH(AB7,$AJ$10:$AJ$25,$AK$10:$AK$25),2)+(AB7-INDEX($AJ$10:$AK$25,MATCH(AB7,$AJ$10:$AJ$25,$AK$10:$AK$25),1))*(INDEX($AJ$10:$AK$25,MATCH(AB7,$AJ$10:$AJ$25,$AK$10:$AK$25)+1,2)-INDEX($AJ$10:$AK$25,MATCH(AB7,$AJ$10:$AJ$25,$AK$10:$AK$25),2))/(INDEX($AJ$10:$AK$25,MATCH(AB7,$AJ$10:$AJ$25,$AK$10:$AK$25)+1,1)-INDEX(AJ$10:$AK$25,MATCH(AB7,$AJ$10:$AJ$25,$AK$10:$AK$25),1))
$号就是绝对引用，拖动不变
不想变的均采用绝对地址，即$AJ$10,$AK$25......,$AB7,$AB8...
内容全部来源于网络收集，如有侵权，请联系网站删除！