Remove/disable lookups and formulas when a date has passed in each row.

[Mhay5656]

Hi,

I have a spreadsheet that has lookups and formulas that retrieves information from another sheet , what I would like to do is stop or disable the lookups automatically when a date in the row has passed the current date. IF this could be done by a macro automatically.

The reason being is that I need to update the data in the lookup sheet quite regularly, some of the data will change or is removed which will error the previous entries on the main sheet, so what I need is a way to stop or disable the lookups so my old data does not change, or Saves values macro .

Example - before updated data this what it looks like in my spreadsheet

showing in a Row is - John 27/11/17 (current date) $50,000.00 (I don't want this to change)

after I have updated the rate has changed

John 27/11/17 $60,000.00 (need to keep the $50K and not update)

After up date if John's details are no longer showing I end up with #n/a#

and need the details above to stay without the formulas etc "John 27/11/17 (current date) $50,000.00"

Many thanks

[kersplash]

Just add an IF before the vlookup that checks the date and only does the lookup under the condition you want.

Sorry didn't understand all of the question. Ignore my answer.

[colaboy]

How are the rates stored?

If the rates are stored with dates in a chronological list you can pick the latest rate for each date with vlookup (using range lookup).

[Mhay5656]

Thank you for your help, I will send another post as what i am looking at is a macro that paste values