使用公式中现有单元格的值 [英] Using value from an existing cell inside a formula

问题描述

我正在使用excel 2010中的相机功能。

我的目标是拥有一个可以手动输入的日期的单元格，该公式将获得更新的值，该值代表另一个excel文件中的工作表名称，并向我显示更新的截图。

例如：
单元格 A1 有： 12.25

：
='C：\My_Excel_Files\ [excelDataFile.xlsx] 12.25'！$ A $ 1：$ D $ 20

所以如果我要将单元格 A1 的值更改为 12.26 公式将选择自动上传。我尝试使用这样的间接函数：
='C：\My_Excel_Files\ [excelDataFile.xlsx] INDIRECT（ A1）'！$ A $ 1：$ D $ 20

但没有起作用。

解决方案

如上所述在这个论坛和本网站，您可以使用免费的MOREFUNC.XLL加载项。它提供了INDIRECT.EXT函数，它将完全符合您的要求。你所需要的公式将符合以下条件：

= INDIRECT.EXT（'C：\My_Excel_Files\ [ excelDataFile.xlsx]&$ A $ 1：$ D $ 20）

A1，在字符串的中间。

注意：这些网站中的链接似乎并不总是有效，您可以通过MOREFUNC下载或者尝试其中一个链接：

http： //download.cnet.com/Morefunc/3000-2077_4-10423159.html

http://www.freewarefiles.com/Morefunc_program_14922.html

I am using the "Camera" feature in excel 2010.

My goal is to have a cell which would have a date that I can manually enter and just below it the formula would get the updated value which represents the name of the sheet inside another excel file and shows me the updated screenshot.

For example: Cell A1 has: 12.25

Just below it, I have: ='C:\My_Excel_Files\[excelDataFile.xlsx]12.25'!$A$1:$D$20

So if I were to change the value of Cell A1 to 12.26 the formula would pick that up automatically.

I tried using the indirect function like this: ='C:\My_Excel_Files\[excelDataFile.xlsx]INDIRECT(A1)'!$A$1:$D$20

but it didn't work.

解决方案

As mentioned on this forum and this website, you can use the free MOREFUNC.XLL add-in. It provides the INDIRECT.EXT function that will do exactly what you're requesting. The formula you need in your case would be along the lines of:

=INDIRECT.EXT("'C:\My_Excel_Files\[excelDataFile.xlsx]" & A1 & "'!$A$1:$D$20")

Where you concatinate the value of A1 in the middle of the string.

Note: the links in those sites seem to not always work, you can either google for "MOREFUNC download" or try one of these links:

http://download.cnet.com/Morefunc/3000-2077_4-10423159.html
http://www.freewarefiles.com/Morefunc_program_14922.html

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