Previous Topic Next Topic

Comparing Column Values

[Solved/Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
I am trying to compare two columns to see if they carry the same values - column A has 556 values (starling at line 3), and column B has 69 values (starting at line 3)- I want to see if the values in column B match the values in Column A;

I used the following formula but it does not seem to work:
=VLOOKUP($A3,$B$3:$B$69,2,FALSE)


Does anyone know why this is not working?


2 replies

Answer 1 / 2
Posts
12
Registration date
Monday April 5, 2010
Status
Member
Last seen
November 2, 2018
Try typing =EXACT(A3:B3) in column C.
Hope it could help you...
Answer 2 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
In case you are wondering why your formula is not working
=VLOOKUP($A3,$B$3:$B$69,2,FALSE)

"2" refers to the second column in range $B$3:$B$69. As you can see, there is no second column in the range. There is only one column and that is column B
Ask a question