Learn how to add a search bar with contains substring in Google sheet. We will also answer, how do you check if a string contains a substring in Google sheet and how do I sum a cell contains a substring in Google sheet. We'll also be addressing if there a contain function in Google sheet? And finally, how do I find cells containing string in Google Sheets? br br Is there a contains function in Google Sheets? br Yes in a round about ways. You will have to use this formula. br =IF(REGEXMATCH(A1, "rabi"), 1, 0) br Returns 1 if cell A1 contains substring "rabi" br br Look these are the steps outlined on the video. br br Here's how you can create a search tool in Google Sheet, similar to this. br br Regular Search Bar br 1) Highlight data set br 2) Format ~ Conditional Formatting br 3) Custom formula is br 4) =$A4=$B$1 br 5) Done br br Partial Match Search Bar br 1) Highlight data set br 2) Format ~ Conditional Formatting br 3) Custom formula is br 4) =IF(AND(REGEXMATCH($A4, $B$1),NOT(ISBLANK($B$1))), 1, 0) br 5) Done br br Let's break down the formula shown below br =IF(AND(REGEXMATCH($A4, $B$1),NOT(ISBLANK($B$1))), 1, 0) br br - REGEXMATCH($A4, $B$1) checks if the value in cell A4 matches the regular expression pattern in cell B1. It returns TRUE if there's a match and FALSE otherwise. br - ISBLANK($B$1) checks if cell B1 is empty. It returns TRUE if the cell is empty and FALSE if it contains any value. br - NOT(ISBLANK($B$1)) negates the result of ISBLANK($B$1). It returns TRUE if cell B1 is not empty and FALSE if it's empty. br - AND(REGEXMATCH($A4, $B$1), NOT(ISBLANK($B$1))) checks if both conditions are true using the logical AND operator. It returns TRUE if both conditions are true and FALSE otherwise. br - Finally, the IF function evaluates the result of the AND function. If the result is TRUE, it returns 1; otherwise, it returns 0.