How do I find a mismatch in a column in Excel? While Conditional Formatting (as explained above) can help you find mismatched data easily, the VLookUp function allows you to compare individual cells.