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.