We need to send a mail notification based on reference table in a Google sheets.
In the form the user has to select a market. In Google Sheets we have a reference table with one column for the market and another column for the email address.
How I have to use the formula feature to make the mail notification send to the right email address based on the market ?
Thanks for your answer,