=INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{"C","D","E","F"})&MATCH(B11,B4:B7,0)+3)

来源：学生作业帮助网 编辑：作业帮 时间：2024/05/09 19:56:17
=INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{

=INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{"C","D","E","F"})&MATCH(B11,B4:B7,0)+3)
=INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{"C","D","E","F"})&MATCH(B11,B4:B7,0)+3)

=INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{"C","D","E","F"})&MATCH(B11,B4:B7,0)+3)
1、
MATCH(C10,C3:F3,0)
在c3:f3这个区域中查找与c10单元格相同数据的位置,即1-4之间的数.
2、
LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{"C","D","E","F"})
lookup函数根据反正值在1到4中进行匹配,并返回对应位置的c到f的值.
3、
MATCH(B11,B4:B7,0)+3
在b4:b7这个区域中查找与b11单元格相同数据的位置,即1-4之间的数.并将该数字加3.
4、
&
将上面返回的2个数据进行组合.变为一个c4:f7这个区域中的任意一个单元格的单元格号.
5、
INDIRECT
根据之前返回的单元格号,返回对应单元格的数据.

lookup用vlookup替代达到不用升序排列查询值=LOOKUP($B3,INDIRECT($A$1&!$B$2:$B$59),INDIRECT($A$2&!&CHAR(74+COLUMN())&$2:&CHAR(75+COLUMN())&$59))-LOOKUP($B3,INDIRECT($B$1&!$B$2:$B$59),INDIRECT($B$2&!&CHAR(74+COLUMN())&$2:&CHAR indirect函数详解 =INDIRECT 谁能解释一下这个公式的意思=LOOKUP(4^8,IF({1,0},0,VLOOKUP($A4,INDIRECT(B$3&!a1:F100),6,))) =INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{C,D,E,F})&MATCH(B11,B4:B7,0)+3) INDIRECT函数=INDIRECT($A17&!&S4) =INDIRECT(A2&!Al18) indirect 谁能帮我解释一下这个execl函数?=VLOOKUP(B3,INDIRECT(LOOKUP(1,0/(COUNTIF(INDIRECT({11,14,22,23,27,28,32,33,34,42,43,44,45,46,48,51,53,54,55,57,58,63,66,67}&!F:J),B3)),{11,14,22,23,2 INDIRECT函数 =INDIRECT($A6&!&V$1&$B6),急, excel这段公式求解释OFFSET(INDIRECT(A&MATCH(F2,A$2:A$7,0)),LOOKUP(G2,{0,30,50},{1,2,3}),3,1,1) #include #include #include #include using namespace std ;typedef vector < vector > Mat ;Mat input() ;void mySort(Mat& a) ;void print(const Mat& a) ;int main(){Mat a = input() ;mySort(a) ;print(a) ;system (PAUSE) ;return 0 ;}Mat input(){ifstream in( =SUM(LOOKUP(5,A1:A8,B1:B8),LOOKUP(5,A2:A9,D2:D9))是什么意思 LOOKUP函数=LOOKUP(1,0/(C22:AAA22>0),C22:AAA22) =SUM(INDIRECT(B1:B&ROW())), =SUM(INDIRECT(E1:E&ROW()-1)) =(INDIRECT('&$B23&'!&F$1&$D23)) 这个语句不明白,尤其是那个Ts=SUM(SUMIF(INDIRECT('&ROW(INDIRECT(1:&Ts))&'!B:B),B5,INDIRECT('&ROW(INDIRECT(1:&Ts))&'!E:E))) Excel 问题求教育：=INDIRECT(INDIRECT(ADDRESS(ROW(),3))) 求解析该函数...