I want that vlookup gets value once

  • Thread starter Thread starter =?iso-8859-1?q?Salih_=DCnal_(Google)?=
  • Start date Start date
?

=?iso-8859-1?q?Salih_=DCnal_(Google)?=

I do not know how to express myself with my poor english but I have a
case
that vlookup getting value from another sheet which takes values from
Internet (euro/usd rate). But I want vlookup gets the value once and
not each
time that workbook is opened. I am getting always the same rate for all

records and I do not want this .. How to solve ? Please help

Sheet1 :
A1 A2 A3
RATE
01.Jan EUR 1,7
A3--> Formula:=VLOOKUP(A2;RATES!$E$10:$F$12;2;FALSE)
02.Jan EUR 1,7
03.Jan EUR 1,7
26.Jan EUR 1,7

Rate in Sheet RATES! is changing daily.
I want that old dates shows reciprocal values and not the latest one.
Many thanks
 
After a date has passed, you can manually change its formula to a value:

Select the rate cell, and point to its border
When the pointer changes to a four-headed arrow, hold the RIGHT mouse
button, and drag slightly to the right.
Still holding the right mouse button, drag the cell back to its original
position.
Release the mouse button, and choose Copy Here as Values Only.
 
Back
Top