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. |
See also: