If Statement-selecting from a drop down menu??

[CrimsonPlague29]

Hello,

Would like to know if the following is possible:
I have 2 lists 1) Name
2) EE#

I would like the corresponding EE# to automatically appear in the EE# column
when an Name is selected from the validation list.

Thanks.