問(wèn)題已解決
老師,這個(gè)4是什么意思?
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師
金牌答疑老師
職稱:注冊(cè)會(huì)計(jì)師,高級(jí)會(huì)計(jì)師,律師從業(yè)資格,稅務(wù)師,中級(jí)經(jīng)濟(jì)師
您好,這是VLOOKUP取第4列數(shù)據(jù)
2024 03/23 19:21
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84785043 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 03/23 19:53
但第4列無(wú)數(shù)值啊,
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 03/23 19:57
您好,您看=VLOOKUP(查找值,查找區(qū)域,列序數(shù),匹配條件)
第3個(gè)參數(shù)就是列
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84785043 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 03/23 19:58
但你說(shuō)顯示是第4列啊
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 03/23 20:01
您好,這個(gè)?VLOOKUP返回的確實(shí)是第4列這個(gè)單元格的值
![](/wenda/img/newWd/sysp_btn_eye.png)