Find common text between another modules without List

Hi, I want to find common text between another modules.

I have two modules A&B.

Each module has order Number and Product(Text format)

I want to find Product(ModuleB) in ModuleA. It's Common Text.

In this case, we can find product by finditem formula, by making product List.

But I don't want to use product List, because it needs to make List.

Is there any find common text without List?

Answers

  • Why not create a product list for module B? It'll give you one of the more efficient ways of answering the query.

  • I wonder why you don't simply convert product into a list. Anyways, the alternate approach I have shared below is not relatively more efficient, because of the textlist function. But sharing since you are interested to achieve the result using only TEXT format.