是因为单元格格式是文本,把单元格格式设置成常规,然后双击该函数对应的单元格,就会显示计算结果了。以函数VLOOKUP为例,具体方法如下:
1、用VLOOKUP函数把张三的分数引用到F2单元格,此时F2单元格结果显示是=VLOOKUP(E2,A:B,2,0);
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9d82d158ccbf6c81c3284003b23eb13533fa4039?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、鼠标左键选中F列,然后鼠标右键,点击设置单元格格式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b64543a98226cffc8713d359b7014a90f603ea24?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、进入单元格设置之后可以看到单元格格式显示是文本,接着依次点击常规/确定;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2cec3fdfc039245b0858de48994a4c27d1e252c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后再双击下单元格F2,然后按回车键;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/279759ee3d6d55fb7d091bcd63224f4a21a4dd0a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、按下回车键之后,F2单元格就会显示公式引用匹配到的结果90了,再把公式往下填充就可以了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8435e5dde71190ef5235ff34c01b9d16fcfa600a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)