Mark, use a look up table, have a look here for details

http://www.contextures.com/xlFunctions02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mark" wrote in message
...
I have a form that asks for Name, Job Title, Employee ID number, etc. I can
create a drop down list using Validate no problem. However, I want to be
able
to automatically populate the fields when a person's name is selected.

For example, if I select Billy from the Name drop down list, the Job
Title,
ID Number, etc. gets automatically filled.