Show when cells from a column contains text presents in cells from an other columns

Occasional Visitor


I will need your help, please. 

I would like B2 to tell me if A2 contains text similar to the one present in at least one of the cells in column C.

I tried a function someone recommends but it doesn't work.


Any idea? 


I'm working on Google Sheets in French.

Thanks in advance. Capture d’écran 2022-07-18 à 20.17.30.png

1 Reply



You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. In my example WAHR and FALSCH mean TRUE and FALSE.

banane orange.JPG