Question

EXCEL公式查找出同时满足三个条件返回值

表一：

表二：

要求结果就是表一D能够正确匹配，表二D数据。跪求告诉高手相救





Answer 1

表一的D1输入
=lookup(1,0/((表二!A$1:A$500=A1)*(表二!B$1:B$500=B1)*(表二!C$1:C$500=C1)),表二!D$1:D$500)
下拉，就行了。

Answer 2

=sumproduct((sheet2!A$2:A$100=sheet1!A2)*(sheet2!B$2:B$100=sheet1!B2)*(shee2!C$2:C$100=sheet1!C2)*(sheet2!D$2:D$100)) 下拉公式填充,,,