< All Topics

LOOKUP function

As you’ll see in the pages on arrays,  you can tell Openbox to repeat calculations by things like scenarios, locations or business units.

Sometimes, you will want to pick out a single one of these repeated calculations. LOOKUP (and its sister function SELECT) let you do this. The syntax is:

LOOKUP(<line item>, <value to lookup>, <array to look up>)

The <array to lookup> is only needed if the line item varies by more than one array.


Suppose you have a model with ‘Sales’ as an input, and this varies by location – so you might have sales in Europe, sales in USA and so on.

Suppose also that you have ‘Revenue’ calculated as ‘Sales’ * ‘Price’. Since ‘sales’ varies by location, ‘Revenue’ will as well. If you just want to look at revenue in Europe, you can use the LOOKUP function like this ‘LOOKUP([Revenue],’Europe’).


Leave a Reply