excel,超简单公式，求解怎么输入两表的序号自动对应调用内容

Question

如题所述

Answer 1

在Y2中输入或复制粘贴此公式
=if(countif(sheet1!$a:$a,$a2),vlookup($A2,Sheet1!$A:$C,column(B:B),),"")
右拖至Z2
选中Y2:Z2
下拉填充
在AA2中输入或复制粘贴此公式
=if(countif(sheet1!$a:$a,$a2),vlookup($B2,Sheet2!$A:$C,column(B:B),),"")
右拖至AB2
选中AA2:AB2
下拉填充

Answer 2

Y2输入=IF(ISNA(VLOOKUP($A2,Sheet1!$A$18:$C$30,COLUMN(B:B),)),"",VLOOKUP($A2,Sheet1!$A$18:$C$30,COLUMN(B:B),))右拉,
AA输入=IF(ISNA(VLOOKUP($B2,Sheet1!$A$2:$C$14,COLUMN(B:B),)),"",VLOOKUP($B2,Sheet1!$A$2:$C$14,COLUMN(B:B),))右拉,
最后选中Y2:AB2下拉

Answer 3

=vlookup()