表B的B2==IF(ISERROR(VLOOKUP(A2,[表A.xls]Sheet1!$A$2:$A$13,1,0)),"无","有") 下拉
在B表中的B2单元格中输入=IF（COUNTIF(A表!A2：A100,A2)>=1,"有","无"）
=if(find(b!a1,a!a1:a100),"有",“无”)
