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.

SEE: 98 Excel tips every user should master (TechRepublic) How to use VLOOKUP () to compare two sets of data in Microsoft Excel The VLOOKUP () function has been the cornerstone of many Excel apps.