C1è¾å ¥
=IF(B1=$A$1+$A$2,$A$1&"."&$A$2,IF(B2=$A$1+$A$3,$A$1&"."&$A$3,IF(B1=$A$2+$A$3,$A$2&"."&$A$3,IF(B1=$A$1+$A$2+$A$3,$A$1&"."&$A$2&"."&$A$3,"æ å¹é "))))
ä¸æ
温馨提示：答案为网友推荐，仅供参考
第1个回答 2019-01-17
公式一:
=index(sheet2!c:c,match($a2&$b2,sheet2!$a$1:$a$1000&sheet2!$b$1:$b$1000,))
数组公式,按CTRL+SHIFT+ENTER结束
右拉填充,下拉填充
公式二:
=vlookup($a2&$b2,if({1,0},sheet2!$a$1:$a$1000&sheet2!$b$1:$b$1000,sheet2!c$1:c$1000),2,)
数组公式,按CTRL+SHIFT+ENTER结束
右拉填充,下拉填充
公式三:
=sumproduct((sheet2!$a$2:$a$1000=$a2)*(sheet2!$b$2:$b$1000=$b2)*sheet2!c$2:c$1000)
右拉填充,下拉填充
=index(sheet2!c:c,match($a2&$b2,sheet2!$a$1:$a$1000&sheet2!$b$1:$b$1000,))
数组公式,按CTRL+SHIFT+ENTER结束
右拉填充,下拉填充
公式二:
=vlookup($a2&$b2,if({1,0},sheet2!$a$1:$a$1000&sheet2!$b$1:$b$1000,sheet2!c$1:c$1000),2,)
数组公式,按CTRL+SHIFT+ENTER结束
右拉填充,下拉填充
公式三:
=sumproduct((sheet2!$a$2:$a$1000=$a2)*(sheet2!$b$2:$b$1000=$b2)*sheet2!c$2:c$1000)
右拉填充,下拉填充
第2个回答 2019-01-17
C2=SUMPRODUCT((SHEET2!A:A=A2)*(SHEET2!B:B=B2)*C:C)
D2=SUMPRODUCT((SHEET2!A:A=A2)*(SHEET2!B:B=B2)*D:D)
D2=SUMPRODUCT((SHEET2!A:A=A2)*(SHEET2!B:B=B2)*D:D)
相似回答