| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate: Two cells from Sheet2 into One cell in Sheet1
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate: Two cells from Sheet2 into One cell in Sheet1
Do you mean
=IF(Sheet2!B5=Sheet2!B2,Sheet2!B2 & "-" & Sheet2!D2,Sheet2!B3 & "-" & Sheet2!B4) If this post helps click Yes --------------- Jacob Skaria "sam" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate: Two cells from Sheet2 into One cell in Sheet1
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" wrote: Do you mean =IF(Sheet2!B5=Sheet2!B2,Sheet2!B2 & "-" & Sheet2!D2,Sheet2!B3 & "-" & Sheet2!B4) If this post helps click Yes --------------- Jacob Skaria "sam" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate: Two cells from Sheet2 into One cell in Sheet1
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 --------------- Jacob Skaria "Sam" wrote: 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" wrote: Do you mean =IF(Sheet2!B5=Sheet2!B2,Sheet2!B2 & "-" & Sheet2!D2,Sheet2!B3 & "-" & Sheet2!B4) If this post helps click Yes --------------- Jacob Skaria "sam" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate: Two cells from Sheet2 into One cell in Sheet1
That worked out great! Thank you once again
"Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Sam" wrote: 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" wrote: Do you mean =IF(Sheet2!B5=Sheet2!B2,Sheet2!B2 & "-" & Sheet2!D2,Sheet2!B3 & "-" & Sheet2!B4) If this post helps click Yes --------------- Jacob Skaria "sam" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy changing group of cells from Sheet1 to Sheet2 | Excel Programming | |||
| Populate growing range of cells from Sheet1 to Sheet2 | New Users to Excel | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
| Copying Cells from Sheet2 to sheet1 | Excel Programming | |||
Hybrid Mode
