Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

Match The Two Columns Row-By-Row With Comparison Operators If you need to compare two columns in Excel row-by-row instead of the entire column at once, use comparison operators.

How to compare Microsoft Excel columns with conditional formatting Use conditional formatting to highlight column and row differences with colors or other formatting options.