Text contains from Cell

I have 2 tables.

Table 1 contains column A

Table 2 contains column B

Now, I want to check if the text appears in Table 1 also appears in a specific cell in Table 2.

For example:

Table 1 Table2

text text, text6, text99

text3

text4

So in this example I will get a TRUE only for 'text' since it's located on Table 2

+21

With this formula, only the matched portion can be replaced by TRUE

IF({A},
  REGEX_REPLACE(
    {B},
    "\\b(" & {A} & ")(, |$)",
    "True, "
  ),
  {B}
)

What return value do you want?

With this formula, only the matched portion can be replaced by TRUE

IF({A},
  REGEX_REPLACE(
    {B},
    "\\b(" & {A} & ")(, |$)",
    "True, "
  ),
  {B}
)

What return value do you want?

Thank you for your reply.

In terms of results I looking to get TRUE/FALSE

+21

Then how about this

IF({A},
  REGEX_MATCH(
    {B},
    "\\b(" & {A} & ")(, |$)"
  ),
  FALSE()
)

Sign up