Buzz
In the following article, Software Tips will introduce readers to the ADDRESS function, one of the commonly used reference and lookup functions in Excel.
Syntax and usage of the ADDRESS function
Syntax: =ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]).
Among them:
- row_number: The number of rows of the cell to get the address, a mandatory parameter.
- column_number: The number of columns of the cell to get the address, a mandatory parameter.
- abs_num: Specifies the type of reference to return, an optional parameter with the following values:
Option 1: Absolute addresses are a must.
Option 2: Absolute row; relative column.
Option 3: Relative row; absolute column.
Option 4: Relative address.
Specify the referencing style, A1 or R1C1, as an optional parameter. Possible values are:
+ TRUE or omitted: Columns are labeled alphabetically, rows numerically. For example, B2, C8…
+ FALSE: Both rows and columns are labeled numerically in R1C1 format. For example, R1C2.
Specify the name of the referenced worksheet as a text value, as an optional parameter. If Sheet argument is omitted, the formula will default to the current worksheet.
- Reference type A1 (row 1 and column A): absolute reference is indicated by the dollar sign $ before the column or row position.
Reference type R1C1 (row 1 and column 1): absolute reference is indicated by square brackets [] at the row or column number.
If you want to reference a different workbook and worksheet, you put the name of the workbook in square brackets. For example, '[Book2]Sheet3' means the workbook named Book2 and the worksheet in that workbook is Sheet3.
Hope this article will be helpful to readers. Wish you all success!
