07.07 双条件查找的，有个高手收集了24中方法，特奉献出来！

图例：

一、函数法： 7

1、 =SUMPRODUCT((A2:A6=E2)*(B2:B6=F2)*(C2:C6))

2、 =SUM((A2:A6=E2)*(B2:B6=F2)*C2:C6)

3、 =MAX((A2:A6=E2)*(B2:B6=F2)*C2:C6)

4、lookUp =LOOKUP(E2&F2,A2:A6&B2:B6,C2:C6)

=LOOKUP(1,0/((A2:A6=E2)*(B2:B6=F2)),C2:C6)

=LOOKUP(1,0/((A2:A6&B2:B6)=(E2&F2)),C2:C6)

=LOOKUP(1,1/(((A2:A6=E2)+(B2:B6=F2))=2),C2:C6)

二、函数组合法 9

=MIN(IF((A2:A6=E2)*(B2:B6=F2),C2:C6))

=SUM(IF(A2:A6=E2,IF(B2:B6=F2,C2:C6,0),0))

=INDEX(C2:C6,MATCH(E2&F2,A2:A6&B2:B6,0))

=INDEX(C2:C6,MATCH(1,(E2=A2:A6)*(F2=B2:B6),0))

=OFFSET(C1,MATCH(E2&F2,A2:A6&B2:B6,0),)

=INDIRECT("C"&MATCH(E2&F2,A1:A6&B1:B6,0))

=VLOOKUP(E2&F2,CHOOSE({1,2},A2:A6&B2:B6,B2:C6),2,0)

=HLOOKUP(E2&F2,TRANSPOSE(CHOOSE({1,2},A2:A6&B2:B6,B2:C6)),2,0)

=VLOOKUP(E2&F2,IF({1,0},A2:A6&B2:B6,B2:C6),2,0)

三、使用辅助列 2

=VLOOKUP(E2&F2,A16:D21,4,0)

=SUMIFS(C1:C6,A1:A6,E2,B1:B6,F2) office2007

四、数据库（6））

=DSUM(A1:C6,3,E1:F2)

=DGET(A1:C6,3,E1:F2)

=DAVERAGE(A1:C6,3,E1:F2)

=DMAX(A1:C6,3,E1:F2)

=DMIN(A1:C6,3,E1:F2)

=DPRODUCT(A1:C6,3,E1:F2)