ADDRESS function


Creates a cell reference as text, given specified row and column numbers.



=ADDRESS( row_numcol_num[abs_num][a10][sheet] )


required arguments:

row_num The row number to use in the cell address.
col_num The column number to use in the cell address.


optional arguments:

[abs_num] The address type.
[a10] The reference style.
[sheet] The name of the worksheet to use.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.