ADDRESS(...)
How to use MS Excel's ADDRESS() function to set cell addresses
Used Functions
Category: Lookup and reference
Returns a reference as text to a single cell in a worksheet
Syntax
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Practice ADDRESS Formula at Sheetzoom
ADDRESS formula at Microsoft help
0
The formula takes five argument, first one is row number, second one is column number. The result can be modified by seeting the values for the three remaining optional argument that is type of relative reference, referencing stylpe i.e. A1 or R1C1 and the name of the file before cell. Taking all these values, the final result is displayed.