software

I am trying to do an if/then function to see if there are duplicates on 2
different sheets in a table but cannot find the function which is correct.
First sheet name is Active and the column name is Name. Second sheet name is
Therapy and the column name is Name. I want a function that give me a quot;truequot;
if the name in the sheet active is also listed in the sheet Therapy.

Thanks for any help.


Brenda,

There may be an easier way but this worked.

=IF(ISERROR(MATCH(A2,Therapy!$A$1:$A$4,0)),quot;Falsequot; ,quot;Truequot;)

I put this in B2 and copied down the list of lookup values in the sheet
named Active.

HTH,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=498017Worked perfect, thank you very much!

quot;SteveGquot; wrote:

gt;
gt; Brenda,
gt;
gt; There may be an easier way but this worked.
gt;
gt; =IF(ISERROR(MATCH(A2,Therapy!$A$1:$A$4,0)),quot;Falsequot; ,quot;Truequot;)
gt;
gt; I put this in B2 and copied down the list of lookup values in the sheet
gt; named Active.
gt;
gt; HTH,
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=498017
gt;
gt;