Clarification needed if possible. Whats the...

expressions
(geoff gardener) #1

Clarification needed if possible.

Whats the difference between the expressions CONTAIN and IN?

I am looking for the function to search for a word in a column, but it may be part of several words in a list.

Thanks in advance.

(Levent KULAÇOĞLU) #2

@geoff_gardener In a list of: {“This is Geoff”, “test1”}

IN(“Geoff”,LIST(“This is Geoff”, “test1”)) returns FALSE

however

CONTAINS(LIST(“This is Geoff”, “test1”),“Geoff”) returns TRUE