How do I create a lookup table?
Lookup tables can be created for 1) Text Selector Columns 2) Custom Dimension Columns.
The steps to create a lookup table are listed below:
- Go to Modeling > Level Assigned Sheets > Select a Modeled Sheet to open the modeled sheet builder for that sheet.
- If you have an existing text selector column or custom dimension column, click "New monthly lookup table or new spread lookup table". If you do not have one of these columns, you can add one by dragging and dropping a text selector or custom dimension element from the far left into the column area.
- Once you have done this, you can create the desired lookup table.
- The lookup table can be referenced in the calculated account formulas as
Row.Associatedlookuptablecode. For example, if the associated lookup table had the code function1, the syntax in the formula would