问题已解决
請問下用vlookup函數(shù),引用的數(shù)據(jù)源數(shù)據(jù)列發(fā)生變化,那個列我應該怎么設置才能是固定的呢
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
你是要鎖定引用的區(qū)域嗎
2019 07/18 11:13
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/18 11:17
不是
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
辜老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 07/18 11:19
如果引用的數(shù)據(jù)變化了,你要重新設定的
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/18 11:21
FAILED
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/18 11:22
圖1會引用圖2G列的內容,但是G列前會增加列,怎么固定引用G列變化
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
辜老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 07/18 14:23
你吧G列的數(shù)據(jù)等于前面各個月份的預算數(shù)相加就可以
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/18 14:25
本來就是相加的啊
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/18 14:27
關鍵是第2張表如果增加月份,在G列前增加列,第1張表引用的就是G列的前一列,每次都要手動改
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784982 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/18 14:27
有沒有不改的方法
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
辜老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 07/18 15:11
那這個沒有辦法,因為你的目標數(shù)據(jù)變了
![](/wenda/img/newWd/sysp_btn_eye.png)