Concatenate columns with information base on user selection

**gward2701** · 12-03-2012, 02:08 PM

Hi Everyone,

I have to concatenate a number of columns with information from another sheet base on what a use enters on the first column

for e.g sheet 1 has four columns and the fifth column I want to concatenate the information together with information from sheet 2

=CONCATENATE(IF(A2="SAP";'data 2'!B1&";"&B2&";"&C2&";"&D2);(IF(A2="SAD";'data 2'!B2&";"&B2&";"&C2&";"&D2)))

**alansidman** · 12-03-2012, 02:28 PM

Try this:

=if(A2="SAP",Concatenate('data 2'!B1&";"&B2&";"&C2&";"&D2),if(A1="SAD",concatenate('data 2'!B2&";"&B2&";"&C2&";"&D2),Value here if something other than SAP or SAD))

Check this tutorial and especially the last example. I am not sure about your concatenation sequences. I suspect they need to be tweaked as you did not give us expected results.

Alan

**gward2701** · 12-05-2012, 09:34 PM

HI Alan,

Thanks for the code.
but it seems when I ad another row of data excel tell me that you hve entered toom any arguments for the function

e.g

=IF(A2="SAP";CONCATENATE('data 2'!B1&";"&B2&";"&C2&";"&D2);IF(A2="SAP";CONCATENATE('data 2'!B1&";"&B2&";"&C2&";"&D2));IF(A2="SAP";CONCATENATE('data 2'!B1&";"&B2&";"&C2&";"&D2)))
I did not see the link to the tutorial that you spoke about.

gward2701

**djapigo** · 12-05-2012, 09:55 PM

Hi gward2701,

Watch your parentheses...

An IF function requires 3 parameters, IF(condition,true,false)

For nested IF functions, the true or false (or both), can be replaced by another IF statement, which will also need 3 paramenter as above.

Your formula should look like this... IF(condition1,concat1,IF(condition2,concat2,concat3))

In your nested IFs, it should read something like this... IF(A2="SAP",concat1,IF(A2="SAD",concat2,concat3))

In your formula, the 2nd IF statement has a condition, a true statement, but missing a false statement. Watch your parenthesis...

Hope this helps...