Text contains from Cell

[TH]

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

[Sho]

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?

[th21]

Thank you for your reply.

In terms of results I looking to get TRUE/FALSE

[Sho]

Then how about this

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