Comparing Column Values [Solved/Closed]

Question

Comparing Column Values [Solved/Closed]

Report

ExcelHelp - Apr 5, 2010 at 08:57 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- 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?

Comparing Column Values
Comparing five column values in a row ✓ - Forum - Office Software
Comparing columns in two different excel sheets and if they match copying third column ✓ - Forum - Excel
Excel - Compare column A & B give results in column C - How-To - Excel
Excel - Moving row values into column values - How-To - Excel
Comparing columns and returning value ✓ - Forum - Excel

2 replies

Ask a question

ehlblackstar · Answer 1 · 2010-04-05T10:49:05-0400

Answer 1 / 2

ehlblackstar

Posts: 12
Registration date: Monday April 5, 2010
Status: Member
Last seen: November 2, 2018

Apr 5, 2010 at 10:49 AM

Try typing =EXACT(A3:B3) in column C.
Hope it could help you...

rizvisa1 · Answer 2 · 2010-04-05T16:20:35-0400

Answer 2 / 2

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
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

Comparing Column Values [Solved/Closed]

2 replies

Your reply

Subscribe To Our Newsletter!