Use cell references in a formula - Microsoft Support
When you create a simple formula or a formula by that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments. For example, when you enter or select the cell reference A2 , the formula uses the value of that cell to calculate the result.
Switch between relative, absolute, and mixed references
Press F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. Use absolute or relative cell references in formulas, or a mix of both.
Create or change a cell reference - Microsoft Support
In one or several formulas, you can use a cell reference to refer to: Data from one or more contiguous cells on the worksheet. Data contained in different areas of a worksheet. Data on other worksheets in the same workbook. For example: This formula: Refers to: And Returns: =C2.
CELL function - Microsoft Support
The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula: =IF(CELL("type",A1)="v",A1*2,0)
Overview of formulas in Excel - Microsoft Support
A reference identifies a cell or a range of cells on a worksheet, and tells Excel where to look for the values or data you want to use in a formula. You can use references to use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas.
Using structured references with Excel tables - Microsoft Support
Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.
Lookup and reference functions (reference) - Microsoft Support
Excel functions (alphabetical) 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.
Switch between relative and absolute references
Change a cell reference from relative (default) to absolute to maintain the original cell reference when you copy it. Maintain cell reference by putting a dollar sign ($) before the cell and column references.
INDIRECT function - Microsoft Support
How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.
Video: Understand and use cell references - Microsoft Support
Watch this video to learn the basics. When you use cell references in a formula, Excel calculates the answer using the numbers in the referenced cells. When you change the value in a cell, the formula calculates the new result automatically. Create a cell reference on the same worksheet.