=VLOOKUP(INDIRECT("A5")+2,INDIRECT("H2:I81"),2,0),括号中+2如何递增,

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/25 06:51:17

=VLOOKUP(INDIRECT("A5")+2,INDIRECT("H2:I81"),2,0),括号中+2如何递增,下来没用.
=VLOOKUP(INDIRECT("A5")+3,INDIRECT("H2:I81"),2,0)
=VLOOKUP(INDIRECT("A5")+4,INDIRECT("H2:I81"),2,0)
.
=VLOOKUP(INDIRECT("A5")+39,INDIRECT("H2:I81"),2,0)
要做十列,39行,有什么办法可以递增?

不明白为什么要使用INDIRECT,公式直接用：
=VLOOKUP($A$5+2,$H$2:$I$81,2,0)
就行了.

如果需要下拉递增,可用ROW()；如果要横拉递增,可用COLUMN()
如上面公式改为：
=VLOOKUP($A$5+ROW(A2),$H$2:$I$81,2,0)

=VLOOKUP($D$2,INDIRECT([abc.xlsx]B4&"!$Q$1:$S$50"),1,0)其中B4= VLOOKUP(B6,INDIRECT(--MID(B6,FIND("-",B6)+1,2)&"!b:c"),2,0)谁 VLOOKUP(B$9&ROW(A1),IF({1,0},$B$2:$B$6&COUNTIF(INDIRECT("b2: =INDIRECT("a"&2*ROW()-1)&INDIRECT("a"&2*ROW())求详解,改能里关系到文字位置 =SUMPRODUCT(SUMIF(INDIRECT(ROW($1:$2)&"!C:C"),$C5,INDIRECT(R indirect 函数 =INDIRECT(ADDRESS(2,2,COLUMN()-2))是什么意思 INDIRECT(CONCATENATE("常数!d",($B$2+2)) INDIRECT("EXCEL"&"!"&ADDRESS(2,COLUMN()))是什么意思? indirect函数详解 =INDIRECT 求解释在excel中,函数：=INDIRECT("sheet2!A"&((ROW(Sheet2!A2)-2)*20+(C {=SUM(vlookup(B2,C1：M5,row(indirect(B3&":"&B4))+1,0））}