How to Use SEARCH() in Google Sheets

Description

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

How To Actually Use SEARCH() in Sheets

SEARCH(search_for, text_to_search, [starting_at])

Try SEARCH yourself

In cells B1:B10, use the SEARCH formula to find the position of the word 'apple' in the corresponding cells of A1:A10. The formula should return the position number where 'apple' is found or an error if not found.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Tic Tac Toe In A Google Sheet

Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.

AND() COUNTA() FILTER() IF() IFERROR() +4 more

How to Make Hangman Game In Google Sheets

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()

COUNTA() IF() IFERROR() JOIN() LEN() +1 more

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!

Beginner

FILTER() IFNA() JOIN() SEARCH() SPLIT() +1 more

How to Filter Multi-Select Dropdown Feature

Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!

Intermediate

FILTER() SEARCH() SUM()

Transcript-matched member videos for SEARCH(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Unlock these tutorials

Learn more about the SEARCH() formula:

Generate a SEARCH() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses SEARCH(). 2 free AI generations, no signup. Members get unlimited use.

Generate a SEARCH() formula