[练习题]三维条件查找

Luckyguy2008

<br/>来一个比较长的<br/>=IF(ROW(A1)&gt;SUM(COUNTIF(INDIRECT({"DD";"CC";"DX";"AA"}&amp;"!C:C"),"&gt;"&amp;$B$1)),"",LOOKUP(MOD(SMALL(IF(N(INDIRECT({"DD!","CC!","DX!","AA!"}&amp;"C"&amp;ROW($2:$100)))&gt;$B$1,{1,2,3,4}*10^9+ROW($2:$100)),ROW(A1)),10^5),ROW($2:$100),CHOOSE(SMALL(IF(N(INDIRECT({"DD!","CC!","DX!","AA!"}&amp;"C"&amp;ROW($2:$100)))&gt;$B$1,{1,2,3,4}),ROW(A1)),DD!A$2:A$100,CC!A$2:A$100,DX!A$2:A$100,AA!A$2:A$100)))<br/>

sbkmlaini

那全公式好长，晕了能这样吗~

sbkmlaini

那全公式好长，晕了能这样吗~

szyygb

学习之余，深感佩服.............