![]() |
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