M
maryjayhawk
Greetings:
I have a worksheet (A) with a list of employee names in one column and
their rates of pay in another column.
On another worksheet (B) within the workbook, I have a list of hours
that employees worked, that includes a list of employee names in one
column and their hours in another column.
I want to reference the Worksheet A rates of pay in order to calculate
the value of the hours on Worksheet B.
I'd like to have a column on the worksheet B that says:
If the employee name on Worksheet B equals an employee name on
Worksheet A, return to this cell on Worksheet B the associated rate of
pay.
Example:
Worksheet A, cell C3 = Mary, cell E3 = $25.00
Worksheet A, cell C4 = Joe, cell E4 = $15.00
Worksheet A, cell C5 = Harry, cell E5 = $20.00
Worksheet B, cell D8 = Mary, cell H8 = formula cell
Formula should be: If Cell D8 equals one of cell C3-C5, then return
the matching E cell
I can make this work with one cell reference. (If D8 = C3, then E3)
But I'd like it to work with the whole list, so that the formula would
check the Worksheet B cell against the whole Worksheet A list.
Can someone please assist?
Many thanks,
Mary
I have a worksheet (A) with a list of employee names in one column and
their rates of pay in another column.
On another worksheet (B) within the workbook, I have a list of hours
that employees worked, that includes a list of employee names in one
column and their hours in another column.
I want to reference the Worksheet A rates of pay in order to calculate
the value of the hours on Worksheet B.
I'd like to have a column on the worksheet B that says:
If the employee name on Worksheet B equals an employee name on
Worksheet A, return to this cell on Worksheet B the associated rate of
pay.
Example:
Worksheet A, cell C3 = Mary, cell E3 = $25.00
Worksheet A, cell C4 = Joe, cell E4 = $15.00
Worksheet A, cell C5 = Harry, cell E5 = $20.00
Worksheet B, cell D8 = Mary, cell H8 = formula cell
Formula should be: If Cell D8 equals one of cell C3-C5, then return
the matching E cell
I can make this work with one cell reference. (If D8 = C3, then E3)
But I'd like it to work with the whole list, so that the formula would
check the Worksheet B cell against the whole Worksheet A list.
Can someone please assist?
Many thanks,
Mary