第1个回答 2019-04-07
可用下面的公式:
=INDEX(Sheet2!$A:$A,MATCH("*"&LEFT(Sheet1!B2,2)&"*",Sheet2!$C:$C,))+(C2>1)*CEILING(C2-1,1)*INDEX(Sheet2!$B:$B,MATCH("*"&LEFT(Sheet1!B2,2)&"*",Sheet2!$C:$C,))
或
=INDEX(Sheet2!$A:$A,MATCH("*"&LEFT(Sheet1!B2,2)&"*",Sheet2!$C:$C,))+IF(C2<=1,0,CEILING(C2-1,1)*INDEX(Sheet2!$B:$B,MATCH("*"&LEFT(Sheet1!B2,2)&"*",Sheet2!$C:$C,)))
下拉填充