公式:
1=OFFSET($B$2,MATCH(B10,B3:B7,0),MATCH(C10,C2:H2,0))
2 =INDEX(C3:H7,MATCH(B10,B3:B7,0),MATCH(C10,...C2:H2,0))
3=VLOOKUP(B10,$B$3:$H$7,MATCH(C10,$C$2:$H$2,0)+1,0)
4=INDIRECT(ADDRESS(MATCH(B10,B1:B7,0),MATCH...(C10,A2:H2,0),,,"sheet1"))
5 =HLOOKUP(C10,C2:H7,MATCH(B10,B2:B7,0),0)
6 =LOOKUP(1,0/(B10=B2:B7),OFFSET...(B2:B7,,MATCH(C10,B2:H2,0)-1,))
7=SUMPRODUCT(($B$3:$B$7=B10)*($C$2:$H$2=C10)*$C$3:$H$7)
8=SUM((B3:B7...=B10)*(C2:H2=C10)*(C3:H7)) 数组公式
9=MAX((B3:B7=B10)*(C2:H2=C10)*(C3:H7))
作者:excel精英培训