根据命名的单元格名称从另一个工作表中输入单元格

分类: 技术问答 • 2022-07-19 22:44:07

问题描述：

它们是基于当前工作表中单元格名称从另一工作表中导入单元格的简单方法吗?

Is they a simple way to import a cell from another sheet based on the name of a cell in the current sheet?

下面，我想说如果A2等于命名表Sheet2，然后从Sheet2导入J10

Below, I trying to say if A2 equals named sheet say Sheet2 then import J10 from Sheet2

=IMPORTRANGE(""=A2"","J10")

谢谢

答

使用= indirect('"& A2&'！J10")

Using =indirect("'"&A2&"'!J10")