=VLOOKUP("张三",INDIRECT("[统计表.xlsx]表"&NUMBERSTRING(ROW(A1),1)&"!a1:b30"),2,)下拉原公式中 $A$1:$A$30,2,应改为$A$1:$B$30, 2, 或者 改为 $A$1:$A$30,1, 否则语法错误
复杂了就交给代码
