CHOOSE (PQL - xl)
This function returns a value from a list of values
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
CHOOSE(index num, value1, value2)
Function Arguments
Name | Description | Type | Optional |
index num | Index of the specified values to return; an integer value between 1 and 255 | Number |
|
value1 | Values from which to choose; can be numbers, cell references, cell ranges, defined names, formulas, functions, or text | StringOrNumber |
|
value2 | Values from which to choose; can be numbers, cell references, cell ranges, defined names, formulas, functions, or text | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'CHOOSE' function - using the same inputs, logic and outputs.