Sheet2的B1单元格=if(Sheet1!A1=Sheet2!A1,Sheet1!B1,"不相等")
在sheet2中的B1单元格输入=vlookup(a1,sheet1!a:b,2,false)
sheet2!b2＝if(a1=sheet1!a1,sheet1!b2,"")
