Switch between relative, absolute, and mixed references
By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually …
Switch between relative and absolute references
By default, a cell reference is relative. For example, when you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A), and in the same row …
Switch between relative, absolute, and mixed references
By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually …
Using structured references with Excel tables - Microsoft Support
To include structured references in your formula, select the table cells you want to reference instead of typing their cell reference in the formula. Let's use the following example data to …
Switch between relative, absolute, and mixed references
By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually …
Lookup and reference functions (reference) - Microsoft Support
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
ADDRESS function - Microsoft Support
A text value that specifies the name of the worksheet to be used as the external reference. For example, the formula =ADDRESS (1,1,,,"Sheet2") returns Sheet2!$A$1.
Create a 3-D reference to the same cell range on multiple …
A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you …
Use cell references in a formula - Microsoft Support
Do one of the following, select the cell that contains the value you want or type its cell reference. You can refer to a single cell, a range of cells, a location in another worksheet, or a location in …
OFFSET function - Microsoft Support
Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells.