问题已解决
vlookup和trim函数结果都是0.这是为什么?
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
2个作用不同的函数。trim函数是删除空格,vlookup是匹配到某个对象,就返回某列相应行的值
2021 09/20 20:27
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/20 20:36
我是说2个函数分开用
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/20 20:36
如A1单元格是大白菜。但trim(A1)结果是0
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 09/20 20:37
这该怎么办
![](https://pic1.acc5.cn/014/05/91/38_avatar_middle.jpg?t=1730557491)
家权老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 09/20 20:41
还真没遇到过,你使用的是啥WPS还是Excel?