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