If you want to maintain the original cell reference in this example when you copy it, you make the cell reference absolute by preceding the columns (B and C) and row (2) with a dollar sign ($).

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.

Select the range of cells that contains formulas in which you want to replace cell references with defined names. Select a single, empty cell to change the references to names in all formulas on the worksheet.

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:

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 enter a formula that …

Note: Using $ symbols tells Excel that the reference to C2 is "absolute," which means that when you copy the formula to another cell, the reference will always be to cell C2.

Instead of entering values, you can refer to data in worksheet cells by including cell references in formulas.

Absolute references An absolute cell reference in a formula, such as $A$1, always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference …

For example, if your lookup value is in cell C2 then your range should start with C. The column number in the range that contains the return value. For example, if you specify B2:D11 as the range, you …

Absolute references An absolute cell reference in a formula, such as $A$1, always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference …