VLOOKUP (PQL - xl)
This function searches for a value in the leftmost column and returns a value in the same row from a column you specify
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
- Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions
Syntax
VLOOKUP(lookup value, table array, col index num, OPTIONAL range lookup)
Function Arguments
Name | Description | Type | Optional |
lookup value | Value for which to search | StringOrNumber |
|
table array | Array or cell range that contains the data to search | StringOrNumber |
|
col index num | Column number in the array from which the matching value is returned | Number |
|
range lookup | Logical value indicating whether to find an approximate match; if omitted, uses TRUE and finds an approximate match | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'VLOOKUP' function - using the same inputs, logic and outputs.