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

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.