問題已解決
Excel里面對比數(shù)據(jù)的時候怎么設(shè)置不區(qū)分大小寫也就是j和J都默認(rèn)為一個數(shù)據(jù)
![](https://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/012/87/76/51_avatar_middle.jpg?t=1670769806)
同學(xué)你好,先把你要對比的數(shù)據(jù),使用upper函數(shù),把字母變成大寫,全部都是大寫,然后再去對比;
2021 06/23 19:12
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84785015 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 06/24 09:21
在vlookup里面套用這個公式
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84785015 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 06/24 09:29
就是要區(qū)分大小寫,不是變成一樣的,vlookup函數(shù)不區(qū)分大小寫認(rèn)為是一樣的
![](/wenda/img/newWd/sysp_btn_eye.png)