HLOOKUP (PQL - xl)
This function searches for a value in the top row and then returns a value in the same column from a specified row
- 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
HLOOKUP(lookup value, table array, row index num, OPTIONAL range lookup)
Function Arguments
Name | Description | Type | Optional |
lookup value | Value to be found in the first row | StringOrNumber |
|
table array | Array or range that contains the data to search | StringOrNumber |
|
row index num | Row number in the array from which the matching value will be 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 'HLOOKUP' function - using the same inputs, logic and outputs.