Going through List Column to create a new virtual Column List

[Nicolas_St-Laur]

So here is my Question.

Is there a good way to go through a List in each Row, and for each Item in that List, Create a new list of Text Items from a different table that contains the Items in the Original List?

So, what I want is this:

Is contained in TestID List but the ERGs are contained in a different table.

So I tried this equation:

IN([_THISROW].[ERG List],TestID List[ERG List] )

Please, any help would be greatly appreciated. I can answer any questions if this is hard to understand.

THanks,