You need a few VLOOKUP formulas to return the data based upon the selection from
the drop-down.

See Debra Dalgleish's site for info or just check out Help on VLOOKUP.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On 22 Sep 2006 16:59:51 -0700, wrote:

Here's my situation:

I have a list of employees on on one worksheet. In the cells next to
each employee name are their hourly pay rate, their department, and
their various overtime thresholds (the elapsed hour they go in to
overtime varies by employee).

On a second worksheet, I've created a drop-down list for the employee
names. I want their pay rate to follow the name, and appear in the
cell next to the name. Currently, Excel 2003 is telling me that only
delimited files are allowed to do that. Is there a way for the
corresponding pay and overtime fields to migrate with the employee's
name from the drop-down list?

Thanks!

~Rip