Address

 

The ADDRESS function in Excel creates a cell reference as text, based on a given row and column number.

1. The ADDRESS function below returns $E$8. The row number is 8 and the column number is 5.

ADDRESS function in Excel

2. The ADDRESS function below returns $G$3. The row number is 3 and the column number is 7.

Absolute Reference

3. By default, the ADDRESS function creates an absolute reference. To create a relative reference, use 4 for the third argument.

Relative Reference

4. For example, use the ADDRESS function in Excel to find the cell address of the maximum value in a column.

Cell Address of Maximum Value

Note: visit our page about locating the maximum value in a column for detailed instructions on how to create this formula.