I need to create a spreadsheet that lists employees names in one column and
their location in another column. Everytime I do this, I need to search for
the employee's location. I'm convinced that there's a way to enter employee's
name and have their location automatically be filled in (assuming,of course,
the location doesn't change). So that, for example, every time I enter "Jane
Doe" her location (or possibly a list of locations) pops up or is automically
entered.

Does anyone know how to do this?

The vlookup function should solve your issue. You can find out how to
do it in Excel help.

Hi
use VLOOKUP:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany
"NMHemp" schrieb im Newsbeitrag
...
I need to create a spreadsheet that lists employees names in one column and
their location in another column. Everytime I do this, I need to search
for
the employee's location. I'm convinced that there's a way to enter
employee's
name and have their location automatically be filled in (assuming,of
course,
the location doesn't change). So that, for example, every time I enter
"Jane
Doe" her location (or possibly a list of locations) pops up or is
automically
entered.

Does anyone know how to do this?