Hi,
Would like to ask if I can lookup a list item which is classify as a parent list? I tried it but it does not work. I got values using lookup if the list classify as child list.
Thank you.
Darlene
Hi DM,
It appears the DIR COA list is a ragged hierarchical list. In the ragged hierarchy, lookup works at the child level, not at the parent/summaries. As an alternate for Lookup use Select function.
Why do you not want to use Select function, Is it a production list?
~Vignesh M
@DMManalili , Could you share some screenshot of what you are trying with an explanation?
I created a staging module to lookup the value.
first, below is the screenshot of the list.
second is the system module for the mapping
third is the calculation module, I used select function because I cannot get the values if I used lookup, but I want to use lookup instead.
hi VM,
Noted for this. I was just thinking if its better to use lookup rather than select but I will use select instead.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…