Sheet1表的B2l输入公式=IF(ISERROR(VLOOKUP($A2,Sheet1!$A$1:$Z$800,2,FALSE)),"",VLOOKUP($A2,Sheet1!$A$1:$Z$800,2,FALSE))公式向右拉,向下拉复制A2输入姓名
