I have a spreadsheet that uses VLOOKUP to get a person's pay rate based on
their name and use it to calculate a running total of our YTD overtime
expense in my main sheet. The problem I have is when they get a raise, I want
to use the new rate for all new calculations, but I don't want to change the
previous calculations. Can you give me some ideas to explore?

example....
day name $/hour hours OT pay YTD OT expense
9/10 Bill 10 2 20.00 20.00 (Bill's rate is 10.00
in the lookup table)
9/11 Jane 12 3 36.00 56.00
9/15 Bill 11 2 22.00 78.00 (Bill has a new rate
of $11/hr, but I don't want my table to go back and change the entry for 9/10.

One suggestion.

Before you change Bill's rate, copy the cells using old rate and paste
special as values.


Gord Dibben MS Excel MVP

On Tue, 30 Sep 2008 07:15:01 -0700, thomas404
wrote:

I have a spreadsheet that uses VLOOKUP to get a person's pay rate based on
their name and use it to calculate a running total of our YTD overtime
expense in my main sheet. The problem I have is when they get a raise, I want
to use the new rate for all new calculations, but I don't want to change the
previous calculations. Can you give me some ideas to explore?

example....
day name $/hour hours OT pay YTD OT expense
9/10 Bill 10 2 20.00 20.00 (Bill's rate is 10.00
in the lookup table)
9/11 Jane 12 3 36.00 56.00
9/15 Bill 11 2 22.00 78.00 (Bill has a new rate
of $11/hr, but I don't want my table to go back and change the entry for 9/10.