ADDRESS (PQL - xl)
This function uses the row and column numbers to create a cell address in text
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
ADDRESS(row num, column num, OPTIONAL abs num, OPTIONAL a1, OPTIONAL sheet text)
Function Arguments
Name | Description | Type | Optional |
row num | Row number in the cell reference | Number |
|
column num | Column number in the cell reference | Number |
|
abs num | Type of reference to return | Number | Y |
a1 | Logical value that indicates whether the reference style is A1; if TRUE or omitted, the style is A1; if FALSE, then the style is R1C1 | StringOrNumber | Y |
sheet text | Name of the sheet to use as an external reference; if omitted, no sheet name is used | String | Y |
Comments
This function is the same as the Microsoft Excel 'ADDRESS' function - using the same inputs, logic and outputs.