根据年龄和数据，查询分数

=LET(t,OFFSET($F$1,1,MATCH(B2,$F$1:$V$1,)-1,14,8),u,TAKE(t,-13,1),a,OFFSET(u,,MATCH(--SUBSTITUTE(C2,"岁",),--SUBSTITUTE(TAKE(t,1,-7),"岁",),1)),b,MAP(a,LAMBDA(x,ABS(-LOOKUP(9^9,-RIGHT(x,ROW($1:$76)))*1))),c,MAP(a,LAMBDA(y,ABS(-LOOKUP(9^9,-LEFT(y,ROW($1:$76)))*1))),r,SORT(HSTACK(u,b),2,1),IF(D2>MAX(b),"10分",IFNA(IF(D2<=MIN(b),"100分",LOOKUP(1,0/((D2>=b)*(D2<=c)),u)),LOOKUP(1,0/(D2>TAKE(r,,-1)),TAKE(r,,1)))))
这是我写的