Matchmaking app

1

Hi,

I’m building a small introduction app but I’m having trouble writing 2 operations that looks easy. ^^’

  1. In the column “Match” is used to select a match. Eg.: I want to introduce to Orelsan Cotentin to Michael Jackson → select email address orelsan@hotmail.com (cfr. table below). But then, I’d like that the table autofills michaeljackson@neverland.com in Orelsan’s row.
    Do you guys have any idea how to do it?
  1. Once the matches are done, I’d like to send an introduction email to all matches at the same time.
    Any ideas how can I create a formula that would understand the concept of matches to populate email content with the right data?

Thanks in advance for guiding me! :slight_smile:
J.