Hello @Everyone,
I'm new here in the community, hoping to get support from someone who have work on the same use case I have below.
Use Case:
I have 2 tables, 1st table (Stakeholder Database) with column names Name and Email. 2nd table, (Sender Tool), with column names Responsible Name and Responsible Email. I want to seek support only on how I can show/get the value I wanted to return when I input 2 names under Responsible Name. I tried JOIN, INDEX and MACTH formula option, when I input 2 names at Responsible Name, it will return NO MATCH result. But if 1 name only it will return correct value.
ACTION NEEDED:
- When I input 2 names under (Responsible Name) it should return 2 email as well separated by semi colon.
SEE ATTACHED FILE AS REFERENCE.