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