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