Thanks Fred however, that only works if the number in b and f are on the same
line.
I want the function to show me that if the number in say f36 is in and cell
in column B lines 36 thru 40.
Any more suggestions. I'm at a total loss because I do not really
understand how to write functions.
--
mrs luke


"Fred Smith" wrote:

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