# Multiple rate of pays

D

#### Denise

On a spreadsheet, the date worked would be in column A; employees' name are
in column B. An individual maybe listed several times in column B . In
column C would be # of hours worked that day. What formula could be used so
I don't have to type the rate of pay (which should stay hidden) for each
person every day?
Thanks.

P

#### Pete_UK

You would normally set up a table somewhere (on a second hidden sheet
perhaps) which will have the person's name and the rate of pay,
something like this:

John 5.50
Fred 10.00
Mary 12.00
Anne 7.50
etc.

Suppose this is in columns A and B of Sheet2. Then in D2 of Sheet1 you
could have:

=VLOOKUP(B2,Sheet2!A:B,2,0)*C2

to give you the cost for that employee (i.e. rate times hours worked).
Then copy the formula down as far as needed.

Hope this helps.

Pete

D

#### Denise

Worked great...THANKS!

Pete_UK said:
You would normally set up a table somewhere (on a second hidden sheet
perhaps) which will have the person's name and the rate of pay,
something like this:

John 5.50
Fred 10.00
Mary 12.00
Anne 7.50
etc.

Suppose this is in columns A and B of Sheet2. Then in D2 of Sheet1 you
could have:

=VLOOKUP(B2,Sheet2!A:B,2,0)*C2

to give you the cost for that employee (i.e. rate times hours worked).
Then copy the formula down as far as needed.

Hope this helps.

Pete

.