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


--
maryjayhawk
------------------------------------------------------------------------
maryjayhawk's Profile: http://www.excelforum.com/member.php...o&userid=32964
View this thread: http://www.excelforum.com/showthread...hreadid=527904