I’m trying to put Lookup and SUM function but every time it says ‘The formula is invalid’ and it doesn’t exactly tell what is the problem.
I want to import data in Module F from Module A and Module B.
I tried to use below formula for importing Module A data to Module F as they both have same dimension so i thought it would be easy to import but I got below error:
In Module F, Writing formula for Capacity as -> Module A.Capacity [Lookup:D1, Lookup D2]
** Line items are all numbered format. Attaching screenshot for clarity.
Any suggestion would be appreciated.