So, the question does a poor job of outlining the problem. Apologies.
I've got one list where my clients track their projects; let's call it Projects. In it, they make a selection on a multiple choice column indicating what area of the company their project affects. The purpose of this is so that when it's time for the project to receive approval, it can be routed to the appropriate approver.
Approvers are linked with the respective areas via another list, which we'll call AreaOwners.
Occasionally, clients will have projects that affect multiple areas. Multiple areas require multiple approvers. So, how do I grab multiple names from my AreaOwners list based on multiple selections from the area column. It'd look like this:
1 NOC, LOC
NOC Jane Doe
LOC John Doe
POC Jack Johns
If I need to provide more information, I can.
Thanks in advance.