If Statement-selecting from a drop down menu??

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.

Hi!

See this:

http://contextures.com/xlFunctions02.html

Biff

"CrimsonPlague29" <[email protected]> wrote in
message news:[email protected]...
> 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.
>