Compare 2 Columns You can easily compare the contain of 2 columns in Excel with the function VLOOKUP. You can also change the color for the missing values