如何将Excel中的单元格的值引用到公式中 [英] How to refer the value of a cell in excel into a formula

问题描述

我想在引用公式中使用单元格的值。

I want to use the value of a cell in a reference formula.

例如：

我有一张名称为'815108'的表格，其中包含我需要的所有数据。

I have a sheet with name '815108' which has all the data I need.

现在在sheet1（新页）中，在A1中键入='815108' ！A3，从表格'815108'中的A3获取数据。

Now in the sheet1(new sheet), in A1 I type in ='815108'!A3 which gets the data from A3 in the sheet '815108'.

但是我有这个问题 -

But the question I have -

在我的新表格815108是一个定义的属性（例如：SO = 815108在单元格F5中定义）
而不是使用'815108'！A3我想使用当前工作表中的位置。我试过='= F5'！A3不起作用。任何帮助不胜感激。

In my new sheet 815108 is a defined attribute (For example: SO = 815108 is defined in cell F5.) Instead of using '815108'!A3 I want to use the location in the current sheet. I tried ='=F5'!A3 which doesn't work. Any help is appreciated.

谢谢。

推荐答案

以下是 INDIRECT 应该使用：

=INDIRECT("'" & F5 & "'!A3")

INDIRECT是一个volatile函数，将一个字符串转换为可行的参考。

INDIRECT is a volatile function that translates a string into a viable reference.

由于易失性，每当Excel重新计算时，它将重新计算，无论其引用的数据是否已更改。

Being volatile it will re-calculate every time Excel re-calculates regardless if the data to which it refers has changed or not.

这篇关于如何将Excel中的单元格的值引用到公式中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！