VLOOKUP To Return Multiple Values in one cell

[Tjclarks]

Hello All,

i am working with a database of different products which originate from different countries and i would like that the Vlookup function would return multiple results into one cell.

I put an example link below.

http://www.2shared.com/file/nDcyCh-2/example.html

Thank you all in advance.

 

[CharlesChuckieCharles]

It's not what Vlookup Does, you could string a number of vlookups in the same formula if its text..
but Vlookup looks for only the first qualifying occurance

If you want to total look at SUMIF Or SUMIFS

Or COUNTIFS for counts

 

[Smokeit]

OK I have opened your spreadsheet, but what needs to be looked up from where and retain what value? That would help the VLOOKUP function but to display the result in one cell you will need to use the CONCATENATE function to group up the independantly looked up values together.

 

[Tjclarks]

I would like that when i lookup the reference all of the countries where this product is from would jump out in one cell. is there a formula for this maybe?