Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I would like to vlookup multiple rows/columns and return to a single cell separated by commas. For example:

Date        Customer Code       Product     Price
25/07/2013      112136      Cement OPC       100.00 
25/07/2013      112136      Cement PPC       120.00 
25/07/2013      225637      Cement OPC       100.00 
25/07/2013      334787      White Cement     200.00 
25/07/2013      112136      White Cement     200.00 
26/07/2013      442514      Cement OPC       100.00 
26/07/2013      112136      White Cement     200.00 
26/07/2013      225637      White Cement     200.00 
26/07/2013      442514      Cement PPC       120.00 
26/07/2013      334787      Cement PPC       120.00 

Want to make the above table like :

Date        Customer Code    Product                 Price
25/07/2013      112136      Cement OPC,              420.00
                            Cement PPC,              
                            White Cement          
25/07/2013      225637      Cement OPC               100.00 
25/07/2013      334787      White Cement             200.00 
26/07/2013      442514      Cement OPC,              220.00
                            Cement PPC        
26/07/2013      112136      White Cement             200.00 
26/07/2013      225637      White Cement             200.00 
26/07/2013      334787      Cement PPC               120.00 

So, I would like to know whether there is any trick or function which lookup multiple columns/rows and return to single cell separated by commas (Product of Customer code: 112136 & 442514 of date:25/07/2013 & 26/07/2013 respectively).

share|improve this question
    
Are you not able to use pivot table instead? It's what it's for! –  Dave Aug 2 '13 at 10:59
    
You're going to need more than VLOOKUP. The Product field will require some VBA because CONCATENATE does not support array arguments. –  Excellll Aug 2 '13 at 13:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.