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
- Excel copy column from one sheet to another automatically - Guide
- Comparing columns in two different excel sheets and if they match copying third column - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Excel count how many times a value appears in a column ✓ - Office Software Forum
- How to compare two columns and return values from the third ✓ - 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