同一工作表： =IF(A=B,C,"")不同工作表时，替换Sheet1即可：=IF(Sheet1!A1=Sheet1!B1,Sheet1!C1,"")
=VLOOKUP(A1,B:C,2,)
=IF(COUNTIF(B:B,A1)<>0,C1,"")
