假设有标题行，则在Sheet2的B2中输入公式，下拖即可=if(iserror(vlookup(A2,Sheet1!A:C,3,false)),"",vlookup(A2,Sheet1!A:C,3,false))下拖即可
