公式中的Excel工作表参考 [英] Excel Worksheet reference in formula

问题描述

我目前正在工作的工作簿上有52个工作表，一年中的一周中有1个工作表.我正在尝试制作一个可以快速检查每个工作表的工作表.我想知道是否只有一种工作表可以从其他工作表中提取数据?还是我必须每个星期单独创建一个?

I'm currently working on a workbook which has a 52 worksheets, 1 for week of the year. I'm trying to make a worksheet that i can use as a quick-check for each of the worksheets. I'm wondering if there's a way of having just 1 worksheet pull data in from each of the other sheets ? or do i have to create one for every week individually ?

例如，

而不是单个表的加载量为'= VLOOKUP(B3，'WEEK 12'！$ A $ 4:$ E $ 40,3，FALSE)' 我可以使用公式c1单元格中的任何工作表名称使用公式吗?如'= VLOOKUP(B3，'单元格C1 '！$ A $ 4:$ E $ 40,3，FALSE)'

instead of individual sheets with a load of '=VLOOKUP(B3,'WEEK 12'!$A$4:$E$40,3,FALSE)' is there any i can have the formula use whichever worksheet name i have in say cell c1 ? like '=VLOOKUP(B3,'Cell C1'!$A$4:$E$40,3,FALSE)'

对不起，请稍等，希望您理解我的意思.

Sorry for being a bit long winded, and hope you understand what i mean.

推荐答案

由于您现在使用A和E列的文本表示形式，因此绝对不需要$标记.

As you are now using a text representation of columns A and E, there is absolutely no need for the $ markers.

=vlookup(b3, indirect(text(c1, "'@'!\A\:\E")), 3, false)

或者，在C1中只有 12 .

=vlookup(b3, indirect(text(c1, "'w\e\ek 0'!\A\:\E")), 3, false)

这篇关于公式中的Excel工作表参考的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！