Looking up values in multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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")
 
Back
Top