Combining If and Concatonate

  • Thread starter Thread starter Lisa W
  • Start date Start date
L

Lisa W

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
 
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
(e-mail address removed)
 
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
 
Back
Top