假设表A在sheet1,在B表的
A3用公式:
=INDEX(sheet1!B$2:B$1000,SMALL(IF(sheet1!$A$2:$A$1000=$C$1,ROW($1:$998),9^9),ROW(A1)))
数组公式,按CTRL+SHIFT+回车,下拉;
B3用公式:
=INDEX(sheet1!C$2:C$1000,SMALL(IF(sheet1!$A$2:$A$1000=$C$1,ROW($1:$998),9^9),ROW(A1)))
数组公式,按CTRL+SHIFT+回车,下拉;
C3用公式:
=INDEX(sheet1!D$2:D$1000,SMALL(IF(sheet1!$A$2:$A$1000=$C$1,ROW($1:$998),9^9),ROW(A1)))
数组公式,按CTRL+SHIFT+回车,下拉。
温馨提示:答案为网友推荐,仅供参考