XLOOKUP (PQL - xl)

This function performs lookups in vertical and horizontal cell ranges and provides support for approximate matching, partial matching (using wildcard characters like * , ? etc.) and exact matching. By default, the XLOOKUP function returns the exact matched results

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

Syntax

XLOOKUP(lookup value, lookup array, return array, OPTIONAL if not found, OPTIONAL match mode, OPTIONAL search mode, OPTIONAL not found)

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

return array

Refers to the array or cell range that you want to return

StringOrNumber

if not found

Refers to the value to be returned when no match is found

StringOrNumber

Y

match mode

Specifies the type of the match

Number

Y

search mode

Specifies the mode of the search

Number

Y

not found

This argument can be used to override the #N/A error. Typical values for not found might be "Not found", "No match", "No result", etc

String

Y

Comments

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