INDIRECT (PQL - xl)

This function returns the reference specified by a text string

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

Syntax

INDIRECT(ref text, OPTIONAL a1)

Function Arguments

Name

Description

Type

Optional

ref text

A reference to a cell that contains an A1 reference, an R1C1 reference, a name defined as a reference, or a text string reference to a cell. This argument is required

String

a1

A logical value that specifies what type of reference is contained in the cell Reftext. This argument is optional

StringOrNumber

Y

Comments

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