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?