Use Countif to do what you want, as in:

=IF(countif(F36:F40,b38)0,"on report","not on report").

Regards,
Fred

"Mrs Luke" wrote in message
...
I am trying to do a function that will look for and tell me if there is or
is
not a duplicate number on a spread sheet.
EX: column B has numbers in accending order.
column F has numbers in accending order. Some of these numbers will
be duplicates of some numbers in column B but not necessarily on the same
row.
I want a function in say column J that will tell me if a number in cell F1
is found in any cell in coumn B.
I tried the Logical IF function but that only seemed to work the the
numbers
were on the same row. I wrote is as =+IF(B38=F36:F40,"on report","not on
report").

Can anyone help me?
--
mrs luke