Search in list of pairs or dictionary

I have a structure as follows:
key1: A, B, C
key2: A, C, D, E
key3: D, E, F

Now I want to search for say value D and display key2, key3.

How do I implement this best?

If the values are Apple, B, C and so on, it would be great to find “App” in Apple as well (as in the “contains text piece” block, but instead of true I would like the corresponding keys).

Hope it is understandable what I would like to do.

Thanks in advance for your help!

Here’s my take on this, using reusable filter procedures and a text-search-friendly data structure …
blocks (1) blocks (2)

CONTAINS disct_search.aia (2.8 KB)


per ABG example:

Thank you very much for your very helpful and immediate answers!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.