I want vlookup gets value once
 

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

I want vlookup gets value once
 

What formula (specifically) are you using and can you show us some of the
data you are using.

"salih" wrote in message
...
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

I want vlookup gets value once
 

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

"Barb Reinhardt":

What formula (specifically) are you using and can you show us some of the
data you are using.

"salih" wrote in message
...
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