Hello,

I want to compare the contents of a cell with the contents of a range of
cells by using the formula OR(EXACT(B1; A1:A300))

However, the result becomes only TRUE if the match is in the first cell of
the range, i.e. A1, if the match is in any other row it becomes FALSE. I
don't know why. It should be also TRUE id there is a match, shouldn't it?

Does anybody know the reason why the function does not work properly?

Is there another simple way to perform the desired task?



Happy New Year to everbody out there



Tom