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

Google Sheets is a web-based spreadsheet application that’s equivalent to Microsoft Excel. If you’ve never used Sheets (or Excel, for that matter), you might need help getting started. In this ...

Manually sifting through a giant Google Sheets file isn't efficient. A built-in search function can look through all your open documents in seconds. In addition to Google's Find function, there are ...