Looking up values in multiple cells
 

Hi,

I have a spreadsheet that shows open purchase order lines, the due date and
the quantity. Some part numbers have multiple receipt dates and quantities.
How can I get those multiple dates into one cell on another spreadsheet?


Thank you,

Looking up values in multiple cells
 

Hi Richard,
If the receipt dates are located in B2 and B3, the formula may be

=TEXT(B2,"dd.mmm.yy")&", "&TEXT(B3,"dd.mmm.yy")


--
~roar


Richard skrev:

Hi,

I have a spreadsheet that shows open purchase order lines, the due date and
the quantity. Some part numbers have multiple receipt dates and quantities.
How can I get those multiple dates into one cell on another spreadsheet?


Thank you,