Hi there, @casheets123… if I understand your post correctly, I have done what you described by using an advanced filter to compare two lists with the intersect with option, and then you do a :count > 0 at the end of the query. So, the query determines if there is any intersection between the two lists by doing a count of like items and stopping as soon as that count is greater than 0. Hmm, you might even be able to do something with weighting by requiring the count of like items to be greater than some number greater than 0, but I would have to play around with that idea to know for sure.
Here is an example of such a query that I posted in another thread…
Hope this helps.
Best…
Mike