Google Sheets has a built-in MATCH function, which you can use to search for anything in a defined cell range. The formula's syntax is =MATCH (key, range, type).

1. Open Google Sheets in a web browser and click the cell in which you want the formula's answer to appear. 2. Find the Formula Bar above the spreadsheet. It's a blank field to the right of the Fx ...