Formulas > =SEARCH()

How To Use SEARCH() Function in Google Sheets


Returns the position at which a string is first found within text.

Common questions about the SEARCH Formula:
What is the SEARCH Formula?
How do I use the SEARCH Formula?
What are the arguments used in the SEARCH Formula?

How can the SEARCH Formula be used appropriately?
The SEARCH Formula can be used to quickly and accurately return the position of a specific character or string within a given cell, range, or string of text.

How can the SEARCH Formula be commonly mistyped?
Common mistakes when typing out the SEARCH Formula can include incorrect purpose argument values, mistaking which arguments are search_result and which are search_key, and writing out the wrong number of arguments.

What are some common ways the SEARCH Formula is used inappropriately?
Common incorrect uses of the SEARCH Formula include attempting to use the formula on non-text data, attempting to search through empty cells, and using the wrong arguments in the wrong order.

What are some common pitfalls when using the SEARCH Formula?
Common pitfalls when using the SEARCH Formula can include attempting to return a range of values instead of a single value, not considering the possibility of multiple instances of the search argument, and unintentionally searching through hidden cells or text.

What are common mistakes when using the SEARCH Formula?
Common mistakes when using the SEARCH Formula can include mistyping the formula, forgetting to include the leading character in the formula for the search_key argument, and not setting a proper parameter for the search_result argument.

What are common misconceptions people might have with the SEARCH Formula?
Common misconceptions about the SEARCH Formula include thinking that it can be used to modify existing data instead of just finding information within existing data, thinking that the formula can return multiple values, and assuming that the SEARCH Formula can search in multiple worksheets or spreadsheets without specifying which one to target."

How To Actually Use SEARCH() in Sheets

SEARCH(search_for, text_to_search, [starting_at])

2Better Sheets Tutorials

Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets? Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()
Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.

Learn more about the SEARCH() formula:

Text Search in Google Sheets

In this video, I demonstrate how to find instances where specific key words are present in cells, using Google Sheets. The formula that is used is: =IF(ISNUMBER(SEARCH("Text",Cell to Search)),"Text if found", "Text if not found")

Generate a SEARCH() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.