Excell Formula to Match Values Vlookup or some other

May 22, 2012 at 01:12:17
Specs: Windows XP
I have a database Sheet 1 Column A shows around 1500 banks with repeating names and Column B is names of countries in which those banks are operating. On another Sheet 2 I have list of same banks but appearing just once. I want a formula to look bank value in sheet 1 match it with sheet 2 and place countries name in sheet 2 infront of banks but in one cell instead of different cells.

See More: Excell Formula to Match Values Vlookup or some other

Report •


#1
May 22, 2012 at 08:25:15
You really want all of the countries listed in one cell?

e.g.:

China Japan US France

...all in one cell?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question