Explain the purpose of LOOKUP in Anaplan formulas.

• A. LOOKUP concatenates strings across modules.
• B. LOOKUP retrieves related data from a reference list or module using a key to align rows for accurate cross-dimensional data.
• C. LOOKUP creates time-based aggregations.
• D. LOOKUP defines user permissions.

Answer: (B)

LOOKUP is used to bring in a value from a related module or list by using the shared dimensions as the key. In Anaplan, data is organized by dimensions, and often you need a value that lives in a different structure but should correspond to the same combination of dimensions. LOOKUP looks at the current row’s intersection of dimensions and fetches the value from the target line item that has the same key, enabling accurate cross-dimensional data retrieval. For example, you might pull a Price or Cost that’s defined in a Pricing module (keyed by Time and Product) into a Sales module (also keyed by Time and Product) so each time-product combination gets the correct price. This function is about cross-referencing and aligning data, not string concatenation, time-aggregation, or permissions.