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

Occasional Visitor

Hello, 

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

@AminefromConvelio 

=ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH($C$2:$C$5,A2)),0))

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