Populating information based on selection from dropdown list

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!

You could use a vlookup function in those two columns. Lookup the person's name and return the data into the cells.

Hey guys thanks for the help, I'm very new to extensive use of excel and I've never even heard of vlookup before.

I tried to use the function as outlined, however I'm running into an error. The function returns either #VALUE or #REF every time. I've looked up both errors and can't figure out why they're showing up. Just to give you what the function looks like:

=VLOOKUP(D4,Volunteers!B3:C9,Volunteers!B:B,0)

Where D4 is the dropdown field, Volunteers is the sheet with the data, Column B is the names and C is the emails.

Thank you for your patience with this newbie

Change to:

=VLOOKUP(D4,Volunteers!B3:C9,2,False)

That did it! Thank you