在 Excel 中引用 [英] Referencing in Excel

问题描述

我想在我当前工作表的另一个工作表中引用这个单元格，计算公式为

I want to reference this cell in another worksheet for my current worksheet, which is calculated by

=[2015_RunRate.xlsx]一月！$C$66

但是，我想用当前工作表中单元格 C19 中的值替换该引用中的一月"一词.

However, I want to replace the word "January" in that reference with the value from cell C19 in my current worksheet.

我尝试了以下内容:

=([2015_RunRate.xlsx])([Current_Worksheet.xlsx]!$C$19)!$C$66

这显然行不通.有什么想法吗?

That clearly didn't work. Any ideas?

谢谢.

推荐答案

您可以使用 INDIRECT 函数 将您拼接在一起的字符串转换为有效的单元格引用.

You can use the INDIRECT function to convert a string you've stitched together into a valid cell reference.

=INDIRECT("[2015_RunRate.xlsx]"&$C$19&"!C66")

INDIRECT 函数无法引用已关闭的工作簿.它也被认为是一个 volatile¹ 函数.由于 C66 现在只是看起来像单元格引用的文本，因此无需添加绝对行和列指示符(例如 $).移动或复制到其他位置时，文本不会改变.

The INDIRECT function cannot reference a closed workbook. It is also considered a volatile¹ function. Since C66 is now nothing but text that looks like a cell reference, there is no need to add the absolute row and column indicators (e.g. $). The text will not change when moved or copied to another location.

¹ _{Volatile 函数会在整个工作簿中的任何内容发生变化时重新计算，而不仅仅是当影响其结果的某些内容发生变化时.volatile 函数的示例是 间接，偏移，今天, 现在，兰德和RANDBETWEEN.CELL 和 INFO 工作表函数也会使它们变得不稳定.}

¹ _{Volatile functions recalculate whenever anything in the entire workbook changes, not just when something that affects their outcome changes. Examples of volatile functions are INDIRECT, OFFSET, TODAY, NOW, RAND and RANDBETWEEN. Some sub-functions of the CELL and INFO worksheet functions will make them volatile as well.}

这篇关于在 Excel 中引用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！