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