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.
ADDRESS function - Microsoft Support
Description. You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS (2,3) returns $C$2. As another example, ADDRESS (77,300) returns $KN$77.
Switch between relative and absolute references - Microsoft …
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.
Copy and paste a formula to another cell or worksheet in Excel …
Select the cell with the formula. Select the reference you want to change in the formula bar: Press F4 to switch between the absolute and relative reference combinations, and pick the one you want. Move a formula to another location.
Using structured references with Excel tables - Microsoft Support
Structured reference: (DeptSales [ [#Totals], [Sales Amount]] and DeptSales [ [#Data], [Commission Amount]] are structured references, represented by a string that begins with the table name and ends with the column specifier. To create or edit structured references manually, use these syntax rules:
Use the table_array argument in a lookup function
The cell range listed in the table_array argument can use relative or absolute cell references. If you're going to copy your function, you need to use absolute references, like this: =VLOOKUP(F2,$B$2:BD$39, ...
Copy a formula by dragging the fill handle in Excel for Mac
Follow these steps: Select the cell that has the formula you want to fill into adjacent cells. Rest your cursor in the lower-right corner so that it turns into a plus sign (+), like this: Drag the fill handle down, up, or across the cells that you want to fill.
VLOOKUP function - Microsoft Support
Use absolute references for range_lookup. Using absolute references allows you to fill-down a formula so that it always looks at the same exact lookup range. Learn how to use absolute cell references. Don't store number or date values as text.
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.
Keyboard shortcuts in Excel - Microsoft Support
When a cell reference or range is selected in a formula, F4 cycles through all the various combinations of absolute and relative references. Ctrl+F4: closes the selected workbook window. Alt+F4: closes Excel.
DAVERAGE function - Microsoft Support
The formula that you use for criteria must use a relative reference to refer to the corresponding cell in the first row (in the examples below, C7 and A7). All other references in the formula must be absolute references.