Pulling one specific cell data to another specific cell in Anaplan

I am quite new to model building and a client has come across trying to pull data from one specific cell to another specific cell from two different modules. Based on the training i have gotten it mostly talks about pulling rows and column data but not specifc cell data. Hope you guys can help. Thank you.

Accepted answers

leo_tadjudin_1

Hi Dino,

You might have figured it out by now. But just in case, you can write a formula with LOOKUP to specify exactly the intersection of data which you want to draw from the other module.
The lookup formula is good to refer to a non-existing list within your module.

Give it a try. Let me know if it works.

Regards,
Leo

All comments

leo_tadjudin_1

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…