Try...

=OR(EXACT(B2,A1:A5))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Muks" wrote:

I am using EXACT to compare a cell value with series e.g. =EXACT(B2,A1:A5).
It gives me TRUE only when B2=A2 and FALSE even though B2=A4.

What may be the issue? Pls suggest.

Thanks in advance.

Muks