Garry,
My limited testing worked i.e. if returned TRUE if column A
range matched B3.

Extraneous blanks (or "hidden" characters) on either set of data will cause
a mismatch.

Look at TRIM/CLEAN functions to remove this type of problem.



"Garry" wrote:

I'm trying to compare the values in two columns by using this formula
{=OR(EXACT(B3, $A$2:$A$394))} however, it does not seem to be picking up when
the cells contain the same information. It just returns a FALSE answer.
--
Garry