如何返回有地址的单元格的内容(例如“A2”)?

I have cell addresses in one worksheet formatted as text strings (e.g. "A1", "B22", "F332") and I'd like to return the contents of those particular cell addresses from another worksheet. How do I do this?

我在一个格式化为文本字符串的工作表中有单元格地址。“A1”、“B22”、“F332”)我想从另一个工作表中返回这些特定单元地址的内容。我该怎么做呢?

1 个解决方案

#1

Use INDIRECT():

使用间接():

=INDIRECT("Sheet3!" & A1)

This gets the contents of cell A1 from Sheet3.

这将从Sheet3获取单元A1的内容。

If your sheetname includes blanks, encapsulate it in single quotes.

如果您的sheetname包含空格，请将其封装在单引号中。