问题已解决
表格有的哦,怎么匹配不出来呢?
![](https://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
您好,把公式加上个绝对值试下=VLOOKUP(H2,$C$2:$E$64,3,0)
2020 08/30 10:04
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84785045 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 08/30 10:09
老师还是不行
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
微微老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 08/30 10:20
您好,您的公式截图我看下。
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84785045 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 08/30 10:22
老师看一下
![](https://pic1.acc5.cn/011/42/80/82_avatar_middle.jpg?t=1651216693)
微微老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 08/30 10:23
您好,要加绝对值啊,您看的绝对值都没有全部加上去。