EXCEL如何将表里的数据自动填充到表2个模板中

Question

如图。。。只要在表1的 A1灰色里面填写序列号12345...表2里面的内容会自动提取表1的数据

Answer 1

b3=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,2,0),"")
e3=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,3,0),"")
h3=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,4,0),"")
c4=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,5,0),"")
h4=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,6,0),"")
c5=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,7,0),"")
h5=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,8,0),"")
c6=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,9,0),"")
h6=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,10,0),"")
d9=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),h4&"-"&c5,"")

Answer 2

表二B3（姓名）公式：
=VLOOKUP(SHEET1!A1,SHEET!A:B,2,)
其他公式类似。追问

表1 灰色的A1哪里是怎么设置的   哪里填写了序列号表2才会提取内容

如果表1A1无数据    表2就如图

追答

将公式改一下：
= IF(SHEET1!A1="","",VLOOKUP(SHEET1!A1,SHEET!A:B,2,))

Answer 3

有人在吗