Jenny,
..
Your formula works for me, I entered it with shft-ctrl-enter when complete.
Excel put thebrackets around the array formula for me.
{=OR(EXACT(A1,B1:B1000)) } Tested it and everything.

Beege


"JennyJeneralGraves" wrote in
message ...
I am trying to compare 2 columns of data to find matches.
I want to take cell A1 and look in range B1 to B1000 to see if the value
in
A1 exists any of the cells in that range.
Excel Help says I should use the following formula:
=OR(EXACT(A1,B1:B1000))
This formula returns the value "FALSE" even if I know the value in A1 has
a
match in the B range.
When I do not use the range and compare the two matching cells, it returns
"TRUE".
Ex.
=OR(EXACT(A1,B230))
According to Excel Help, this should check each cell and look for a match.
Why does it appear to have a problem with arrays?
Thank you.