这个用vlookup( ) 函数可以实现,如图:A表数据与B表数据 对比。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aec379310a55b319b80521e451a98226cefc17a6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
1、公式录入:C2=VLOOKUP(A2,$F$2:$G$13,2,0),下拉;H2=VLOOKUP(F2,$A$2:$B$13,2,0), 下拉;结果值不是 #N/A 的都是A表与B表中品牌相同的,
2、复制表A表与B表,粘贴---粘贴为数值--- 到另一个位置, 如A17,将B表的B列C列交换位置,对比数据;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a6efce1b9d16fdfa4898657fa68f8c5495ee7baf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、按A列排序后,对比上下记录,相同的标为红色; 选择品牌区域 条件格式---突出显示单元格规则---重复值---
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/314e251f95cad1c8b6485fb66d3e6709c83d51ab?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、筛选表格,删除值为#N/A的记录,再数据---删除重复项,留下的就是你需要的数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/279759ee3d6d55fb3f28d5b77f224f4a21a4ddb1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)