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