Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
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 |