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.