MATCH (PQL - xl)

This function returns the relative position of a specified item in a range

  • 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

MATCH(lookup value, lookup array, OPTIONAL match type)

Function Arguments

Name

Description

Type

Optional

lookup value

Value to search for

StringOrNumber

lookup array

Range to search in

CellRange

match type

Value to return if the formula returns an error. Can be 0 (first value that is equal to value), 1 (largest value that is less than or equal to value), or -1 (smallest value that is greater than or equal to value)

Number

Y

Comments

This function is the same as the Microsoft Excel 'MATCH' function - using the same inputs, logic and outputs.