Hi Ely,
try using a Pivot Tablej

or a macro solution
http://www.mvps.org/dmcritchie/excel...tm#joining.htm
of course this is just using the second sheet as input in creating another sheet
if sheet1 has to be used for input then neither of these solutions would work
for you.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ely" wrote in message ...
Hey All!

I'm trying to pull country prefixes for matching countries from the second
sheet that has recurring countries with respective prefix to the first sheet
that is not recurring, prefix for same country in one cell separated by comma.

Please see attached link for a visual description.

Will appreciate your input.

Link: http://www.excelforum.com/attachment...0&d=1135879308