To work with the tool in Foresight Analytics Platform 10, use the new interface.

References and Arrays

The list of predefined functions used to work with references and arrays is shown in the table below:

Function	Brief description
HLookUp	It searches for value in the first table row and returns value of the cell located in the same column in the specified row.
Match	It searches for the specified element in cell range and returns relative position of this element in the range.
Offset	It returns links to a cell range that is given number of rows and columns from a given link.
Range	It returns cell range by a reference.
Rng	It returns a range based on a reference to a cell.
VLookUp	It searches for values in the leftmost table column and returns value of the cell located in the same column in the specified row.