Hello,

I have a list of products with lot numbers. Sometime we get additional products from the same lot number.
The lot numbers are entered into column C.
If the received product is same as we received before (according to the lot No. in C), I need excel to copy contents of from corresponding cell in column D into a corresponding cell again in column D.
I hope it is clear enough to provide me with some advice.