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?