hi there, I am new here.

I require some help.

I have a drop down list of values (such as names for example)
I also have in another cell right next to the selection of names, the
employee ID, for example.

What I want is that on A cell away from this list, I want the cell to
have a drop down list box. This is easily done (Data validation)
The next thing I want is that when the user selects an item from this
drop down list, I want the employee ID, for the selected value, to be
populated appropriatly in the next cell.

is this possible?

how?

thanks!


--
tech_2006
------------------------------------------------------------------------
tech_2006's Profile: http://www.excelforum.com/member.php...o&userid=31643
View this thread: http://www.excelforum.com/showthread...hreadid=513327