Filter part of a field from another table

Hi guys,


I want to filter part of a field which is separated by a wild character. In my scenario this is separated by ";".




Filter based on the part of the field in bold.

In order to find the actual part of the field (in my case this is the "Description" field), I use the formula below:



The problem is incorporating this in my formula because, 1) I want to filter only part of the field which is easy as I use the formula above as my filtering value and 2) how do I reduce the data I want to be matched with in my field which is the hard part.

I have read the thread below that didn't work. Maybe because I'm trying to fit a nested excel formula in JET and messes up.





Please sign in to leave a comment.