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.
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.
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.
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
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.
Read the remaining 62 paragraphs
Source : How to Cross Reference Cells Between Microsoft Excel Spreadsheets
