Lookup and reference functions

The following table lists lookup and reference functions.

Note: Certain functions, such as LOOKUP and ROWS, may accept two dimensional arrays as arguments. TM1 Web does not support two dimensional arrays. Depending on the data organization and requirements, these functions can still obtain correct values, for example, when the data being retrieved falls in the initial portions of the array. To ensure correct values when working with these functions on TM1 Web you may need to reorganize the input data into repeated functions using one dimensional arrays or you may need to use direct cell references.

Function	Description
ADDRESS	Returns a reference as text to a single cell in a worksheet.
CHOOSE	Chooses a value from a list of values.
COLUMN	Returns the column number of a reference.
COLUMNS	Returns the number of columns in a reference.
HLOOKUP	Looks in the top row of an array and returns the value of the indicated cell.
HYPERLINK	Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
INDEX	Uses an index to choose a value from a reference or array.
LOOKUP	Looks up values in a vector or array.
MATCH	Looks up values in a reference or array.
OFFSET	Returns a reference offset from a given reference.
ROW	Returns the row number of a reference.
ROWS	Returns the number of rows in a reference.
VLOOKUP	Looks in the first column of an array and moves across the row to return the value of a cell.