Search string on input table

1

Hy. I need to search string on input table. I need to use a function similar to select by look up table.
I tried using some funcions.
Can you help me?
On attach an example of input table, on which , for example, i need to search and select string “corelayout”.

Off course i can’t use filter.

Thks
DavideINPUT TABLE.xlsx (60.1 KB)

2

Hi Davide,

it seems like the “Match” action should do it. See the example below. You can add more search keywords to the lookup table (Table 1).

Once matching is done, not matched rows can just be filtered out.

match-search.morph (2.9 KB)

image
image.png1391×643 37.1 KB