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

In Excel a "Vlookup," short for vertical lookup, is a formula used to return a value from a table of data. For example, you might want to add a column to a customer information spreadsheet that tells ...