excel里如何在表2中将表2a1=表1a1并且表2b1=表1b1的两个条件下,将表2...
发布网友
共2个回答
热心网友
用VLOOKUP函数是
=VLOOKUP(A1&B1,IF({1,0},Sheet1!$A$1:$A$100&Sheet1!$B$1:$B$100,Sheet1!$C$1:$C$100),2,)
不用VLOOKUP函数，则可以是
=INDEX(Sheet1!C:C,MATCH(A1&B1,Sheet1!$A$1:$A$100&Sheet1!$B$1:$B$100,))
都是数组公式。
热心网友
=SUMPRODUCT((Sheet1!A1:A5=A1)*(Sheet1!B1:B5=B1)*(Sheet1!C1:C5))
