Set up correct function (IF, CONTAINS)

alexxalambrakiss

Hi, community.

I need some help)

Here is example. I need function that works like that:

1) take text from List

2) compare to Main

3) if text in Main have on of the word from List, return "yes"

Thanks all😊

Ipshita

Hi @alexxalambrakiss ,

Try this - hope this helps.

Cheers,

Ipshita

Volodymyr L

Sorry, but we tried this formula. Alex showed the same one. It doesnt work if the second column has any extra symbol!

For example: Tree -- Tree A

This way it doesn`t work