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.

How to Use VLookup With Different Sheets on Excel. Excel's VLOOKUP function searches an array of cells for data you choose, returning data from the cell next to the one that it finds.

Comparing two Excel sheets and combining the unique data can be done with the help of macros. There are several macros available for free that can be downloaded from the internet and tweaked according ...