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
Related:
- Comparing Column Values
- How to delete column in word - Guide
- Tweetdeck expand column - Guide
- Vba select column by name ✓ - Excel Forum
- Excel count occurrences of string in column - Guide
- Based on the values in cells b77 b81 c77 - 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
