Comparisons of Microsoft Excel functions to those available in Anaplan.
| Excel function | Excel description | Anaplan solution |
| HLOOKUP | Performs 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. |
| HOUR | Returns 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. |
| HYPERLINK | Creates a shortcut to a file or Internet address. | Use the MAKELINK function to create a clickable URL. |
