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

How to Calculate a Vlookup on Excel for Loans. 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 ...

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.