Lookup Functions

These functions are used to locate references and specific values within tables of data

  • Family: PQL
  • Library: Spreadsheet
  • ◉ This function can be used with the Solve plug-in

    • Function List

    ADDRESS

    AREAS

    CHOOSE

    CHOOSECOLS

    CHOOSEROWS

    COLUMN

    COLUMNS

    DROP

    EXPEND

    FILTER

    FORMULATEXT

    HLOOKUP

    ◉

    HSTACK

    HYPERLINK

    INDEX

    INDIRECT

    LOOKUP

    MATCH

    ◉

    OFFSET

    ROW

    ROWS

    SORT

    SORTBY

    TOCOL

    TOROW

    TRANSPOSE

    UNIQUE

    VLOOKUP

    ◉

    VSTACK

    WRAPCOLS

    WRAPROWS

    XLOOKUP

    XMATCH