vlookup untill a vaule is found then automaticaly paste the result

A

Aposto

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.
 
Top