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.