thanks, will this also work if the target cell is not in the same row as the
list that I am comparing it to?

"Gary''s Student" wrote:

> Use the MATCH() function. It will tell you both if its there and where it is.
> --
> Gary's Student
>
>
> "Danbmarine" wrote:
>
> > I would like to see if one cell is equal to any other cell in an entire row.
> > The row contains over 10,000 cells of data how can I insert a formula to do
> > this?