Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |