使用单元格在Google表格的公式中引用表格名称 [英] Using A Cell To Reference The Name Of Sheet In A Formula For Google Sheets
问题描述
是否可以将第一个工作表的名称放在一个单元格中,然后在公式中使用它来引用第二个工作表的信息?
is it possible to place the name of the first worksheet in a cell and then use it in a formula to reference information for my second sheet?
我正在使用Google Spreadsheets,并且有一个工作表在一周的每一天中为列提供员工的调度数据.第二个工作表生成工资报告,并直接引用第一个工作表中的列,如下所示:
I am using Google Spreadsheets, and I have one worksheet that houses scheduling data for employees in columns for each day of the week. The second worksheet builds a payroll report, and directly references columns in the first sheet like so:
='Sales Report - WB 10.06'!B3
我的问题是,是否可以将第一个工作表的名称放在一个单元格中(销售报告-WB 10.06"),然后在公式中使用它来引用第二个工作表的信息?
My question is, is it possible to place the name of the first worksheet in a cell ('Sales Report - WB 10.06') and then use it in a formula to reference information for my second sheet?
我当前的问题是我必须每周为10个不同的区域创建一个新的时间表和新的工资表,并且复制和更改70列中的公式以引用正确的表将变得非常繁琐.
My current issue is that I have to create a new schedule and a new payroll sheet for 10 different regions on a weekly basis, and duplicating and changing the formulas in 70 columns to reference the correct sheet will become very tedious.
仅更新电子表格中的单元格,使公式指向正确的工作表以引用其数据会容易得多.
It would be much easier to just update a cell in the spreadsheet so that the formulas point to the correct worksheet to reference data from.
推荐答案
Yes, by using the INDIRECT function:
A1: Sales Report - WB 10.06
然后您可以使用:
=INDIRECT("'"&A1&"'!B3")
这篇关于使用单元格在Google表格的公式中引用表格名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!