Selects a specific item from one or more of the hierarchy lists, then looks up a value based on matching that selection.
Result Module.Result Item[LOOKUP: CommonValue, SELECT: SourceModuleWithCommonValueAndResultValue]
- LOOKUP: Line item to use as reference when looking for value
- SELECT: Value to look up
Format: Arguments: Constraints
- No Excel equivalent
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']
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: