=INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{"C","D","E","F"})&MATCH(B11,B4:B7,0)+3)
来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/23 13:31:39
=INDIRECT(LOOKUP(MATCH(C10,C3:F3,0),{1,2,3,4},{"C","D","E","F"})&MATCH(B11,B4:B7,0)+3)=INDIRECT(LOOK
=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))) 求解析该函数...