I want vlookup gets value once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What formula (specifically) are you using and can you show us some of the
data you are using.
 
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":
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want that vlookup gets value once 1
VLOOKUP 2
Need to bring back 2 vlookup values 2
VLOOKUP source values are a formula result. Getting #N/A 7
VLOOKUP date search 1
vlookup question 4
First column of range in VLOOKUP contains formula 2
Vlookup w/sum? 3

Back
Top