Concatenate: Two cells from Sheet2 into One cell in Sheet1

[sam]

Hi All,

How can I concatenate two cells from Sheet2 and display in One cell in Sheet1?

Here is the formula I got so far.. But its not working

= IF(+Sheet2!B5=+Sheet2!B2,(Sheet2!B2 & "-" & Sheet2!D2),(Sheet2!B3 & " & "
& Sheet2!B4))

Thanks in advance

 

[Jacob Skaria]

Do you mean

=IF(Sheet2!B5=Sheet2!B2,Sheet2!B2 & "-" & Sheet2!D2,Sheet2!B3 & "-" &
Sheet2!B4)

If this post helps click Yes

 

[Sam]

thank you jacob, Is there a way of writing Elseif statement in excel sheet?

There are three conditions possible for this cell.

Eg: If Sheet2!A1 = Sheet2!B1 Then Sheet1!A1 = Sheet2!B1 & Sheet2!C1
ElseIf Sheet2!A1 = Sheet2!B2 Then Sheet1!A1 = Sheet2!B2 & Sheet2!C2
ElseIf Sheet2!A1 = "" Then Sheet1!A1 = ""

Thanks in advance

 

[Jacob Skaria]

No ELSE statement..But you have TRUR/FALSE .So your formula equates to

=IF(Sheet2!A1 = "","",IF(Sheet2!A1=Sheet2!B1,Sheet2!B1 &
Sheet2!C1,IF(Sheet2!A1=Sheet2!B2,Sheet2!B2 & Sheet2!C2,"")))

If this post helps click Yes

 

[Sam]

That worked out great! Thank you once again

No ELSE statement..But you have TRUR/FALSE .So your formula equates to

=IF(Sheet2!A1 = "","",IF(Sheet2!A1=Sheet2!B1,Sheet2!B1 &
Sheet2!C1,IF(Sheet2!A1=Sheet2!B2,Sheet2!B2 & Sheet2!C2,"")))

If this post helps click Yes