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.
Indirect	It returns the link specified as a text string.
Match	It searches for the specified element in the cell range and returns relative position of this element in the range.
Offset	It returns links to the cell range that is offset by the specified number of rows and columns from the specified 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.