### 　B1单元格公式为：=IF(ISNA(VLOOKUP(A1,$C$1:$C$6,1,)),"←A有C无","←AC共有") ### D1单元格公式为：=IF(ISNA(VLOOKUP(C1,$A$1:$A$6,1,)),"←C有A无","←CA共有")