Vlookup函数显示#REF怎么办？

[[{"txt": "\u4f7f\u7528Excel\u51fd\u6570\u7684\u8fc7\u7a0b\u4e2d\uff0c\u901a\u5e38\u4f1a\u9047\u5230\u5404\u79cd\u5404\u6837\u7684\u95ee\u9898\u3002\u90a3\u4e48\uff0c\u4f7f\u7528Vlookup\u51fd\u6570\u663e\u793a#REF\u7684\u65f6\u5019\u8be5\u600e\u4e48\u529e\u5462\uff1f"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u5982\u56fe\uff0c\u5728sheet2\u8868\u4e2dB\u5217\u7684\u6570\u636e\u5e0c\u671b\u901a\u8fc7vlookup\u51fd\u6570\u4ecesheet1\u8868\u4e2d\u5339\u914d\u51fa\u6765\u3002\u4f46\u662f\u51fa\u9519\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e4b5e2f5ee0d3ace2aa829d887e265e7350fbbd6.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9996\u5148\uff0c\u6211\u4eec\u9009\u4e2dB2\u5355\u5143\u683c\uff0c\u67e5\u770b\u516c\u5f0f\u662f\u5426\u6709\u95ee\u9898\u3002\u4ece\u516c\u5f0f\u7684\u7b2c\u4e00\u4e2a\u53c2\u6570\u5f00\u59cb\u68c0\u67e5\uff0c\u53ef\u4ee5\u770b\u5230\u53c2\u6570A2\u662f\u6ca1\u6709\u95ee\u9898\u7684\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/bff8683e21c2bbd66aaf365b116186254093aed6.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u63a5\u4e0b\u6765\u67e5\u770b\u7b2c\u4e8c\u4e2a\u53c2\u6570\uff0c\u9009\u4e2d\u4e86sheet1\u8868\u4e2d\u7684BC\u5217\uff0c\u5230sheet1\u8868\u4e2d\u67e5\u770b\u540e\u53d1\u73b0\u4e5f\u6ca1\u6709\u95ee\u9898\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/b1454a1bd10ff22698e56abd9c99e92abbb8a4d6.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u63a5\u7740\u68c0\u67e5\u7b2c\u4e09\u4e2a\u53c2\u6570\u3002\u516c\u5f0f\u91cc\u5199\u7684\u662f3\uff0c\u800c\u5339\u914d\u6570\u636e\u5728\u6211\u4eec\u9009\u4e2d\u6570\u636e\u7684\u7b2c\u4e8c\u5217\uff0c\u6545\u6b64\u5904\u5e94\u4e3a2\u3002\u5c06\u5176\u4fee\u6539\u540e\uff0c\u53d1\u73b0\u5355\u5143\u683c\u8ba1\u7b97\u51fa\u4e86\u7ed3\u679c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/bbf95c406afec3146cbace5dcac1b727ad539cd6.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5c06\u9f20\u6807\u653e\u5728B2\u5355\u5143\u683c\u53f3\u4e0b\u89d2\uff0c\u5f53\u9f20\u6807\u5904\u51fa\u73b0\u5b9e\u5fc3\u7684\u201c+\u201d\u65f6\uff0c\u539f\u5730\u53cc\u51fb\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/b666b2530688912c01b5875b1b4800fc76f797d6.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9f20\u6807\u53cc\u51fb\u540e\uff0c\u53ef\u4ee5\u770b\u5230\u5176\u5b83\u5355\u5143\u683c\u4e5f\u88ab\u586b\u5145\u4e86\u683c\u5f0f\uff0c\u540c\u65f6\u8ba1\u7b97\u51fa\u4e86\u8fd0\u884c\u7ed3\u679c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/444696013870d54183f3fdbb2e0f94fc518c80d6.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "1\u3001\u6709\u95ee\u9898\u53ef\u70b9\u51fb\u63d0\u95ee\u4ea4\u6d41~"}, {"txt": "2\u3001\u5982\u679c\u89c9\u5f97\u7ecf\u9a8c\u4e0d\u9519\uff0c\u6b22\u8fce\u70b9\u8d5e\u3001\u6295\u7968\u3001\u6536\u85cf\u4ee5\u53ca\u5206\u4eab\u54e6~"}]]