Pipelines - 'is contained within' condition

Is there any trick or workaround to use a condition in pipelines that is essentially, 'is contained in' (verses, 'contains')?

Use Case:

I have a table with a list field of project numbers. [Project Numbers List].

I want pipelines to search all records in a table and return: Records where [Project Number] is contained in [Project Numbers List]. The list is in an unrelated table, so I can't simply create a formula checkbox or anything.

It's quite simple to go backwards, if I needed to search where [Project Numbers List] contains [Project Number]. Any tricks for my use case?

------------------------------
Mike Tamoush
------------------------------