0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Comparing Column Values

_

Issue

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) 

Solution

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

Note

Thanks to rizvisa1 for this tip on the forum.

0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - Comparing Column Values », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).