Hello Everyone,
Trying to solve this problem, for a given unique value (order number) I want to vlookup;return multiple value from different rows to a single cell. I have attached a spreadsheet with data set and desired result. Thank you for any assistance.
Regards
Sang
See this workbook
It uses a helper column to count the number of entries each Order Number has, as it appear in the list.
Concatination isn't a strong point in Excel, to handle this see how the SI Numbers are assigned to the Order Number, then Concatinated.
Last edited by Marcol; 08-24-2012 at 05:58 AM. Reason: added a description
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks