excel函数，我想在表1中找到同时符合两个条件的对象，然后把匹配成功的表1中的D列反映到表2中

Question

如题所述

Answer 1

看不到表1数据对应的行号
重新截个图
建议用VLOOKUP

D5输入数组公式 =VLOOKUP(B5&C5,IF({1,0},$B$15:$B$17&$C$15:$C$17,$D$15:$D$17),2,0)
注意按CTRL+SHIFT+ENTER 输入，向下填充

Answer 2

=lookup(1,0/(('表1!'b$2:b$10=b2)*('表1!'c$2:c$10=c2)),'表1!'d$2:d$10)

Answer 3

=index(sheet1!$c$2:$c$100,sumproduct((sheet1!$a$2:$a$100=b4)*(sheet1!$b$2:$b$100=c4）*row(1:99)),1)
下拉复制公式

Answer 4

sheet2 C4
=lookup(1,0/((sheet1!A:A=B4)*(sheet1!B:B=B4)),sheet1!C:C)