How to show a range or values in one cell?

[afc171]

Hi guys,
I get sent a Product pick sheet (first image) which will have the quantities required.
I then pull the information (from Sage) for the products to show what is in stock with batches and date receipted (see 2nd image)
If there is a product which needs to be picked from stock that has 2 or more different batches (e.g DYE0024 in 2nd image) but also need to pick the earliest receipted item how can I populate this information into Product pick sheet or the one I pull the information into from Sage?

Basically I need to copy the products and quantities requested into a sheet which will show me the earliest receipted product and batch.

Thank you

 

[yky]

Book out the next 3, 2 or 1. May have to check stock and the enter the batch in manually.

In case the total stock isn't enough to satisfy the request, you'll need to purchase.

You need a vba script to do what you're asking. Formulae can't do it.

 

[Zot]

In case the total stock isn't enough to satisfy the request, you'll need to purchase.

You need a vba script to do what you're asking. Formulae can't do it.

I can agree to this. It is a more practical approach. Using formula, you have to also do some tasks manually I believe.