Create a table on another worksheet and then you can use =vlookup() to return
those other fields.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html

linstock wrote:

I'm trying to create a spreadsheet where I can enter a person's name and it
will automatically enter their department and charge number. Is there any
way to do this?
Thanks.

--

Dave Peterson