Help with multiple lookup

[DavidObeid]

My problem can be presented as follows:

If column A has an unordered list of numbers and colum B contain
textual descriptions of the entries in column A, how can I construct
formula that will concatenate all of the text entries in column B tha
match the same data in column A.

EG

A B
1 5 John
2 7 Tony
3 3 Mick
4 7 Pat
5 2 Mary
6 7 Louis
7 2 Andrew


I want to generate a formula to concatenate everyone who has a numbe
7. Ie my result will be "Tony Pat Louis". I can take care of formatin
later.

I'm still a VBA newbie, so any VBA solutions will need idiot proo
instructions on how to implement.

Thanks in advance.

Dav

 

[Aladin Akyurek]

Control+shift+enter:

=SUBSTITUTE(MCONCAT(IF(A1:A7=7,","&B2:B8,"")),",","",1)

MCONCAT is part of the morefunc.xll add-in
(http://longre.free.fr/english/index.html). If needed, you can replace
MCONCAT with Harlan Grove's ACONCAT, the code of which you can find by doing
a search with Google.

My problem can be presented as follows:

If column A has an unordered list of numbers and colum B contains
textual descriptions of the entries in column A, how can I construct a
formula that will concatenate all of the text entries in column B that
match the same data in column A.

EG

A B
1 5 John
2 7 Tony
3 3 Mick
4 7 Pat
5 2 Mary
6 7 Louis
7 2 Andrew


I want to generate a formula to concatenate everyone who has a number
7. Ie my result will be "Tony Pat Louis". I can take care of formating
later.

I'm still a VBA newbie, so any VBA solutions will need idiot proof
instructions on how to implement.

Thanks in advance.

Dave


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[Jim]

In the example you have given:
=IF(A2=7, A2&""&B2,"")


--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

My problem can be presented as follows:

If column A has an unordered list of numbers and colum B contains
textual descriptions of the entries in column A, how can I construct a
formula that will concatenate all of the text entries in column B that
match the same data in column A.

EG

A B
1 5 John
2 7 Tony
3 3 Mick
4 7 Pat
5 2 Mary
6 7 Louis
7 2 Andrew


I want to generate a formula to concatenate everyone who has a number
7. Ie my result will be "Tony Pat Louis". I can take care of formating
later.

I'm still a VBA newbie, so any VBA solutions will need idiot proof
instructions on how to implement.

Thanks in advance.

Dave


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements