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

Microsoft Excel's VLookup formula permits you to search large spreadsheets for specific data, one of Excel's lookup and reference functions. You can use VLookup between sheets within an Excel ...

Google Sheets has a built-in MATCH function, which you can use to search for anything in a defined cell range. The formula's syntax is =MATCH (key, range, type).