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.