ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I want vlookup gets the value once (https://www.excelbanter.com/excel-worksheet-functions/68035-i-want-vlookup-gets-value-once.html)

Salih Ünal (Google)

I want vlookup gets the 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 h

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



All times are GMT +1. The time now is 07:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com