How To Compare 2 Columns In Excel For Matches

This step by step tutorial shows you how to compare 2 columns in Excel. We start with simple tactics to identify when cells are equal and count the number of instances. Then we move to advanced tactics and finish with methods for determining why cells do not equal when they should.

⌚️ Timestamps
0:00 Easiest way to compare columns
0:30 Count number equal cells
1:10 Intro
1:28 IF to compare columns
2:11 VLOOKUP
3:39 VLOOKUP IFERROR
4:20 VLOOKUP ISERROR
4:47 When cells do not match but they should
6:12 Thank you

Purchasing through this affiliate link gives me a small commission to support my channel -- the price to you is the same.

👍 Like

📚 Credit & Inspiration: