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

Microsoft Copilot, the new AI-powered tool integrated into Excel, transforms the way you perform data lookup and merging tasks using functions like VLOOKUP and XLOOKUP. This step-by-step guide ...

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