Forum Discussion
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 recomme...
=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.