Creating an auto fill or drop down

S

Steve

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
 
D

Debra Dalgleish

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
 
Top