EXCEL一个单元格值选中,另三个单元格会自动对应相对应的值?

sheet2中输入以下：a1输入 =index(sheet1!a:a,match(sheet2!$d1,sheet1!$d:$d,))b1输入 =index(sheet1!b:b,match(sheet2!$d1,sheet1!$d:$d,))c1输入 =index(sheet1!c:c,match(sheet2!$d1,sheet1!$d:$d,))每列下拉填充即可。