Auto fill of columns

[linstock]

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]

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