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

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...
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!