Hi Claus,

I was able to fix what I thought was the a problem. Mostly lost track of what the sheet was supposed to be doing.

This works as I was shooting for.

https://www.dropbox.com/s/cldxiv88yw...v1 .xlsm?dl=0

With a drop down in B4, select an entry and "Like" values from sheet Lot are assembled to Product.

I am not sure, but you probably offered a solution as such and I was mixed up on what it should be.

Very sorry for the rat race post.

Thanks.

Howard