2] Find differences by comparing two columns. Another purpose for the VLOOKUP function is to find differences within two columns. This is an easy task, so let us talk about how to get this done.