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.