Creating an auto fill or drop down
 

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

Use a vlookup.
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Steve" wrote in message
...
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 he

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 he

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 he

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

Steve wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html