by using VLOOKUP see
http://www.mvps.org/dmcritchie/excel/vlookup.htm

You can probably put that next to the employee name in the table
you use to create the dropdown, but you will still have to use
VLOOKUP..

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rick" wrote in message ...
I have a column that has a drop down list of employee names (50ea).
I would like the cell in the next column to automaticaly insert the wage
rate for the emplyee name selected. How do I it ?