Use Excel's lookup and reference functions in your Anaplan XL reports.

FunctionDescription
ADDRESSGiven specified row and column numbers, creates a cell address as text.
AREASReturns the number of areas based on a reference.
CHOOSEReturns an item from a list of values.
COLUMNReturns the column number(s) based on a given reference.
COLUMNSReturns the number of columns based on an array or reference.
HLOOKUPSearches for a specified value in an array or a table's top row.
HYPERLINKCreates a shortcut to jump to a document stored on a network server.
INDEXReturns the value of an element selected by the row number and column letter indexes.
INDIRECTReturns the contents of a cell using its reference.
LOOKUPLooks 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.
MATCHReturns the relative position of an item in an array that matches a specified value in a specified order, or the position of an item.
OFFSETReturns a reference to a range that is a specific number of rows and columns from a cell or range of cells.
ROWReturns the row number based on a reference.
ROWSReturns the number of rows in a reference or array.
TRANSPOSEReturns a horizontal range of cells as vertical or vice versa.
VLOOKUPSearches 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.