Locking VLOOKUP results.
 

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.

Locking VLOOKUP results.
 

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.