How to compare columns in Microsoft Excel As stated, we can use the Excel VLOOKUP function to find and match different data or find differences in two columns.

Open the Excel spreadsheet containing the columns you want to compare. Select the data in both columns, excluding the heading. In the Styles section in the Home tab, click on Conditional Formatting.