INDIRECT (PQL - xl)
This function returns the reference specified by a text string
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
INDIRECT(ref text, OPTIONAL a1)
Function Arguments
Name | Description | Type | Optional |
ref text | A reference to a cell that contains an A1 reference, an R1C1 reference, a name defined as a reference, or a text string reference to a cell. This argument is required | String |
|
a1 | A logical value that specifies what type of reference is contained in the cell Reftext. This argument is optional | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'INDIRECT' function - using the same inputs, logic and outputs.