To obtain the address of a worksheet in Excel. ADDRESS function is used. You must give the specific row and column number to locate the cell. If we define it in a general sense, the ADDRESS function is handy when there is no way out to refer to a particular cell address.
The only purpose of this Excel function is to provide the address of any cell in the worksheet. The address of the cell is then shown as a text string.
The syntax of the ADDRESS function is as below.
=ADDRESS (row_num, column_num, [abs_num], [a1], [sheet-text])
The following arguments are acceptable by the ADDRESS function.
The above-mentioned arguments are a compulsory part of the ADDRESS function. The last three arguments abs, a1, and sheet text are optional arguments.
Consider the following example to show how the formula of the ADDRESS function is written.
Suppose that the row is 11, the column is 13, abs_num=3, a1 is 1, and the sheet name is ABC sheet.
The formula will be written as follows.
“= ADDRESS (11, 13, 3, 1, “ABC sheet”)”.