vlookup untill a vaule is found then automaticaly paste the result

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

 

[Aposto]

See post "Macro to look for where vLookup has a result then paste value" for
answer