| 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. |