从不同表格间接调用列 [英] Indirect call of a column from different sheet

问题描述

X- 20045 X- 200 200 X- 200 200 X- 200 200 X- 200 200：

  = INDIRECT（CHAR（ROW（A5））& ROW（A5））
  

但是，我很难操纵这个，从名为sheet1的不同表格中找到一个公式。

我试图使用间接公式检索Sheet1的B3中的值。任何帮助都不胜感激。

请注意，向前（我打算将此公式拖下去）我打算操纵行和列，所以我想要两个（行和列）作为变量值。

例如：NOT indirect（'Sheet1'！B3），而是像间接（'Sheet1！'& char ））...等），这不适合我。

感谢您的帮助！

解决方案

= INDIRECT（CHAR（ROW（A5））& ROW（A5））只是返回 #REF

不要使用类似 CHAR（）的东西来构建一个A1地址。更好地使用R1C1：

  = INDIRECT（'Sheet1'！R3C2，0）
  

使行可拖动：

  = INDIRECT（'Sheet1'！R& ROW（）&C2，0）
  

或适合列：

  = INDIRECT（'Sheet1'！R3C& COLUMN（），0） 
  

或两者：

  = INDIRECT（'Sheet1'！R& ROW（）&C& COLUMN（），0）
  

I know how to use the indirect formula in a sheet itself.

=INDIRECT(CHAR(ROW(A5))&ROW(A5)) 

However, I am having hard time manipulating this to find a formula from different sheet called 'sheet1'

I am trying to retrieve value in B3 of Sheet1 using indirect formula. Any help is appreciated.

Please note, going forward (I plan to drag this formula down) I plan to manipulate rows and columns so I do want both of them (rows and columns) as variable values.

Eg: NOT indirect('Sheet1'!B3) but rather something like indirect('Sheet1!'&char(row(a5))...etc) which is not working for me.

Thanks for the help!

解决方案

=INDIRECT(CHAR(ROW(A5))&ROW(A5)) just returns #REF

do not use something like CHAR() to build a "A1" address. Better use R1C1:

=INDIRECT("'Sheet1'!R3C2",0)

to make the row dragable:

=INDIRECT("'Sheet1'!R"&ROW()&"C2",0)

or to fit the columns:

=INDIRECT("'Sheet1'!R3C"&COLUMN(),0)

or for both:

=INDIRECT("'Sheet1'!R"&ROW()&"C"&COLUMN(),0)

这篇关于从不同表格间接调用列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！