VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.

Matching One Column Data with Another in Excel. If you don't have a keen eye and a perfect memory, you probably can't spot all the differences between two data columns in a large worksheet.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.