Labor and Cost

**rtfreema** · 09-21-2011, 06:56 PM

I need some assistance in getting some automation with some list boxes. We have multiple Craft employees, (App. Mech, Mech, App Elec, Elect, etc) and a different hourly dollar value for each of them. ($5, $10, $15 etc.) What I want to do is set a drop down box with the Craft employees, and then when the selection is made that it populates another cell with the dollar value that employee would cost..

I can then calculate the cost for the number of hours that employee will work.

Could anyone give me a little help on this one.

Thanks
Todd

**alansidman** · 09-21-2011, 10:07 PM

Look at the attached. Combined a data validation for jobs with a vlookup.

Alan

**rtfreema** · 09-22-2011, 12:19 AM

That is what I was looking for but I have one question..To add to the job descriptions i added to the column but it didn't show up in the drop down when i went back.. How did you get it to sheet 2 to get the drop down items.. I am not familiar with lookup tables and how they work... Thanks for your help.

**alansidman** · 09-22-2011, 08:16 AM

Because the range to look up is on a different worksheet, you have to give it a range name. In this case Job. Go to the second sheet and change the range to include more cells.

Here is a tutorial on data validation.
http://www.contextures.com/xldataval05.html

Alan