Syntax
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])Arguments
| Argument | Required | Description |
|---|---|---|
row_num | Required | The row number |
column_num | Required | The column number |
abs_num | Optional | 1 absolute (default), 2 absolute row, 3 absolute column, 4 relative |
a1 | Optional | TRUE (default) for A1 style, FALSE for R1C1 style |
sheet_text | Optional | A sheet name to put in front (optional) |
How to use ADDRESS
ADDRESS takes 2 required arguments and 3 optional arguments. Type =ADDRESS( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=ADDRESS(2, 3)Result =ADDRESS(2, 3, 2)Result =ADDRESS(2, 3, 1, FALSE, "My Sheet")Result Related lookup and reference functions
- AREASReturns the number of areas (separate ranges) in a reference.
- CHOOSEReturns the value in a list at the given position.
- COLUMNReturns the column number of a reference, or of the cell with the formula when left out.
- COLUMNSReturns the number of columns in a range or array.
- FORMULATEXTReturns the formula in a cell as text.
- GETPIVOTDATAReturns data from a pivot table. Refer to the pivot table cells directly instead.
- HLOOKUPLooks for a value in the first row of a table and returns the value in the same column from another row.
- INDEXReturns the value or reference at a given row and column of a range or array.
- INDIRECTReturns the reference written in a text value, such as "B3" or "Sheet2!A1:A10".