问题已解决
如何才能快速找出這兩列中相同的數(shù)據(jù)
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
你好。數(shù)字不好作為查找值,不是說(shuō)不能做為查找值,是說(shuō)數(shù)字作為查找值的計(jì)算結(jié)果,可能并不符合用戶要求。還是需要得有一致的項(xiàng)目,比如單號(hào),使用vlookup函數(shù)就可以了。
FAILED
2019 03/08 15:09
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/08 15:11
謝謝您
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/08 15:13
看不懂那公式老師
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel劉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/08 15:17
vlookup函數(shù)的語(yǔ)法是
=vlookup(查找值,要查找的區(qū)域,要返回的值在查找區(qū)域的第幾列,0)
FAILED
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/08 15:24
謝謝老師,我試著做下
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel劉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/09 14:30
同學(xué)你好,請(qǐng)點(diǎn)右下角的結(jié)束問(wèn)題哈
![](/wenda/img/newWd/sysp_btn_eye.png)