请教各位大能如何把一个表格中的多个子表格数据筛选到一个表格中?答:B3=IF(ISERROR(INDEX($A$9:$D$23,MATCH($A3,$A$9:$A$23,0),MATCH(B$2,OFFSET($A$9,MATCH($A3,$A$9:$A$23,0)-2,,,4),0))),"",INDEX($A$9:$D$23,MATCH($A3,$A$9:$A$23,0),MATCH(B$2,OFFSET($A$9,MATCH($A3,$A$9:$A$23,0)-2,,,4),0)))向下...