Please enable JavaScript to view the comments powered by Disqus.


How to use MS Excel's ADDRESS() function to set cell addresses

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.

Used Functions

Category: Lookup and reference

Returns a reference as text to a single cell in a worksheet


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

Lets chat on this