How do I link data between columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average if questions 2
accessing data from Access 1
How do I find a worksheet tab in a spreadsheet with multiple tabs? 4
Please Help If statement Data Location!!!!! 1
How To Clear Previous Selection From a Drop Down 2
Excel Spreadsheet Employee list 4
how to move all info in column a to seperate columns 1
Reference a column to make groups 1

Back
Top