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.

If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.