You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.
In our Google Sheets review, we examine the platform’s capabilities and how it compares to Excel and other top spreadsheet applications.
To add a formula in Google Sheets, click the cell where you want the answer, then choose one of the hundreds of functions.