If you had a table with the other information that relates to Billy (and other
names), you could use =vlookup() to return that info.

For more info about =vlookup()...
You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html

Mark wrote:

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.

--

Dave Peterson