• slider image 221
:::

4-15 EXCEL 多條件搜尋

=INDEX(B5:B10,MATCH(B13,C5:C10,0))
 

多條件

=INDEX(D25:D30,MATCH(C32&C33,B25:B30&C25:C30,0))
 

 

openoffice 可行 , ms office 否

=INDEX($acc.A$1:K$1098,MATCH($C25&$F25&$G25,$acc.$D$1:$D$1098&$acc.$A$1:$A$1098&$acc.$B$1:$B$1098,0),1)
 

 

ms office 可,openoffice 否

=LOOKUP(2,1/(acc!$D$1:$D$2000=$C2)/(acc!$A$1:$A$2000=$F2)/(acc!$B$1:B$2000=$G2),acc!A$1:A$2000)


站內搜尋