1、打开电脑,在电脑桌面上打开两个工作表sheet1、sheet2,点击进入这两个工作表;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/50da81cb39dbb6fdf246fd9c0724ab18972b376e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在B1单元格内输入=VLOOKUP(A1,Sheet2!$A$1:$B$22,2,0),$A$1:$B$22 是绝对引用sheet2表内的固定区域,防止使用填充柄时被查找的区域发生变化;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8326cffc1e178a827e23671af803738da977e869?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、使用填充柄后会发现所有被填充的单元格内容都一样,点击excel左上角的office按钮,选择“excel选项”,再选择左侧“公式”菜单;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbed13402ec576f0f736afc31f6a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选中“计算选项”内的“自动重算”,点击“确定”选项,回到工作表sheet1看下单元格内的内容,就会显示正常。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/738b4710b912c8fc4ddfee77f2039245d688215f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳