Hello,

Sorry I'm not 100% sure if this is the right subforum, if mods could please redirect me accordingly if I'm wrong that would be great.

I'm trying to simplify a form by making a drop down menu where I can select one of my volunteers from a dropdown list for a task, and I want the end result to be that when they are selected the next two columns populate with that volunteer's email and specialization. I have the dropdown list figured out, and I have the information I want to populate filled out on another sheet next to the names I used to form the drop down list. Does anyone know if getting the info that goes with that volunteer to appear when the selection is made is possible?

Let me know if you need more information.

Thanks!