Comparing Column Values
Solved/Closed
ExcelHelp
-
Apr 5, 2010 at 08:57 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 5, 2010 at 04:20 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 5, 2010 at 04:20 PM
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?
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?
Related:
- Comparing Column Values
- How to delete column in word - Guide
- Based on the values in cells b77 b88 ✓ - Excel Forum
- How do i auto number a column in excel? ✓ - Excel Forum
- Tweetdeck expand column - Guide
- Based on the values in cells b77 ✓ - Excel Forum
2 responses
ehlblackstar
Posts
11
Registration date
Monday April 5, 2010
Status
Member
Last seen
November 2, 2018
Apr 5, 2010 at 10:49 AM
Apr 5, 2010 at 10:49 AM
Try typing =EXACT(A3:B3) in column C.
Hope it could help you...
Hope it could help you...
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 5, 2010 at 04:20 PM
Apr 5, 2010 at 04:20 PM
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
=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
