View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aposto Aposto is offline
external usenet poster
 
Posts: 7
Default vlookup untill a vaule is found then automaticaly paste the result

Can anyone tell me how I can do the following either using a formula or a
macro?
I have a vlookup an empolyee name and return a piece of employee information
which is updated preiodically. When the vlookup finds a result, I'd like it
to keep that value and never update it again.