LOOKUP (PQL - xl)
This function searches for a value and returns a value from the same location in a second area
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
LOOKUP(lookup value, lookup vector, result vector)
Function Arguments
Name | Description | Type | Optional |
lookup value | Value for which to search; can be number, text, logical value, or name or reference that refers to a value | StringOrNumber |
|
lookup vector | Cell range that contains one row or one column; can be text, numbers, or a logical value; values need to be in ascending order | StringOrNumber |
|
result vector | Cell range that contains one row or column; must be the same size as lookup vector | CellRange |
|
Comments
This function is the same as the Microsoft Excel 'LOOKUP' function - using the same inputs, logic and outputs.