| ADDRESS |
Given specified row and column numbers, creates a cell address as text. |
| AREAS |
Returns the number of areas based on a reference. |
| CHOOSE |
Returns an item from a list of values.. |
| COLUMN |
Returns the column number(s) based on a given reference. |
| COLUMNS |
Returns the number of columns based on an array or reference. |
| HLOOKUP |
Searches for a specified value in an array or a table’s top row. |
| HYPERLINK |
Creates a shortcut to jump to a document stored on a network server. |
| INDEX |
Returns the value of an element selected by the row number and column letter indexes. |
| INDIRECT |
Returns the contents of a cell using its reference. |
| LOOKUP |
Looks in the first row or column of a range or array, and returns the specified value from the same position in the last row or column of the range or array. |
| MATCH |
Returns the relative position of an item in an array that matches a specified value in a specified order, or the position of an item. |
| OFFSET |
Returns a reference to a range that is a specific number of rows and columns from a cell or range of cells. |
| ROW |
Returns the row number based on a reference. |
| ROWS |
Returns the number of rows in a reference or array. |
| TRANSPOSE |
Returns a horizontal range of cells as vertical or vice versa. |
| VLOOKUP |
Searches for a value in the leftmost column of a table and returns a value from the same row in a column number that you specify. |