You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.

If you’ve added the same data more than once by mistake on a spreadsheet or you’re simply looking to find duplicate data, Google Sheets lets you highlight them.

To use VLOOKUP to find data in another Excel workbook requires multiple workbooks' relevant data. Once you have them, follow these steps.

Note that it is also possible to use VLOOKUP in Excel to find duplicate data. Getting to grips with these advanced features turns what appears to be a plain grid of numbers into a powerful tool.