VLOOKUP help aka if user chooses cell a1, then b1 equals x - Noob Alert

Good people,

I'm trying something I normally don't do.

I'm creating drop down boxes with text, using the Data Validation (list). Now, I'm wondering if a formula can be created based on the selection of the drop down box.

What I want is this: If cell D8 (drop down) equals D1, then choose E1, and if cell D8 (drop down) equals D2, then choose E2...so on and so forth with about 50 choices . Can this be accomplished?

Basically, I want the user to choose the text in the drop box, and the next cell (column) be populated by what they choose automatically.

Thanks!!

In E8 use

=vlookup(D8,$D$1:$E$7,2,false)

Adapt ranges accordingly..Trust this is what you want