问题已解决
=VLOOKUP(S3,$A$2:$B$977,1,FALSE),這個公式哪里有問題?我這邊找不出來值
![](https://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
有問題,數(shù)值應(yīng)該是0,不是1
2022 09/20 12:50
松松老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/20 12:51
0代表精確查找的數(shù)值
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784987 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/20 12:56
查不出來數(shù)據(jù)
FAILED
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784987 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/20 12:57
幫忙看一下是什么問題
松松老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/20 13:10
列s鎖定一下試試那
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784987 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/20 13:16
4還是查找不出來
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784987 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/20 13:16
顯示結(jié)果是這樣的
FAILED
松松老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/20 14:41
不可能是4哈,只能是0,
松松老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/20 14:41
返回值您吶還是1啊,應(yīng)該是0
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784987 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/20 14:52
試過了,0也不行
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784987 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/20 14:53
不是這個原因,我平時就這樣操作
松松老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/20 15:58
也就是說一部分能查出來一部分就沒有數(shù)值對嗎?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784987 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/20 16:20
所有的都查找不出來
松松老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/20 17:10
我只看出來返回值的問題,再找不出來就看看數(shù)據(jù)源是否有空格等
![](/wenda/img/newWd/sysp_btn_eye.png)