Software

I am trying to streamline an excel document that I created. Instead of typing all the info in, I thought it would be easier to have drop down boxes and the only data that would change would be the information in the lists on Sheet 2.
Instead of having multiple drop down boxes, how can I have one or two drop down boxes and then have the other cells populate based on the selection from said drop down box.

Example: Two lists, one with names and the other with email addresses. When a user selects a name then an email address will be displayed in the assigned cell.

Any help would be much appreciated. Non-VBA first as I am very poor at VBA, so if, lookup, match statements would be awesome. The lists are words (strings) and that is what is throwing off my returns in if, lookup, and match statements.

Hopefully this all makes sense. Thank any and everyone for your time and consideration.