| Lookup & Reference Functions |
Description |
|---|---|
| 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 a Number Rounded away from Zero to the Nearest Multiple of significance |
| COLUMNS | Rounds a number down toward zero to the nearest multiple of significance |
| ROW | Rounds a number down to the nearest integer |
| ROWS | Rounds a decimal number away from zero to the nearest even integer |
| ODD | Rounds a decimal number away from zero to the nearest odd integer |
| OFFSET | Rounds a number to a specified number of digits |
| TRANSPOSE | Always rounds a number down |
| 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 | Least Common Multiple (Returns the least common multiple of integers) |
| MATCH | Returns the result of a number raised to a power |