解决方案

以下公式应能给出你想要的结果。向右拖动。

=XLOOKUP(M3, B3:B20,B3:B20,, 1, -1)

（数据结构与我在上一张截图中所示的相同）

你也可以尝试这个公式：

=ARRAYFORMULA(LET(
   fl, FILTER(B3:K, NOT(BYROW(B3:K = "", LAMBDA(x, AND(x))))), 
 fcol, CHOOSECOLS(fl, 1),
 scol, CHOOSECOLS(fl, 2),
 tcol, CHOOSECOLS(fl, 3),
       FILTER(CHOOSECOLS(fl, {4,5,6,7,8,9,10}), BYROW(CHOOSECOLS(fl, {1,2,3}), LAMBDA(a, JOIN(",", a))) =
              JOIN(",", HSTACK(
                   XLOOKUP(M3, fcol, fcol,, 1, -1),
                   XLOOKUP(N3, scol, scol,, 1, -1),
                   XLOOKUP(O3, tcol, tcol,, 1, -1))))
))