函数题目！

=LET(h,A2:A18,i,B2:B18,j,C2:C18,f,LAMBDA(z,DROP(REDUCE(0,z,LAMBDA(x,y,VSTACK(x,y&0&FILTER(i,h=TEXTAFTER(0&y,0,-1),"")))),1)),REDUCE({"出货产品","最终材料","数量","日期","材料路径"},E2:E5,LAMBDA(a,b,VSTACK(a,LET(c,MAP(f(f(f(f(f(b))))),LAMBDA(w,TEXTJOIN("->",,TEXTSPLIT(w,0)))),d,TEXTAFTER(c,">",-1),CHOOSE({1,2,3,4,5},b,d,MAP(c,LAMBDA(q,LET(k,DROP(TEXTSPLIT(q,"->",,1),,1),PRODUCT(IFNA(XLOOKUP(b&k,h&i,j),VLOOKUP(k,B1:C18,2,))))))*OFFSET(b,,1),OFFSET(b,,2),c))))))

=REDUCE({"出货产品","最终材料","数量","日期","材料路径"},G2:G5,LAMBDA(w,z,VSTACK(w,LET(r,T(z:E5),s,"->",f,LAMBDA(z,DROP(REDUCE(0,z,LAMBDA(x,y,VSTACK(x,y&s&FILTER(C2:C18&s&B2:B18,A2:A18=TEXTAFTER(s&y,s,-1),"")))),1)),t,TEXTSPLIT(f(f(f(f(f(f(r)))))),"->-"),CHOOSE({1,2,3,4,5},r,TEXTAFTER(t,s,-1),MAP(t,LAMBDA(p,PRODUCT(TOCOL(--TEXTSPLIT(p,s),3))))*N(z:F5),z,REGEXREPLACE(t, ">\d+-", ""))))))