问题已解决
G列和M列找出多出來的一個產(chǎn)品,用vlookup的前提是要行的內(nèi)內(nèi)容一致才可以嗎
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
vlookup的前提是需要行的內(nèi)容一致才行。而且無法查出重復項,只能查找是否存在?
2021 10/14 16:36
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/14 16:38
老師,您看
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/14 16:38
我的意思是只有這樣子的行一致才能找出差異嗎,少了哪個產(chǎn)品?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/14 16:43
如果行內(nèi)容打亂了,就不能用vlookup了嗎
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/14 16:43
先刪除每列的重復項,就可以了
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/14 16:47
就是一定要G3=J3,G4=J4嗎
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/14 16:48
內(nèi)容要行列一致前提才能vlookup嗎
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/14 17:04
不一定,定要G3=J3,G4=J4,只要G,I列數(shù)據(jù)不重復就行
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/14 17:08
哦,好吧,有重復,以多找少嘛
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/14 17:08
是的,
祝你工作順利;方便的話,麻煩給個5星好評哦。不用回復
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/14 17:08
我這樣找了,然后有問題的插入單元格,再往下拉,還是被我找出來了
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家權(quán)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/14 17:10
自己琢磨吧,原理就是剛才說的那樣哈
![](/wenda/img/newWd/sysp_btn_eye.png)