View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
salih
 
Posts: n/a
Default 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