You already have part of your table - the list of names on the second
sheet. Put the hourly cost for each employee in column B, assuming the
names are in column A (Let's assume you have 20 of them, so this table
will occupy A1:B20 on Sheet2).

Assume your drop-down is in cell A1 of Sheet1, and that you want to
use A2 to enter the number of hours. Put this formula in A3:

=VLOOKUP(A1,Sheet2!A$1:B$20,2,0)*A2

and format this cell as currency.

Hope this helps.

Pete

On Mar 17, 4:59 pm, Matthew wrote:
I need help setting up a complicated function...if it can be done.

What I have is a cell that uses data validation (list). The list is a list
of employees that is in a different worksheet. I would like to be able to
select an employees name from the drop down list (I've got that part
working). After selecting the employees name the next row contains a place
to enter the number of hours that were worked on a job. I would like for the
3rd row to calculate the labor cost to the company based on the name (row
1-dropdown) multiplied by the number of hours worked on the project (second
row). I know that I will have to put the hourly cost of the employee in a
list, but the formula for this function is way too complicated for me to
figure out....help.