1. Calculation functions
  2. All Functions
  3. Compound Functions
  4. SELECT and LOOKUP

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

Back to Top

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:

Back to Top

Similar functions