Hi you need to select the whole list of names and then type in the cel
display window (the one to the left of the formula bar) a name for you
range, do this for the ID range too, once you have done this click th
cell you would like a drop down list of names in and then choose DAT
from the menubar, now choose VALIDATION click the drop down arrow o
the ALLOW box and select LIST, now type =LIST (where LIST would be you
range name but it must be spelt exactly the same as you named it). Yo
should now be able to click the cell you selected for the drop down an
a dropdown arrow should appear for you to make your selection, no
repeat the excersise for the next list.

Hope this helps,

Regards,

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=49866