Combining If and Concatonate
I'm really new at doing functions but want something that says If A1 = A2,
then Concatonate C1 + C2. How do I set it up for this? I have a lawyer wanting a new tab of his own and I don't want to retype or copy info that others can find by looking at multiple lines. Thanks in advance for help! Lisa |
Combining If and Concatonate
Hi
Try This =IF(A4=B4,CONCATENATE(C4&D4)) These will also work the same =IF(A4=B4,(C4&D4)) =IF(A4=B4,(C4&D4),"") Regards Rajesh Mehmi "Lisa W" wrote in message ... I'm really new at doing functions but want something that says If A1 = A2, then Concatonate C1 + C2. How do I set it up for this? I have a lawyer wanting a new tab of his own and I don't want to retype or copy info that others can find by looking at multiple lines. Thanks in advance for help! Lisa |
Combining If and Concatonate
Hi,
Here is a short one =IF(A1=A2,C1&C2,"") -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Lisa W" wrote: I'm really new at doing functions but want something that says If A1 = A2, then Concatonate C1 + C2. How do I set it up for this? I have a lawyer wanting a new tab of his own and I don't want to retype or copy info that others can find by looking at multiple lines. Thanks in advance for help! Lisa |
Another Qtn: Combining If and Concatonate
Now I realize that if A4 =A3 but A4 does not = A5, I want C4&C5. I have a
list by name and for every time that the names match, I want the cell to include all parcel IDs for each name separated by a ";". When the names don't match, I want it to only include the parcel ID for that name. Since there could be an unknown number of name matches, I'm not sure that I should be using If A4=A3 now. Perhaps I should be using another kind of formula? Thanks, Lisa "Rajesh Mehmi" wrote: Hi Try This =IF(A4=B4,CONCATENATE(C4&D4)) These will also work the same =IF(A4=B4,(C4&D4)) =IF(A4=B4,(C4&D4),"") Regards Rajesh Mehmi "Lisa W" wrote in message ... I'm really new at doing functions but want something that says If A1 = A2, then Concatonate C1 + C2. How do I set it up for this? I have a lawyer wanting a new tab of his own and I don't want to retype or copy info that others can find by looking at multiple lines. Thanks in advance for help! Lisa |
All times are GMT +1. The time now is 04:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com