XMATCH (PQL - xl)

This function searches for a specific item in an array or a range of cells and then returns the relative position of the item. In other words, this function can be used to find the position of an item in a list

  • Library: PQL \ Spreadsheet \ Lookup
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

XMATCH(lookup value, lookup array, OPTIONAL match mode, OPTIONAL search mode)

Function Arguments

Name

Description

Type

Optional

lookup value

Refers to the lookup value

Number

lookup array

Refers to the lookup array or cell range that you want to search

StringOrNumber

match mode

Specifies the type of the match

Number

Y

search mode

Specifies the mode of the search

Number

Y

Comments

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