Excel 将AB两表某列相同的那项从B复制到A | 筛选出相同数据

筛选出相同数据
=IF(COUNTIF(B:B,A1)>0,A1,"")
将AB两表某列相同的那项从B复制到A
=INDEX('[tmp001.xls]SQL Results'!$C:$C,MATCH(E3486,'[tmp001.xls]SQL Results'!$B:$B,))

=INDEX('[tmp001.xls]SQL Results'!$C:$C,MATCH(D118629,'[tmp001.xls]SQL Results'!$B:$B,))

=INDEX('[元数据梳理模版20180208 - 资产(生产)bak.xlsx]M06元数据-数据字典M06元数据-数据字典'!$E$7962:$E$193247,MATCH(B193011&D193011,'[元数据梳理模版20180208 - 资产(生产)bak.xlsx]M06元数据-数据字典M06元数据-数据字典'!$B$7962:$B$193247&'[元数据梳理模版20180208 - 资产(生产)bak.xlsx]M06元数据-数据字典M06元数据-数据字典'!$D$7962:$D$193247,))

=INDEX([tmp001.xls]Sheet1!$B:$B,MATCH(D126385,[tmp001.xls]Sheet1!$A:$A,))

=INDEX([Book11.xlsx]六!$B:$B,MATCH(C42951&E42951,[Book11.xlsx]六!$A:$A&[Book11.xlsx]六!$C:$C,))

=INDEX([Book11.xlsx]六!$B:$B,MATCH(C27&E27,[Book11.xlsx]六!$A:$A&[Book11.xlsx]六!$C:$C,))

=INDEX('[元数据梳理模版20180208 - 资产(生产)-广州_原.xlsx]M04 系统数据表'!$D$3:$D$2157,MATCH(E3,'[元数据梳理模版20180208 - 资产(生产)-广州_原.xlsx]M04 系统数据表'!$E$3:$E$2157,))