vlookup

Hi all,

I use a simple vlookup function to search for a batchnumber in a list of products. In this list the batchnumbers may be updated on delivery of new products. However I don't want the results of previous lookups to be changed. In fact the Vlookup should work only once.

Does anyone know a solution?

Thanks!