Look Up and Dynamic Array

kheldar 

The problem is that both RawMMP[Name] and A2# are arrays.  The first problem is that the result of such a comparison is ambiguous.  If we assume that each element of the spilt array A2# is to be compared at a time, the result would be an array of overlapping filtered ranges, so still no use.

You either need to write a separate formula for each element of A2# and space them out, or you turn to more advance programming techniques.

= MAP(distinctName#,
      LAMBDA(name,
          TEXTJOIN(", ",,
              FILTER(RawMMP[Duration1],RawMMP[Name]=name,"na")
          )
      )
  )

This takes each element of A2# (I have assumed it to be a list of distinct names) and produces a filtered array.  I used TEXTJOIN to turn the filter array result into a comma-separated list.  MAP brings the lists together as an array of lists.

To put the result together as a composite list required advanced techniques which I have already discussed today within another post.