Forum Discussion

AminefromConvelio's avatar
AminefromConvelio
Copper Contributor
Jul 18, 2022

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

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. 

Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jul 18, 2022

    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.

     

Resources