View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brenda
 
Posts: n/a
Default Compare Sheet Cell to Sheet Column

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.