Use Excel's lookup and reference functions in your Anaplan XL reports.
| Function | Description |
| 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. |
