View original (French)

If cell contains...

Solved
Ludo_du33 -  
 Ludo_du33 -
Hello everyone,

I am working on a Google Sheets spreadsheet and I can't find the formula that suits my needs..

Basically, I would like to display a result in one cell based on the adjacent cell if it contains a part of a text, but this text is also in another cell..

For example: If A1 contains BETWEEN A2 Then A3.

I don't know if it's clear.. I know how to do it with text (by using "*value*") but not with the content of another cell.. I am missing the equivalent of "*...*" for cells.

Feel free to ask if you need further information.

Thank you very much!

Configuration: Windows / Chrome 60.0.3112.113

3 answers

Answer 1 / 3
gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 734
 
Hello,

With this formula, you should get your result: 
=IF(NOT(ISERROR(SEARCH(A2,A1))),A3,"")

--
Always zen
Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
9