How to compare two text columns in excel for matches

 

We can use a simple formula to do this real quick.

Let’s say we have two columns data like this.

Now, we can write the formula in the C2 Cell as =A1=B1

Then Press enter and then drag the formula down until where you want the result. The columns is filled with TRUE if the value in the first column matches with value in the second column other wise FALSE.

This is the output of the formula.