{"id":1658,"date":"2022-02-07T19:59:41","date_gmt":"2022-02-07T11:59:41","guid":{"rendered":"https:\/\/www.fyndpro.com\/?p=1658"},"modified":"2024-11-20T16:14:34","modified_gmt":"2024-11-20T08:14:34","slug":"vlookup-error-reasons","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/cn\/vlookup-error-reasons\/","title":{"rendered":"VLOOKUP\u51fa\u932f\u76844\u5927\u5e38\u898b\u539f\u56e0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">VLOOKUP\u4f5c\u70baExcel\u4e2d\u6700\u53d7\u6b61\u8fce\u7684\u51fd\u6578\u4e4b\u4e00\uff0c\u6211\u5011\u90fd\u6703\u7d93\u5e38\u7528\u5230\uff0c\u4f46\u7528\u8d77\u4f86\u6642\u7e3d\u6703\u9047\u5230\u932f\u8aa4\uff08\u4f46\u660e\u660e\u81ea\u5df1\u4eba\u624b\u67e5\u627e\u53cd\u800c\u6703\u6210\u529f\uff09\uff0c\u70ba\u4ec0\u9ebc\u5462\uff1f\u4eca\u6b21\u6211\u5011\u70ba\u5927\u5bb6\u62c6\u89e3\u4e00\u4e0b\u5e73\u65e5VLOOKUP\u51fd\u6578\u51fa\u932f\u7684\u5e7e\u500b\u5e38\u898b\u539f\u56e0\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\t\t\t\t\t\t<style>\r\n\t\t\t\t<style>\r\n#wpsm_accordion_1649 .wpsm_panel-heading{\r\n\tpadding:0px !important;\r\n}\r\n#wpsm_accordion_1649 .wpsm_panel-title {\r\n\tmargin:0px !important; \r\n\ttext-transform:none !important;\r\n\tline-height: 1 !important;\r\n}\r\n#wpsm_accordion_1649 .wpsm_panel-title a{\r\n\ttext-decoration:none;\r\n\toverflow:hidden;\r\n\tdisplay:block;\r\n\tpadding:0px;\r\n\tfont-size: 18px !important;\r\n\tfont-family: Open Sans !important;\r\n\tcolor:#000000 !important;\r\n\tborder-bottom:0px !important;\r\n}\r\n\r\n#wpsm_accordion_1649 .wpsm_panel-title a:focus {\r\noutline: 0px !important;\r\n}\r\n\r\n#wpsm_accordion_1649 .wpsm_panel-title a:hover, #wpsm_accordion_1649 .wpsm_panel-title a:focus {\r\n\tcolor:#000000 !important;\r\n}\r\n#wpsm_accordion_1649 .acc-a{\r\n\tcolor: #000000 !important;\r\n\tbackground-color:#e8e8e8 !important;\r\n\tborder-color: #ddd;\r\n}\r\n#wpsm_accordion_1649 .wpsm_panel-default > .wpsm_panel-heading{\r\n\tcolor: #000000 !important;\r\n\tbackground-color: #e8e8e8 !important;\r\n\tborder-color: #e8e8e8 !important;\r\n\tborder-top-left-radius: 0px;\r\n\tborder-top-right-radius: 0px;\r\n}\r\n#wpsm_accordion_1649 .wpsm_panel-default {\r\n\t\tborder:1px solid transparent !important;\r\n\t}\r\n#wpsm_accordion_1649 {\r\n\tmargin-bottom: 20px;\r\n\toverflow: hidden;\r\n\tfloat: none;\r\n\twidth: 100%;\r\n\tdisplay: block;\r\n}\r\n#wpsm_accordion_1649 .ac_title_class{\r\n\tdisplay: block;\r\n\tpadding-top: 12px;\r\n\tpadding-bottom: 12px;\r\n\tpadding-left: 15px;\r\n\tpadding-right: 15px;\r\n}\r\n#wpsm_accordion_1649  .wpsm_panel {\r\n\toverflow:hidden;\r\n\t-webkit-box-shadow: 0 0px 0px rgba(0, 0, 0, .05);\r\n\tbox-shadow: 0 0px 0px rgba(0, 0, 0, .05);\r\n\t\tborder-radius: 4px;\r\n\t}\r\n#wpsm_accordion_1649  .wpsm_panel + .wpsm_panel {\r\n\t\tmargin-top: 5px;\r\n\t}\r\n#wpsm_accordion_1649  .wpsm_panel-body{\r\n\tbackground-color:#ffffff !important;\r\n\tcolor:#000000 !important;\r\n\tborder-top-color: #e8e8e8 !important;\r\n\tfont-size:16px !important;\r\n\tfont-family: Open Sans !important;\r\n\toverflow: hidden;\r\n\t\tborder: 2px solid #e8e8e8 !important;\r\n\t}\r\n\r\n#wpsm_accordion_1649 .ac_open_cl_icon{\r\n\tbackground-color:#e8e8e8 !important;\r\n\tcolor: #000000 !important;\r\n\tfloat:right !important;\r\n\tpadding-top: 12px !important;\r\n\tpadding-bottom: 12px !important;\r\n\tline-height: 1.0 !important;\r\n\tpadding-left: 15px !important;\r\n\tpadding-right: 15px !important;\r\n\tdisplay: inline-block !important;\r\n}\r\n\r\n\t\t\t\r\n\t\t\t<\/style>\t\r\n\t\t\t<\/style>\r\n\t\t\t<div class=\"wpsm_panel-group\" id=\"wpsm_accordion_1649\" >\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1649 \" href=\"javascript:void(0)\" data-target=\"#ac_1649_collapse1\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-minus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\u539f\u56e01\uff1a\u55ae\u5143\u683c\u5167\u6709\u7a7a\u683c\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1649_collapse1\" class=\"wpsm_panel-collapse collapse in\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t\u5982\u4e0b\u5716\u4e2d\uff0cE2\u7684\u516c\u5f0f\u5beb\u6cd5\u6c92\u554f\u984c\uff0c\u5f15\u7528\u65b9\u5f0f\u4e5f\u6c92\u554f\u984c\uff0c\u9019\u6642\u5019\u5c31\u8981\u5148\u6aa2\u67e5\u88ab\u67e5\u8a62\u7684\u5167\u5bb9\u88e1\u6709\u6c92\u6709\u7a7a\u683c\uff0c\u6216\u8005\u67e5\u8a62\u7bc4\u570d\u7684\u55ae\u5143\u683c\u5167\u6709\u6c92\u6709\u7a7a\u683c\u3002\r\n\r\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1650\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A01.png?resize=844%2C327&#038;ssl=1\" alt=\"\" width=\"844\" height=\"327\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A01.png?w=844&amp;ssl=1 844w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A01.png?resize=300%2C116&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A01.png?resize=150%2C58&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A01.png?resize=768%2C298&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A01.png?resize=230%2C89&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A01.png?resize=350%2C136&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A01.png?resize=480%2C186&amp;ssl=1 480w\" sizes=\"auto, (max-width: 844px) 100vw, 844px\" \/>\r\n\r\n\u89e3\u6c7a\u65b9\u6cd5\u662f\u6309Ctrl+H \u00bb \u53d6\u4ee3\uff0c\u5728\u3010\u67e5\u627e\u76ee\u6a19\u3011\u4e2d\u8f38\u5165\u7a7a\u683c\uff0c\u6309\u3010\u5168\u90e8\u53d6\u4ee3\u3011\u3002\r\n\r\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1651\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A02.png?resize=465%2C282&#038;ssl=1\" alt=\"\" width=\"465\" height=\"282\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A02.png?w=465&amp;ssl=1 465w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A02.png?resize=300%2C182&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A02.png?resize=150%2C91&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A02.png?resize=230%2C139&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A02.png?resize=350%2C212&amp;ssl=1 350w\" sizes=\"auto, (max-width: 465px) 100vw, 465px\" \/>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"collapsed\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1649 \" href=\"javascript:void(0)\" data-target=\"#ac_1649_collapse2\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-minus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\u539f\u56e02\uff1a\u4e0d\u53ef\u898b\u5b57\u7b26\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1649_collapse2\" class=\"wpsm_panel-collapse collapse in\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t\u5982\u679c\u662f\u5f9e\u7cfb\u7d71\u5c0e\u51fa\u7684\u6578\u64da\u6e90\uff0c\u9084\u6709\u53ef\u80fd\u5b58\u5728\u4e0d\u53ef\u898b\u5b57\u7b26\u3002\u89e3\u6c7a\u65b9\u6cd5\u662f\uff1a\r\n<ol>\r\n \t<li>\u8cc7\u6599 \u00bb \u8cc7\u6599\u5256\u6790<\/li>\r\n \t<li>\u5206\u9694\u7b26\u865f<\/li>\r\n \t<li>\u5b8c\u6210<\/li>\r\n<\/ol>\r\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1652\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=1069%2C848&#038;ssl=1\" alt=\"\" width=\"1069\" height=\"848\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?w=1069&amp;ssl=1 1069w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=300%2C238&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=1024%2C812&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=150%2C119&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=768%2C609&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=920%2C730&amp;ssl=1 920w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=230%2C182&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=350%2C278&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A03.png?resize=480%2C381&amp;ssl=1 480w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/>\r\n<ul>\r\n \t<li>\u9019\u7a2e\u65b9\u6cd5\u80fd\u6e05\u9664\u5927\u90e8\u5206\u985e\u578b\u7684\u4e0d\u53ef\u898b\u5b57\u7b26\u3002<\/li>\r\n<\/ul>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"collapsed\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1649 \" href=\"javascript:void(0)\" data-target=\"#ac_1649_collapse3\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-minus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\u539f\u56e03\uff1a\u67e5\u8a62\u7bc4\u570d\u9078\u64c7\u932f\u8aa4\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1649_collapse3\" class=\"wpsm_panel-collapse collapse in\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t\u5982\u4e0b\u5716\u6240\u793a\uff0c\u4e0b\u9762\u7684\u516c\u5f0f\u51fa\u932f\u4e86\uff1a\r\n\r\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1653\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?resize=970%2C342&#038;ssl=1\" alt=\"\" width=\"970\" height=\"342\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?w=970&amp;ssl=1 970w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?resize=300%2C106&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?resize=150%2C53&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?resize=768%2C271&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?resize=920%2C324&amp;ssl=1 920w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?resize=230%2C81&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?resize=350%2C123&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A04.png?resize=480%2C169&amp;ssl=1 480w\" sizes=\"auto, (max-width: 970px) 100vw, 970px\" \/>\r\n<ul>\r\n \t<li>\u9019\u662f\u56e0\u70baVLOOKUP\u51fd\u6578\u8981\u6c42\u67e5\u8a62\u503c\u5fc5\u9808\u4f4d\u65bc\u67e5\u8a62\u5340\u57df\u7684\u9996\u5217\uff0c\u5728\u5de6\u5074\u7684\u6578\u64da\u8868\u4e2d\uff0cName\u5728B\u5217\uff0c\u6240\u4ee5\u67e5\u8a62\u5340\u57df\u8981\u5f9eB\u5217\u958b\u59cb\u9078\u53d6\u3002\u4f46\u662f\u516c\u5f0f\u5beb\u6210\u4e86\u5f9eA\u5217\u958b\u59cb\uff0cVLOOKUP\u5c31\u53ea\u6703\u627eA1\u81f3A5\u4e94\u500b\u5167\u5bb9\u4e86\u3002<\/li>\r\n<\/ul>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"collapsed\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1649 \" href=\"javascript:void(0)\" data-target=\"#ac_1649_collapse4\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-minus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\u539f\u56e04\uff1a\u6578\u5b57\u683c\u5f0f\u4e0d\u4e00\u81f4\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1649_collapse4\" class=\"wpsm_panel-collapse collapse in\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t<ul>\r\n \t<li>\u9019\u7a2e\u554f\u984c\u4e3b\u8981\u51fa\u73fe\u5728\u6578\u5b57\u985e\u578b\u7684\u67e5\u8a62\u4e2d\uff0c\u770b\u770b\u4e0b\u5716E2\u55ae\u5143\u683c\u4e2d\u7684\u516c\u5f0f\uff0c\u8981\u6839\u64daD2\u55ae\u5143\u683c\u67e5\u8a62\u5c0d\u61c9\u7684Number\uff1a\r\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1656\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A05-1.png?resize=843%2C333&#038;ssl=1\" alt=\"\" width=\"843\" height=\"333\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A05-1.png?w=843&amp;ssl=1 843w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A05-1.png?resize=300%2C119&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A05-1.png?resize=150%2C59&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A05-1.png?resize=768%2C303&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A05-1.png?resize=230%2C91&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A05-1.png?resize=350%2C138&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/02\/VLOOKUP%E5%87%BD%E6%95%B8%E5%87%BA%E9%8C%AF%E7%9A%84%E5%B9%BE%E5%80%8B%E5%B8%B8%E8%A6%8B%E5%8E%9F%E5%9B%A05-1.png?resize=480%2C190&amp;ssl=1 480w\" sizes=\"auto, (max-width: 843px) 100vw, 843px\" \/><\/li>\r\n \t<li>D\u5217\u7684\u7de8\u78bc\u662f\u6587\u672c\u578b\u7684\u6578\u5b57\uff0c\u800cA\u5217\u67e5\u8a62\u5340\u57df\u7684\u7de8\u78bc\u662f\u5e38\u898f\u683c\u5f0f\u7684\u6578\u503c\uff0c\u6240\u4ee5\u5728\u67e5\u8a62\u6642\u5c31\u6709\u554f\u984c\u4e86\u3002<\/li>\r\n \t<li>\u89e3\u6c7a\u65b9\u6cd5\u662f\u628a\u67e5\u8a62\u5340\u57df\u7684\u683c\u5f0f\u548c\u88ab\u67e5\u8a62\u7684\u5167\u5bb9\u7d71\u4e00\u6210\u540c\u4e00\u7a2e\u683c\u5f0f\u3002<\/li>\r\n \t<li>\u53ef\u4ee5\u4fee\u6539\u516c\u5f0f\uff0c\u5c07\u67e5\u8a62\u503c\u4e58\u4ee51\u8b8a\u6210\u6578\u503c\uff0c\u518d\u9032\u884c\u67e5\u8a62\u5c31\u6c92\u554f\u984c\u4e86\uff1a=VLOOKUP(D2*1,A:B,2,0)<\/li>\r\n \t<li>\u53cd\u4e4b\uff0c\u5982\u679c\u60f3\u628a\u6578\u503c\u578b\u7684\u67e5\u8a62\u503c\u8b8a\u6210\u6587\u672c\uff0c\u53ea\u8981\u5728\u67e5\u8a62\u503c\u5f8c\u9023\u63a5\u4e0a\u4e00\u500b\u7a7a\u6587\u672c&\"\"\u5c31\u597d\u4e86\uff1a=VLOOKUP(D2&\"\",A:B,2,0)<\/li>\r\n<\/ul>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\r\n<script type=\"text\/javascript\">\r\n\t\r\n\t\tfunction do_resize(){\r\n\r\n\t\t\tvar width=jQuery( '.wpsm_panel .wpsm_panel-body iframe' ).width();\r\n\t\t\tvar height=jQuery( '.wpsm_panel .wpsm_panel-body iframe' ).height();\r\n\r\n\t\t\tvar toggleSize = true;\r\n\t\t\tjQuery('iframe').animate({\r\n\t\t\t    width: toggleSize ? width : 640,\r\n\t\t\t    height: toggleSize ? height : 360\r\n\t\t\t  }, 250);\r\n\r\n\t\t\t  toggleSize = !toggleSize;\r\n\t\t}\r\n\t\t\r\n<\/script>\t<\/p>\n","protected":false},"excerpt":{"rendered":"<p>VLOOKUP\u4f5c\u70baExcel\u4e2d\u6700\u53d7\u6b61\u8fce\u7684\u51fd\u6578\u4e4b\u4e00\uff0c\u6211\u5011\u90fd\u6703\u7d93\u5e38\u7528\u5230\uff0c\u4f46\u7528\u8d77\u4f86\u6642\u7e3d\u6703\u9047\u5230\u932f\u8aa4\uff08\u4f46\u660e\u660e\u81ea\u5df1\u4eba\u624b\u67e5\u627e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3120,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[20,8,7,1],"tags":[90],"class_list":["post-1658","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-onlinesupport","category-excel","category-excel-formulas","category-lookup","tag-vlookup"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/03\/Excel-new10.png?fit=2102%2C679&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/comments?post=1658"}],"version-history":[{"count":3,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1658\/revisions"}],"predecessor-version":[{"id":3288,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/1658\/revisions\/3288"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media\/3120"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media?parent=1658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/categories?post=1658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/tags?post=1658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}