谁能介绍一下呢=INDIRECT("A"&INDEX(A$4:A$49,SMALL(IF(INDIRECT(INDEX($D$1:$AO$1,MATCH($B$55,$D$2:$AO$2,0))&4):INDIRECT(INDEX($D$1:$AO$1,MATCH($B$55,$D$2:$AO$2,0))&49)"",ROW(INDIRECT(INDEX($D$1:$AO$1,MATCH($B$55,$D$2:$AO$2,0))&4):INDIRECT(INDEX($

Question

谁能介绍一下呢
=INDIRECT("A"&INDEX(A$4:A$49,SMALL(IF(INDIRECT(INDEX($D$1:$AO$1,MATCH($B$55,$D$2:$AO$2,0))&4):INDIRECT(INDEX($D$1:$AO$1,MATCH($B$55,$D$2:$AO$2,0))&49)"",ROW(INDIRECT(INDEX($D$1:$AO$1,MATCH($B$55,$D$2:$AO$2,0))&4):INDIRECT(INDEX($D$1:$AO$1,MATCH($B$55,$D$2:$AO$2,0))&49)),200),ROW(A1))))*1

Answer 1

INDIRECT返回由文本字符串指定的引用
INDEX用于返回表格或区域中的数值或对数值的引用
SMALL用于返回第几小(1就是最小)
IF判断语句,返回真值,或假值
MATCH查找函数 MATCH 返回 lookup_array 中目标值的位置,而不是数值本身
ROW取行号