EXCEL如何将表里的数据自动填充到表2个模板中答: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$...