You can use REGEXMATCH:
=IF(REGEXMATCH(A1, "sites"), 1, 0)
REGEXMATCH returns true if the first argument matches the regular expression given by the second argument. As long as the second argument has no regex special metacharacters (^ $ \ . * + ? ( ) [ ] { } |), this returns true if that argument is a substring of your string.
Top answer 1 of 11
198
You can use REGEXMATCH:
=IF(REGEXMATCH(A1, "sites"), 1, 0)
REGEXMATCH returns true if the first argument matches the regular expression given by the second argument. As long as the second argument has no regex special metacharacters (^ $ \ . * + ? ( ) [ ] { } |), this returns true if that argument is a substring of your string.
2 of 11
31
If you, as Ryan Shillington suggests, want to know the number of cells within a range that has "sites" in it, you might try:
=COUNTIF(A1:A100;"*sites*")
The * acts as a wildcard notion, so it will look for a match anywhere within the cell, not just an exact match for the whole cell.
I've also done this with a cell reference instead of "sites", but then you have to add wildcard-asterixes to the text in the cell.
Coefficient
coefficient.io › home
IF CONTAINS Google Sheets: Mastering Conditional Data Searches
February 20, 2024 - While Google Sheets lacks a direct “IF CONTAINS” function, a clever mix of “IF” with “REGEXMATCH” or “SEARCH” can get the job done.
is there a formula to check if a cell contains certain text? - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
Is there a if text contains vs if text exact function? Instead of =IF(C1="Store 1","Arizona" I'd like it to just look for "store" so it would find store 1, store 10, and store 25.
Yes: =IF(REGEXMATCH(C1,"Store"), "Arizona", ...) will work for any cells containing "Store". If not all the cells containing "Store" in column C are located in Arizona, then it would probably be better to use a lookup table, as arnoldsomen mentioned, although I would recommend trying XLOOKUP first since it is more flexible. More on reddit.com
6
3
April 29, 2023if statement - Google Sheets - IF cell contains certain text (or texts) then return values - Stack Overflow
I've been searching all over and can't get this right. I am trying to create an alert that returns a word or words when certain words are found in a cell. I want the formula to search for specific ... More on stackoverflow.com
IF formula with 3 values/conditions
And if I need to add another condition to the formula =IFS(A1<5,0.1,A1<9,0.12,A1>=9,0.15), specifically: if cell C1 contains text "Individual", then value will be 60%. How can I combine it so the cell B1 will show me 60% if text "Individual" in cell C1? :) thank you! More on reddit.com
8
1
January 30, 2023Does Coefficient work with both Google Sheets and Excel?
Yes, Coefficient supports both Google Sheets and Microsoft Excel. You can install Coefficient from the Google Workspace Marketplace for Sheets or from Microsoft AppSource for Excel.
coefficient.io
coefficient.io › home
IF CONTAINS Google Sheets: Mastering Conditional Data Searches
What is Coefficient's AI Sheets Assistant?
AI Sheets Assistant is Coefficient's AI-powered feature that helps you build formulas, create charts, generate pivot tables, and build entire dashboards using natural language commands in Google Sheets. Unlike generic AI assistants, it's context-aware and creates native Google Sheets objects that are live and editable. It understands your spreadsheet's layout and data structure to provide accurate, actionable results.
coefficient.io
coefficient.io › home
IF CONTAINS Google Sheets: Mastering Conditional Data Searches
Which business systems does Coefficient integrate with?
Coefficient integrates with 100+ systems across multiple categories: CRMs (Salesforce, HubSpot), databases (MySQL, PostgreSQL, Snowflake), accounting software (QuickBooks, Xero, NetSuite), BI systems (Looker, Tableau), marketing platforms (Google Analytics, Facebook Ads), payment systems (Stripe), ecommerce (Shopify), and more. Popular integrations include Salesforce, HubSpot, QuickBooks, Google Analytics, Snowflake, Airtable, and Notion.
coefficient.io
coefficient.io › home
IF CONTAINS Google Sheets: Mastering Conditional Data Searches
20:28
Find or check if a cell contains text from a list of values in ...
00:52
If Cell Contains Formula in Google Sheets - YouTube
03:52
IF CONTAINS in Google Sheets - YouTube
03:17
How to Use IF CONTAINS in Google Sheets - YouTube
06:58
How to Search If Cell Contains in Google Sheets - YouTube
Dokin
dokin.co › blog-posts › if-contains-in-google-sheets---easy
IF CONTAINS in Google Sheets - Easy! - Dokin
January 19, 2024 - ... In conclusion, even though "Google Sheets contains" functionality does not exist, there’s an easy workaround, made possible by combining the REGEXMATCH function with IF statements.
Statology
statology.org › home › google sheets: a simple formula for “if contains”
Google Sheets: A Simple Formula for "If Contains"
March 31, 2025 - The IF() combined with REGEXMATCH() formula gives you a flexible way to check if cells contain specific text in Google Sheets.
FormulasHQ
formulashq.com › home › blog › how to do an if contains statement in google sheets?
How to do an if contains statement in Google Sheets? — FormulasHQ
October 9, 2024 - Whether you need a budget tracker, ... "if contains" statement is a powerful tool that allows you to perform conditional calculations based on whether a cell contains a specific value or substring....
Google Sheets
sheetsformarketers.com › home › blog › how to use if contains in google sheets
How to Use IF CONTAINS in Google Sheets - Sheets for Marketers
April 13, 2023 - We can create our own IF CONTAINS formula with either the REGEXMATCH or SEARCH functions. These functions are similar since they both allow you to check if a cell contains a particular string of text. In this guide, we will show you how to use IF, REGEXMATCH, and SEARCH functions in Google Sheets.
Spreadsheet Point
spreadsheetpoint.com › home › formula posts › if contains google sheets: search + regexmatch
If Cell Contains Text in Google Sheets, Here Are the Fastest Formulas That Actually Work
See how to use IF CONTAINS to see whether a cell contains a specified value. Includes visuals, copy/paste formulas, and common error fixes.
Published: January 9, 2026
Google Support
support.google.com › docs › answer › 7014145
IFS function - Google Docs Editors Help
Evaluates multiple conditions and returns a value that corresponds to the first true condition. Sample Usage IFS(A1>90, "A", A1>80, "B", A1>70, "C") IFS({A1:A5} > 3, "bigger", {A1:A
Ablebits
ablebits.com › ablebits blog › google sheets tips › google sheets functions › google sheets if function – usage and formula examples
Google Sheets IF function – usage and formula examples
February 27, 2023 - You need to introduce the COUNTIF ... in formulas, there's another solution available. IF Formula Builder add-on for Google Sheets offers a visual way of creating IF statements....
How-To Geek
howtogeek.com › home › web › how to use the google sheets if function
How to Use the Google Sheets IF Function
January 7, 2020 - Replace "test" with your logical test and then replace the "value_if_true" and "value_if_false" arguments with the operation or result that Google Sheets will provide when the result is either TRUE or FALSE. In the example shown below, an IF statement is used to test the value of cell B3. If cell B3 contains the letter B, then the TRUE value will be returned in cell A3.
WPS Office
wps.com › blog › how-to-use-if-contains-function-to-check-text-in-google-sheets-with-examples
How to Use IF CONTAINS Function to Check Text in Google Sheets (With Examples)
June 1, 2026 - Yes, both IF CONTAINS and related functions are available on the Google Sheets mobile app, making it convenient to manage your data on the go.
Google Support
support.google.com › docs › thread › 296695635 › is-there-a-formula-to-check-if-a-cell-contains-certain-text
is there a formula to check if a cell contains certain text? - Google Docs Editors Community
September 14, 2024 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Ben Collins
benlcollins.com › home › ifs function in google sheets
IFS Function in Google Sheets
June 20, 2024 - Google Sheets and Workspace Updates ... it) The IFS function in Google Sheets is used to test multiple conditions and outputs a value specified by the first test that evaluates to true....
Spreadsheet Point
spreadsheetpoint.com › home › formula posts › ifs function in google sheets: easy guide
IFS Function in Google Sheets: Easy Guide for 2026 | SSP
December 27, 2022 - IFS is part of the IF statement family of functions in Google Sheets that searches if multiple parameters are true or false and returns a result based on the retrieved response. It works similar to IF, IFNA, and IF Contains.
Google Support
support.google.com › docs › answer › 3093364
IF function - Google Docs Editors Help
Google Sheets · Use functions & formulas · IF function · Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. IF(A2 = "foo","A2 is foo") IF(A2,"A2 was true","A2 was false") IF(TRUE,4,5) IF(logical_expression, value_if_true, value_if_false) logical_expression - An expression or reference to a cell containing an expression that represents some logical value, i.e.
Sheets Bootcamp
sheetsbootcamp.com › home › if statements › ifs function in google sheets (with examples)
IFS Function in Google Sheets (With Examples) | Sheets Bootcamp
February 24, 2026 - Each value in IFS can be a formula, cell reference, or calculation. For example, =IFS(F2>=500,F2*0.12,F2>=300,F2*0.10,TRUE,F2*0.08) returns a calculated commission amount based on revenue tiers. Basic Training is a free course inside a real Google Sheet that grades every formula the moment you press Enter.
Layer
golayer.io › home › if statement in google sheets: formula & examples
IF Statement in Google Sheets: Formula & Examples | Layer Blog
July 17, 2024 - The syntax for the IF function in Google Sheets is as follows: =IF(logical_expression, value_if_true, value_if_false*) logical_expression: a logical expression or test that evaluates to TRUE or FALSE.
Reddit
reddit.com › r/googlesheets › is there a if text contains vs if text exact function? instead of =if(c1="store 1","arizona" i'd like it to just look for "store" so it would find store 1, store 10, and store 25.
Is there a if text contains vs if text exact function? Instead of =IF(C1="Store 1","Arizona" I'd like it to just look for "store" so it would find store 1, store 10, and store 25. : r/googlesheets
April 29, 2023 - Yes: =IF(REGEXMATCH(C1,"Store"), "Arizona", ...) will work for any cells containing "Store".
Sheets Bootcamp
sheetsbootcamp.com › home › if statements › google sheets if function: complete guide
Google Sheets IF Function: Complete Guide | Sheets Bootcamp
How do you write an IF/THEN formula in Google Sheets? Use the syntax =IF(condition, value_if_true, value_if_false). The condition is any expression that evaluates to TRUE or FALSE.
Published: February 18, 2026
Top answer 1 of 2
1
Concatenated values
=join(", ",query({if(or(REGEXMATCH( upper($F$10),"PIZZA"), REGEXMATCH( upper($F$10),"HOTDOG")),"FOOD",);if(or(REGEXMATCH(upper($F$10),"APPLE"),REGEXMATCH(upper($F$10),"BANANA")),"FRUIT",);if(or(REGEXMATCH(upper($F$10),"COFFEE"),REGEXMATCH(upper($F$10),"COKE")),"DRINK")}, "select * where Col1 is not null"))
List Values
=query({if(or(REGEXMATCH( upper($F$10),"PIZZA"), REGEXMATCH( upper($F$10),"HOTDOG")),"FOOD",);if(or(REGEXMATCH(upper($F$10),"APPLE"),REGEXMATCH(upper($F$10),"BANANA")),"FRUIT",);if(or(REGEXMATCH(upper($F$10),"COFFEE"),REGEXMATCH(upper($F$10),"COKE")),"DRINK")}, "select * where Col1 is not null")
2 of 2
0
try:
=TEXTJOIN(", ", 1, INDEX(IFNA(VLOOKUP(SPLIT(B10, ", "), SPLIT({
{"Pizza"; "Hotdog"}&"×Food";
{"Apple"; "Banana"}&"×Fruit";
{"Coffee"; "Coke"}&"×Drink"}, "×"), 2, 0))))
