Excel表格寻找解决方法

表2=INDIRECT(TEXT(SMALL((IF($2:$2=$A$3,ROW($3:$3)*1000+COLUMN($3:$3),"")),COLUMN(A$1)),"r0c000"),)数组公式，右拉。表3=INDIRECT(TEXT(SMALL((IF($2:$2=$A$4,ROW($3:$3)*1000+COLUMN($3:$3),"")),COLUMN(A$1)),"r0c000"),)数组公式，右拉。注：前提是三张表在一个[工作表]中