Excel address function

Version in which ADDRESS function can work:

Excel ADDRESS function will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets .

About excel ADDRESS function:

The Excel ADDRESS function returns a text  of cell address based on the given row and column number.

Syntax for excel ADDRESS Function:

=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Parameters:

row_num: The row number to use in the reference.

column_num: The column number to use in the reference.

abs_num: Optional argument which specifies absolute or relative reference. (Default absolute reference.)

[a1] :An optional logical argument that defines the reference style (A1 style or R1C1 style).

[sheet_text] : An optional text argument that specifies the sheet name.

Using ADDRESS function:

Finally, with different arguments combination to use address function is given with the example.

Formula Result Comment
 =ADDRESS(1,1) $A$1 This will show of first row first column
 =ADDRESS(1,1,1) $A$1 This will show first row first column with absolute reference.
 =ADDRESS(1,1,2) A$1 This will show first row first column with absolute row/relative column reference.
 =ADDRESS(1,1,3) $A1 This will show first row first column with relative row/absolute column reference.
 =ADDRESS(1,1,4) A1 This will show first row first column with relative reference.
 =ADDRESS(1,1,1,0) R1C1 This will show first row first column with absolute reference and R1C1 format.
 =ADDRESS(1,1,1,1) $A$1 This will show first row first column with absolute reference and A1 format.
 =ADDRESS(1,1,1,1, “Sheet1”) Sheet1!$A$1 This will show first row first column with absolute reference and A1 format with sheet name.

excel address function

Leave a Comment