Comparisons of Microsoft Excel functions to those available in Anaplan.

Use the links below to navigate to pages containing other Microsoft Excel functions.


Excel functionExcel descriptionAnaplan solution
HLOOKUPPerforms a horizontal lookup, by searching for a value in the table's top row. If found, the value is returned to the same column based on the index_number.Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item.
HOURReturns the hours (a number from 0 to 23) from a time value.There's no equivalent Anaplan function, but can be built using a calculation.
HYPERLINKCreates a shortcut to a file or Internet address.Use the MAKELINK function to create a clickable URL.