Lookup array of text on many Column

I @alcampopiano and thank for gidance i was not aware of this syntax (zip and cycles) very interesting !!
I think we are close to but not yet functionnal. have play around with the example you give me. very interesting to dynamic create collumn.

The issus is if i have “c z” in search field i would like the 3e line to match. cause they have the c on the name collumn and the z on the product collumn. but the any_of dont take on consederation the Array of search string (search string split by space) it why i loop in my exemple.

Then on summary each word on the search string need to match on row but is not neccessary match on same collumn.

Other thing i dont know how to manage that, i my exemple the “client” collumn is a link row. with a collumn name “Nom” how to search on the Nom [Client][Nom] string in that type of search ?

Thank for the advice on that issue, i appreciate the time you take to do complete answers is very welcome :slight_smile:

EDIT: Just want to add dont hesitate to ask question if you dont understand my question, im far away form perfect on english :slight_smile: