在B列输入=IF(COUNTIF(Sheet2!$A:$A,A1)>0,"是","否") 下拉即可
SHEET1B1单元格输入公式=IF(COUNTIF(SHEET2!A:A,A1),"是","否")下拉复制公式
