Creating an auto fill or drop down

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

Guest

I'm using Excel 2003 and I'm trying to make it so if I enter an employees id
number their pay rate will be put into the cell so I don't have to keep
looking it up. Can I either do this from a drop down menu or make it so that
if I type in 329 it will put $25.00 in the cell?

Thanks
 
You can create a list of employees and their pay rates. Name that range
-- there are naming instructions here:

http://www.contextures.com/xlNames01.html

Then, in the main table, you can use data validation to provide a
dropdown list of employee ID numbers. There are instructions in Excel's
Help, and here:

http://www.contextures.com/xlDataVal01.html

To return the pay rate for the selected employee, you can use a VLookup
formula. There are examples in Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html
 
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

How to get info filled in automatically 2
Drop down / validation / lookup into the same cell 2
Filtered drop down list 2
Auto-Completion on Drop-Down Lists 2
Need a drop down list to auto fill other cells... 1
Fill Drop Down with List 2
how do I create a drop down list that assigns certain information 1
auto fill or auto search from a list or drop-down list??????? 9

Back
Top