Text Data

[KVAMSHE]

Hi,


Am looking for a similar formula like sumif which will add/concatenate text data from one sheet to another. See the example below:


Source file data-

Name Travelled Region

A USA

B APA

C EU

B USA

C APA

B EU


Name Region

A =(formula) i.e. USA

B =(formula) i.e. APA/USA/EU

C =(formula) i.e. EU/APA


Could you please help me with formula as per my requirement.


Thanks in advance

 

[Montrey]

=b1&b2&b3

 

[oldchippy]

Hi KVAMSHE,


A =B2


B =B3&"/"&B5&"/"&B7


C =B4&"/"&B6

 

[bobhc]

Good day Montrey

[pre]

I see you are still struggling to get out of your bad habit of posting unnecessary long code :)
New	York	City	NewYorkCity


The above = =CONCATENATE(A1,B1,C1)

New	York	City	New York City

[/pre]
The above = =CONCATENATE(A1," ",B1," ",C1)

 

[KVAMSHE]

Hi,


This is not am looking for..actually source data & target data are of different files/workbook but not same sheet. Secondly, through some lookup formula i want to link both the files and then concatenate the text that matches the parameters (eg:similar to sumif where it sum the values and displays total).


Regards,

Vamshe

 

[oldchippy]

Hi Vamshe,


If you need to link different files then take a look at this link


http://office.microsoft.com/en-us/excel-help/create-an-external-reference-link-to-a-cell-range-in-another-workbook-HP010342364.aspx


or maybe this


http://chandoo.org/wp/2011/03/31/excel-hyperlinks/