1. Calculation functions
  2. Functions
  3. Excel comparison
  4. Excel comparison: H functions

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.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.