Function | Description |
---|---|
ADDRESS | Returns a reference to a table cell as text |
AREAS | Returns the number of ranges within a reference |
CHOOSE | Selects a value from a value list |
COLUMN | Returns the column number of a reference |
COLUMNS | Returns the number of columns associated with a reference |
GETPIVOTDATA | Returns data from a PivotTable report |
HLOOKUP | Searches in the first row of an array and returns the value in the indicated cell |
HYPERLINK | Creates a connection to open a document saved on a network server or on an intranet or the Internet |
INDEX | Uses an index to select a value from a reference or an array |
INDIRECT | Returns a reference indicated by a text value |
LOOKUP | Searches for values within a vector or array (matrix) |
MATCH | Searches for values within a reference or array (matrix) |
OFFSET | Returns a reference offset from the specified reference |
ROW | Returns the row number of a reference |
ROWS | Returns the number of rows associated with a reference |
RTD | Retrieves real-time data from a program supporting COM automation |
TRANSPOSE | Returns the transposed array of the indicated array (matrix) |
VLOOKUP | Searches in the first column of an array and returns a cell value from the column you specify per the index |