Excel - Microsoft Excel Address Function

Description

The Excel Address function takes row and column numbers and returns a cell reference as a text string. 

The syntax of the function is: 

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

Where the arguments are as follows: 

Address Function Examples

The following spreadsheets show simple examples of the Excel Address function. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right. 

Note that the function in cell A4 of the above spreadsheet omits the [a1] argument. This argument therefore takes the default value of TRUE. 

Note also, that cell A5 in the above spreadsheet combines the ADDRESS function with the ROW function and the COLUMN function to display the reference to the current cell. 

Address Function Error

If you get an error from the Excel Address function, this is likely to be the #VALUE! error : 

Common Error