Values Dropdown List in a form

Good morning everyone,

I would like to ask if is possibile, in a dropdown list inside a form, to insert a value like 'GENERAL DIRECTOR' but the cell in the sheet is filled with a mail (example generaldirector@mail.it). Is possibile to do this kind of association? I hope I have explained the 'problem' clearly.

Or the only way to do it is to create another sheet where I put the value and the corresponding mail, then use a formulas to have the mail in the sheet that I need?

Thanks for the support.

Answers