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 "true"
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)),"False" ,"True")

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

HTH,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=498017

Worked perfect, thank you very much!

"SteveG" wrote:


Brenda,

There may be an easier way but this worked.

=IF(ISERROR(MATCH(A2,Therapy!$A$1:$A$4,0)),"False" ,"True")

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

HTH,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=498017