excel链接到同一工作簿中的另一个工作表 [英] excel link to another sheet in same workbook

问题描述

假设我有一本excel工作簿，有四张标签：
352
353
354
Sheet1

假设表352中的A1单元是这取自352

假设表353中的A1单元格是这取自353

假设表354中的A1单元格是这取自354

现在我想能够链接到各种A1单元格，所以我询问一张表单上的链接（例如，标记为352的）到另一个表单，即标签为Sheet1的表格。

我知道如何正常执行此操作：在Sheet1中输入公式='352'！$ A $ 1

但是，我希望Sheet1中的条目被用作参考名称而不是明确使用352.所以，例如，如果Sheet1中的A1的条目是352，那么我想要我想要的公式给出与what ='352'！$ A $ 1将给出的相同的确切值。

要详细说明一下，Sheet1中的A1将为352
A2在Sheet1中将是353
Sheet1中的A3将为354。

我想直观地基本上是= [[Sheet1！$ B $ 1] 352'！$ A $ 1但我还是有那么麻烦的352，但我不想在那里352，我想要一个动态的参考A1在Sheet1（这只是现在是352现在）。

解决方案

= INDIRECT（A2&！A1），如果A2是上一个或其他工作表名称OR号，它应该工作。注意：在该公式的复制/粘贴中，引号（）可能会成为双重撇号（'） - 这将不起作用。如果表单被克隆，只需将A2更改为现在的上一个工作表名称。没有必要编辑公式，我现在有两个工作簿现在使用这个公式，一个已经有一个单元格，前面的工作表名称用于该工作表的计算，这些工作表可以是实际名称（Jan，Feb等）或数字（352,353等）。

Suppose I have an excel workbook having four sheets labeled: 352 353 354 Sheet1

Suppose that the A1 cell in sheet 352 is "this is taken from 352"

Suppose that the A1 cell in sheet 353 is "this is taken from 353"

Suppose that the A1 cell in sheet 354 is "this is taken from 354"

Now I would like to be able to link back to the various A1 cells, so I'm asking about a link from one sheet (e.g., the one labeled 352) to another, namely the sheet labeled Sheet1.

I know how to normally do this: in Sheet1 enter the formula ='352'!$A$1

However, I want entries in Sheet1 to be used as reference names instead of explicitly using 352. So, for example, if the entry of A1 in Sheet1 is 352, then I want the formula I am looking for to give me the same exact value as what ='352'!$A$1 would give.

To elaborate a bit, A1 in Sheet1 would be 352 A2 in Sheet1 would be 353 A3 in Sheet1 would be 354.

What I want intuitively is basically ='[Sheet1!$B$1]352'!$A$1 but I still have that pesky 352 there but I don't want 352 there, I want a dynamic reference to A1 in Sheet1 (which just so happens to be 352 at the moment).

解决方案

=INDIRECT(A2&"!A1") and if A2 is the previous or other sheet name OR number, it should work. Note: in a copy/paste of this formula, the quote marks (") may become dual apostrophe marks (') - this won't work. If the sheet is then cloned, simply change A2 to be the now previous sheet name. No need to edit the formula itself. I have two workbooks now using this formula. One already had a cell with the previous sheet name used for calculations on that sheet. The sheets can be actual names (Jan, Feb, etc.) or numbers (352, 353, etc.).

这篇关于excel链接到同一工作簿中的另一个工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！