I want vlookup gets value once

S

salih

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
 
B

Barb Reinhardt

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

salih

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":
 
Top