求助让运费自动计算的公式,以前有个公式是=INDEX(报价!$B$3:$AF$9,MATCH(LOOKUP(J4,--LEFT(报价!$A$3:$A$9,FIND("-",报价!$A$3:$A$9)-1)),--LEFT(报价!$A$3:$A$9,FIND("-",报价!$A$3:$A$9)-1)),MATCH(F4,报价!$B$2:$AF$2,)),可是现在表格样式变了,不能使用了,希望各位老师同学能帮忙修改一下。谢谢
=INDEX(报价单!$B$5:$AF$25,MATCH(LOOKUP(D2,--LEFT(报价单!$A$5:$A$25,FIND("-",报价单!$A$5:$A$25)-1)),--LEFT(报价单!$A$5:$A$25,FIND("-",报价单!$A$5:$A$25)-1)),MATCH(G2,报价单!$B$2:$AF$2,))
数组公式
|