Selects a specific item from one or more of the hierarchy lists, then looks up a value based on matching that selection.
Syntax
Result Module.Result Item[LOOKUP: CommonValue, SELECT: SourceModuleWithCommonValueAndResultValue]
where:
- LOOKUP: Line item to use as reference when looking for value
- SELECT: Value to look up
Format: Arguments: Constraints
See LOOKUP
See SELECT
Excel equivalent
- No Excel equivalent
Example
The formula below selects Scenario1 from the Packaging module, then looks up the Packaging Cost according to Pack Size.
Packaging.Packaging Cost[LOOKUP: Pack Size, SELECT: Scenarios.'Scenario 1']
Description:
Here is an example of where a results module uses SELECT & LOOKUP to return the packaging cost from a Packaging source module for a specific pack size and scenario: This illustrates how LOOKUP and SELECT can be used in the same formula. The formula above selects Scenario 1 from the Packaging module, then looks up the Packaging Cost according to Pack Size. The result module Pack Size line item is list-formatted and shares a dimension with the result.
When we go to the Packaging source module, we see that the Packaging Cost for a Small package under Scenario 1 has been correctly mapped:
