Concatenate If...

Hello,

I am trying to figure out how to Concatenate a group of cells if they contain a certain text. Basically I have a list of Architects in column A and the account name in column B... and I want to say Concatenate column A, IF column B=Specific Account (ex: Coca-Cola). The list will be added to frequently so the formula must refer to the entire columns, not just a certain range.

As of right now, only the first architect associated with each account will appear. I have attached a workbook with the example.. please let me know if any of you can help. Thank you

you meant to say sa/a1,sa/a2 get visible in single cell

=+VLOOKUP($A:$A,data!$B:$C,2,0)&","&LOOKUP(A1,data!$B$1:$C$6) use this formula b1 cell in enter formula sheet

Unfortunately I get a #Value for that. Could you explain what that formula is doing so I can try to understand and see if I can make adjustment to get working?

@morivejay.. yes what I meant to say is that my results should be SA/A 1, SA/A 2, .... it should give me a list of the SA/A's who are working in each region


All of my research has pointed me to download a plugin and use MCONCAT but the spreadsheet will be passed around to many people so I am trying to figure out an alternative... is there a way to do a vlookup that will return multiple values (cell1=SA/A 1, cell2=SA/A 2... then concatenate these cells?


I have not been able to master the vlookup that returns multiple values without getting error messages, but either way would work