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

To add a formula in Google Sheets, click the cell where you want the answer, then choose one of the hundreds of functions.

The FIND function allows you to find a text string within another. It returns the position at which a character or string begins within another text string. The output of the above function will be 5, ...