ADDRESS in Excel

 

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. The ADDRESS function returns a text value. Use the INDIRECT function in Excel to convert this text value into a valid cell reference.

INDIRECT and ADDRESS

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

Relative Reference

5. 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.

6. Simply use the INDEX function in Excel to return a specific value in a two-dimensional range.

INDEX function

Explanation: 92 found at the intersection of row 3 and column 2 in the range E4:F7. Use INDEX and MACTH in Excel to perform advanced lookups.