问题已解决
1列數(shù)據(jù)有20行,要想在10列數(shù)據(jù)里面找出相同的數(shù)據(jù),用什么公式呢
![](https://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/47/57/97_avatar_middle.jpg?t=1651203282)
用VLOOKUP函數(shù)進(jìn)行數(shù)據(jù)對比。兩列數(shù)據(jù)對比,如果有相同的數(shù)據(jù),則會返回值,沒有相同的數(shù)據(jù),則返回值是“#N/A”
2020 03/06 09:46
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84785001 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 03/06 09:48
好的,謝謝老師
![](https://pic1.acc5.cn/009/47/57/97_avatar_middle.jpg?t=1651203282)
江老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 03/06 09:49
有不明白的問題再咨詢
![](/wenda/img/newWd/sysp_btn_eye.png)