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.

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In