关联匹配
=INDEX(Sheet2!$A$2:$A$77,MATCH(A4,Sheet2!$C$2:$C$77,0))
重复性筛选
=IF(COUNTIF(B:B,B1)>1,B1,"")
错误处理
=iferror('','')