INDEX (PQL - xl)

This function returns a value or the reference to a value from within an array or range

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

Syntax

INDEX(array, row num, column num, OPTIONAL area num)

Function Arguments

Name

Description

Type

Optional

array

Returns a value or a reference of a cell or range of cells

Number

row num

Row number in the range

Number

column num

Column number in the range

Number

area num

(If return is a cell range reference) Area of the range

Number

Y

Comments

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