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

"Aposto" wrote:

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.