Automatically Filling In Corresponding Data from Another Worksheet riprussell[ at ]aol.com 22.09.2006 23:59:51 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

Re: Automatically Filling In Corresponding Data from Another Worksheet "RagDyer" <RagDyer[ at ]cutoutmsn.com> 23.09.2006 00:08:26 Very easily, using Vlookup. Check out instructions here at Debra Dalgleish's web site at: http://www.contextures.com/xlFunctions02.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- <riprussell[ at ]aol.com> wrote in message news:1158969591.787879.60310[ at ]k70g2000cwa.googlegroups.com... [Quoted Text] > 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 >

Re: Automatically Filling In Corresponding Data from Another Worksheet Gord Dibben <gorddibbATshawDOTca> 23.09.2006 00:52:28 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, riprussell[ at ]aol.com wrote: [Quoted Text] >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