SEARCH Function in Excel, Google Sheets, Airtable & Notion
SEARCH works like FIND but ignores upper and lower case and accepts the wildcards * and ?. SEARCH("report", "Q3 Sales Report") is 10.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | SEARCH(find_text, within_text, [start_num]) |
| Google Sheets | ✔ Built in | SEARCH(search_for, text_to_search, [starting_at]) |
| Airtable | ✔ Built in | SEARCH(stringToFind, whereToSearch, [startFromPosition])Returns empty (not an error) when not found, and has no wildcards. To be sure case is ignored, the tester lowercases both sides: SEARCH(LOWER(find), LOWER(text)). |
| Notion | ≈ Workaround | if(contains(lower(text), lower(find)), length(split(lower(text), lower(find)).at(0)) + 1, 0)No SEARCH in Notion. Lowercase both sides and measure the text before the first match. For a simple yes/no, contains(lower(text), "word"); for wildcard-style patterns, test() with a regular expression. |
| Excel | =SEARCH("report", "Q3 Sales Report") | open excel.new ↗ |
|---|---|---|
| Google Sheets | =SEARCH("report", "Q3 Sales Report") | open sheets.new ↗ |
| Airtable | SEARCH(LOWER("report"), LOWER("Q3 Sales Report")) | |
| Notion workaround | if(contains(lower("Q3 Sales Report"), lower("report")), length(split(lower("Q3 Sales Report"), lower("report")).at(0)) + 1, 0) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
find_text | The text to look for. Not case-sensitive. ? matches one character, * any run of characters; ~* finds a literal asterisk. |
within_text | The text to search in. |
[start_num] optional | Character position to start from. Defaults to 1. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=SEARCH("report", "Q3 Sales Report") | 10 | Case is ignored. | |
=SEARCH("r?port", "Q3 Sales Report") | 10 | ? matches any single character. | |
=ISNUMBER(SEARCH("urgent", A2)) | TRUE / FALSE | The standard “contains” test. | |
=SEARCH("x", "abc") | #VALUE! | Not found is an error; wrap in IFERROR if needed. |
Examples use Excel / Google Sheets syntax unless noted.
How SEARCH works
SEARCH is the one to use for “does this cell mention…” checks, because people rarely type case consistently. =ISNUMBER(SEARCH("refund", A2)) returns TRUE whether the note says Refund, REFUND or refund, and works well inside IF, FILTER or conditional formatting. Use FIND only when case matters.
Wildcards make SEARCH more flexible: ? stands for one character and * for any number, so SEARCH("inv*2024", A2) matches “INV-0042 2024”. To look for a real ? or *, put a tilde in front: SEARCH("~?", A2). For anything more complex, use REGEXMATCH.
Airtable's SEARCH returns an empty value when the text isn't found (FIND returns 0), and it has no wildcards. Lowercasing both arguments guarantees a case-insensitive match. Notion has no position function, but contains(lower(prop("Notes")), "refund") covers the common yes/no case.
Frequently Asked Questions
- What is the difference between SEARCH and FIND?
- SEARCH ignores case and allows
*and?wildcards. FIND is case-sensitive and treats every character literally. Both return #VALUE! when nothing is found in Excel and Google Sheets.