I need an excel file with a sheet (Pay Table) that has a list of employees in a column and their corresponding pay rate in the next column. This list needs to be expandable (1 - 200 employees).
I also need another sheet (Calculations) that has an employee column, an hours column and a total dollars column. This sheet needs to be unlimited (or whatever the excel limit might be) in rows.
What i need is a formula that gets the employee name entered on the Calculations sheet, then grab the corresponding pay rate from the Pay Table sheet, then multiply that pay rate by the hours from the Calculations sheet and enter that in the corresponding Total Dollars column.
I attached a workbook to help out with my explanation.
Thanks for any assistance.