The match function delivers the first matching value that is found in the lookup column. I would be interested in finding all matching values found in the lookup column, and listing them.
For example, let’s say I want to extract light bulb sockets using Match (with Match Mode “Contains”). In the column “Description” I have “Light bulb E27 or E40”. In the lookup column, I have the following information:
If I perform the “match” action, E27 will be the first match, and as it has found a match, E27 will be match, and it stops there. E40 will not appear in the match result, as it has already found E27.
I’m looking for a way to get as a result “E27/E40” (so both matches separated by a delimiter), or also creating different lines for each match.
In this case I can’t use regex because I have around 380 different light bulb sockets, and it’s a list that has to be updated and maintained often, so a regex function with 380 OR delimiters (|). That’s why I prefer to use a column for all the sockets and use the Match action (with Match mode “Contains”), as I can update it in an much easier manner.
Is there something I can do here? The same thing can happen to me when I want to extract the color/s (from a long list of possible colors), the materials, etc.
Thanks a lot!