问题已解决
想問怎么把一列數(shù)據(jù)從另一列中查找出來,只有金額,沒有別的唯一項,不能用vlookup函數(shù)
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
你好同學(xué),從你描述,可以試試篩選重復(fù)項,把要找的數(shù)據(jù)粘貼到另一張表里對應(yīng)的數(shù)據(jù)列,整列轉(zhuǎn)中查找。能讓我看看數(shù)據(jù)嗎?截圖也行。
2022 03/17 16:13
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 03/17 16:18
就是銀行對賬,用友數(shù)據(jù)和對賬單核對
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 03/17 16:18
筆數(shù)特別多
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 03/17 16:19
只能查這個數(shù)據(jù)在另一列有沒有
圖圖*老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 03/17 16:42
把兩張表的收支數(shù)據(jù)分別排序,然后沾到一張表里,中間計算差額,差為零的就是對上的,出現(xiàn)不為0的就是未達(dá)賬項,然后把這一行調(diào)整一下,從下一行介意的題
![](/wenda/img/newWd/sysp_btn_eye.png)