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?