Matchmaking app


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 (cfr. table below). But then, I’d like that the table autofills 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: