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!