Using LOOKUP on multiple properties in a Numbered List

Hi - Wondering what is the best/practical process here. I have a Numbered list (#Job Profile) with "comp code" and "comp location" as properties (Attached for reference).

I have a module has the Job Profile Code (Job code = comp code) and Connect Comp Location, the data/line item by itself is not unique but the paring should equal a member on the #Job Profile list.

Can I use the values in the module for this line item to Lookup on the numbered list and retrieve the code of the member in the list?

What is the ideal way to achieve this?

module.png

List.png

Accepted answers

All comments

Venki9902

Hi @Walker32 ,

Does your module has the same mentioned member list as dimension?

if so you can refer these lineitems in formula bar your list properties.

Hope this helps :).

Regards,
Venkatesh

Walker32

hi @Venki9902 - the module is a flat mapping module. I don't want the reference the module in the list but want to reference the corresponding list member in the mapping module using the 2 line item values found in the mapping module.

Venki9902

Hi @Walker32 ,

I think your below mentioned statements would be a better approach.

Use the values in the module for this line item to Lookup on the numbered list and retrieve the code of the member in the list.

regards,

Venkatesh

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385