如何在Microsoft Excel电子表格之间交叉引用单元格

In Microsoft Excel, it’s a common task to refer to cells on other worksheets or even in different Excel files. At first, this can seem a little daunting and confusing, but once you understand how it works, it’s not so hard.

在Microsoft Excel中，引用其他工作表上甚至不同Excel文件中的单元格是一项常见的任务。 刚开始时，这似乎有些令人生畏和令人困惑，但是一旦您了解了它的工作原理，就没那么难了。

In this article, we’ll look at how to reference another sheet in the same Excel file and how to reference a different Excel file. We’ll also cover things like how to reference a cell range in a function, how to make things simpler with defined names, and how to use VLOOKUP for dynamic references.

在本文中，我们将研究如何在同一Excel文件中引用另一个工作表，以及如何引用另一个Excel文件。 我们还将介绍诸如如何在函数中引用单元格范围，如何通过定义的名称使事情更简单以及如何将VLOOKUP用于动态引用等内容。

如何在同一Excel文件中引用另一个工作表 (How to Reference Another Sheet in the Same Excel File)

A basic cell reference is written as the column letter followed by the row number.

基本单元格引用被写为列字母，后跟行号。

So the cell reference B3 refers to the cell at the intersection of column B and row 3.

因此，单元格引用B3指的是B列与第3行的交点处的单元格。

When referring to cells on other sheets, this cell reference is preceded with the other sheet’s name. For example, below is a reference to cell B3 on a sheet name “January.”

当引用其他工作表上的单元格时，此单元格引用之前是另一工作表的名称。 例如，下面是对工作表名称“ January”上的单元格B3的引用。

=January!B3

The exclamation point (!) separates the sheet name from the cell address.

感叹号(！)将工作表名称与单元格地址分隔开。

If the sheet name contains spaces, then you must enclose the name with single quotation marks in the reference.

如果工作表名称包含空格，则必须在引用中用单引号将该名称引起来。

='January Sales'!B3

To create these references, you can type them directly into the cell. However, it is easier and more reliable to let Excel write the reference for you.

要创建这些引用，您可以将它们直接键入到单元格中。 但是，让Excel为您编写参考更加容易和可靠。

Type an equal sign (=) into a cell, click on the Sheet tab, and then click the cell that you want to cross-reference.

在单元格中键入一个等号(=)，单击“工作表”选项卡，然后单击要交叉引用的单元格。

As you do this, Excel writes the reference for you in the Formula Bar.

执行此操作时，Excel将在公式栏中为您编写参考。

Press Enter to complete the formula.

按Enter键完成公式。

如何引用另一个Excel文件 (How to Reference Another Excel File)

You can refer to cells of another workbook using the same method. Just be sure that you have the other Excel file open before you begin typing the formula.

您可以使用相同的方法引用另一个工作簿的单元格。 只需确保在开始键入公式之前已打开另一个Ex