Lookup & Reference Function Names |
Descriptions for Lookup & Reference Functions (Formulas) |
---|---|
ADDRESS | Returns the address of a cell in a worksheet, given specified row and column numbers. |
AREAS | Returns the number of areas in a reference. The reference can include a single cell, a range of contiguous cells, or a range of non-contiguous cells. |
CHOOSE | Determines which value from a list of values is to be retrieved based on its position in the list |
Column and Row Functions | |
COLUMN | Returns the column number of a reference |
COLUMNS | Returns the number of columns in an array or reference |
ROW | Returns the row number of a reference |
ROWS | Returns the number of rows in a reference or array |
OFFSET | The OFFSET function returns a value that is a specified number of rows and columns from a reference cell. |
TRANSPOSE | Converts a Vertical Range to a Horizontal Range, and Vice Versa |
Search Functions | |
INDEX | Used to retrieve the value from a single row or the value from any two-dimensional range. It doesn't use a lookup value it just retrieves the value from the specified location. |
LOOKUP | Searches a single row or column for a value and then returns a value from the same position in another single row or column range. |
HLOOKUP | Horizontal Lookup. Uses a lookup value to search the top row of a table or array for a matching value then returns the value from the same column as the row you specify. |
VLOOKUP | Vertical Lookup. Searches a single row or column for a value and then returns a value from the same position in another single row or column range |
MATCH | Searches for a specified value in a range and then returns the relative position of that item in the range. The range must be values within a single row or column. |