How to Use VLookup With Different Sheets on Excel. Excel's VLOOKUP function searches an array of cells for data you choose, returning data from the cell next to the one that it finds.

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.