Jul 18 2022 11:37 AM
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.
Jul 18 2022 11:52 AM
=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.