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.