Look up values in a module that stores data against a list
I am new to Anaplan. Please help!
Lisy Y: List of years
Value(Has a value stored for every year)
Format: List Y
Formula: 'Module A'.'LIA1' [LOOKUP: (LIB1+'LIB2')]
I want to get the Value for a future year using this formula and it is not working becase LOOKUP requires a list. I am not sure how to accomodate the future yr in the LOOKUP formula.
Can you please tell me how to resolve this?