Lookup off of code

I need to be able to lookup off a unique opportunity code for line items in a module.

Below is the code I need to look up off of, the list is titled MEC Opportunities

In this module, I need the line item Opportunity Code (list) to return the above codes while also being list formatted in order to use in lookup functions.

My train of thought is FINDITEM(Code(Item('MEC Opportunities')), Opportunity Name) however this has not been working.

Any help/corrections would be greatly appreciated, thanks!

Accepted answers

All comments

ArunManickam

Hello @KevinMcQuillen ,

You are not following the syntax for finditem. The first parameter is the name of the list, second parameter should be code/name that you are trying to match.

Let me know if it helps.

Thanks

Arun

KevinMcQuillen

This still does not return the code, however - it returns the list item names per below

I need the line item to be returning the unique codes from the list - while also keeping the line item list-formatted so that may utilize LOOKUP formulas off of the Code.

Is this functionality possible?

ChrisAHeathcote

@KevinMcQuillen

It is not possible to return the code in a list formatted line item as a code as a text format.

Create a new line item, format it as TEXT and use CODE() on the list formatted line item to return the list code.

KevinMcQuillen

Sorry I don't think I'm explaining this well.

The core of the issue is this - Management has requested a dashboard view of a list - 'MEC Opportunities' - which is a specific set of opportunities with very specific naming conventions, therefore in the list I must use a display name. This used to be a subset of a larger list titled - 'All Opportunities' - however given managements request on how they want to view the Grid, I need a new list with the correct Display Name. There is a filter in a properties module which can be checked if an opportunity qualifies as MEC. I used a saved view with the MEC filter applied to create the 'MEC Opportunities' list.

Then in the module, I have various line items which require a LOOKUP formula. The module is dimensionalized by the 'MEC Opportunities' list. In various other modules, I create an 'All Opportunities' list formatted line item which I then use for the LOOKUP functions, per below...

This example above is a module in which the functionality is working. Below is the module I am seeking help on, b/c the same process is not working.

For the "SalesReq" and "Opportunity URL" line items, when I try to LOOKUP on the "Opportunity (list)" - 'Properties: All Opportunities'.SalesReq[LOOKUP: 'Opportunity (list)'] - I get a mapping error. My thought was that this is because of the different display name, the MEC Opportunities List and the All Opportunities list are un-able to match. Therefore I was hoping to be able to LOOKUP on the code, however as you mention that is impossible.

So yes, creating a text-formatted line-item with the code is simple to do, but it does not exactly accomplish what I am needing.

Do you have any other work-arounds you can think of for this situation?

Thanks for all the help, it is much appreciated!

ChrisAHeathcote

@KevinMcQuillen

You can use the list code to inform your FINDITEM to retrieve the list item.

You can also use ITEM if the module contains the list as a dimension.

What is not possible is using the text formatted display name in the FINDITEM function.

I you need to show the display name and then use this module to inform a mapping you will need to create two line items - one to show the display name and another to use in a mapping ( this can take the code and use FINDITEM to return the list item which can then be used in a mapping )

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…