calculated column to display comma separated values as the text lookup value for each value

This is my interpretation and Power Query solution:

CSTV query code:

let
    Source = Table2,

    // Get nested lists of ID numbers
    SplitToIDNumbers = Table.TransformColumns(Source,{},each List.Transform(Text.Split(_,","),Number.From)),

    // Add index as a grouping for the IDs after expansion
    AddedIndex = Table.AddIndexColumn(SplitToIDNumbers, "Index", 0, 1),
    ExpandedIDs = Table.ExpandListColumn(AddedIndex, "IDs"),

    // Get the Text Values from table1
    MergedWithTable1 = Table.NestedJoin(ExpandedIDs,{"IDs"},Table1,{"ID"},"NewColumn",JoinKind.LeftOuter),

    // Expand the nested tables
    ExpandedTextValues = Table.ExpandTableColumn(MergedWithTable1, "NewColumn", {"Text Value"}, {"Text Value"}),

    // Use Transform - Group By to create base code (e.g. use group function "Sum"  for the text values, then adjust the code to Text.Combine
    Grouped = Table.Group(ExpandedTextValues, {"Index"}, {{"Text Values", each Text.Combine([Text Value],","), type text}}),

    RemovedIndex = Table.RemoveColumns(Grouped,{"Index"})
in
    RemovedIndex

: