execl两列对比 · 秀洲人社局execl 常用问题

![](https://img.kancloud.cn/7a/23/7a2385d84b063b99771ffedeaec56af1_728x439.png) ### 　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共有")