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