I need a formula to do the following.

If A3 (hours worked) is greater than 40 then look for employee name (on
separate tab in workbook) and take the overtie pay rate and multipy the rate
x A3, if greater than 40, take the regular rate and multiply the rate x A3.

The formula I created will figure choose the right rate but will not lookup
the person out of the list but this department has 20 people so I need the
formula to look for the person's name and then multiply the rate of pay (reg
rate if under 40 and OT rate if overt 40) x the number of hours. I can't
remember how to name a range in a formula so the vlookup will work right.

Thank you.