{"id":312,"date":"2019-02-19T15:40:09","date_gmt":"2019-02-19T07:40:09","guid":{"rendered":"http:\/\/alisonyip.viekee.com\/?p=312"},"modified":"2019-02-22T11:10:27","modified_gmt":"2019-02-22T03:10:27","slug":"excel%e7%9a%84lookup%e5%87%bd%e6%95%b0-%e6%9d%a1%e4%bb%b6%e5%bc%95%e7%94%a81","status":"publish","type":"post","link":"https:\/\/alisonyip.viekee.com\/?p=312","title":{"rendered":"Excel\u7684LOOKUP\u51fd\u6570 \u6761\u4ef6\u67e5\u8be2\u5f15\u7528\uff08\u5355\u6761\u4ef6\uff09"},"content":{"rendered":"\n<p>\u6700\u8fd1\u53c8\u8981\u7528\u5230excel\u8868\u505a\u6570\u636e\uff0c\u8fd9\u6b21\u9700\u8981\u5f15\u7528\u522b\u7684\u6570\u636e\u5230\u8868\u4e2d\u3002\u67e5\u8be2\u53d1\u73b0\u53ef\u4ee5\u4f7f\u7528LOOKUP\u51fd\u6570<\/p>\n\n\n\n<p>LOOKUP\uff08lookup_value\uff0clookup_vector\uff0cresult_vector\uff09<\/p>\n\n\n\n<p>lookup_value\u610f\u601d\u4e3a\u6211\u4eec\u8981\u5728\u6570\u636e\u8868\u4e2d\u67e5\u627e\u7684\u201c\u503c\u201d\u3002<\/p>\n\n\n\n<p>lookup_vector\u610f\u601d\u4e3a\u6211\u4eec\u8981\u67e5\u627e\u7684\u503c\u5f97\u201c\u6570\u636e\u8868\u201d\u3002<\/p>\n\n\n\n<p>result_vector\u610f\u601d\u4e3a\u6211\u4eec\u901a\u8fc7\u6570\u636e\u8868\u60f3\u8981\u5f97\u5230\u7684&#8221;\u503c\u201c\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u4f7f\u7528\u9014\u4e2d\uff0c\u53d1\u73b0\u4e00\u4e2a\u5de8\u5927\u7684BUGT_T<\/p>\n\n\n\n<p>\u5c31\u662f\u7b5b\u9009\u51fa\u7684\u6570\u636e\u662f\u4e0d\u662f\u6240\u8981\u7684\u6570\u636e,\u5982\u4ee5\u4e0b\u4f8b\u5b50\uff1a<\/p>\n\n\n\n<p>\n\nF2\u7684\u516c\u5f0f\u4e3a=LOOKUP(D2,B2:B15,C2:C15)\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"508\" height=\"297\" src=\"https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/02\/\u5fae\u4fe1\u56fe\u7247_20190219154301.png\" alt=\"\" class=\"wp-image-313\" srcset=\"https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/02\/\u5fae\u4fe1\u56fe\u7247_20190219154301.png 508w, https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/02\/\u5fae\u4fe1\u56fe\u7247_20190219154301-300x175.png 300w, https:\/\/alisonyip.viekee.com\/wp-content\/uploads\/2019\/02\/\u5fae\u4fe1\u56fe\u7247_20190219154301-462x270.png 462w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/figure>\n\n\n\n<p>\u987f\u65f6\u5d29\u6e83\uff0c\u4e3a\u4ec0\u4e48\u5462\uff01<\/p>\n\n\n\n<p>\u7ecf\u8fc7\u5c0f\u7f16\u67e5\u627e\u4e86\u89e3\uff0c\u53d1\u73b0\u539f\u56e0\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p class=\"has-background has-pale-cyan-blue-background-color\">LOOKUP\u8981\u67e5\u8be2\u4e00\u4e2a\u660e\u786e\u7684\u503c\u6216\u8005\u8303\u56f4\u7684\u65f6\u5019(\u4e5f\u5c31\u662f\u77e5\u9053\u5728\u67e5\u627e\u7684\u6570\u636e\u5217\u662f\u80af\u5b9a\u5305\u542b\u88ab\u67e5\u627e\u7684\u503c)\uff0c\u67e5\u8be2\u5217<strong>\u5fc5\u987b\u6309\u7167\u5347\u5e8f\u6392\u5217<\/strong>\u3002<\/p>\n\n\n\n<p class=\"has-text-color has-vivid-red-color\">\n\n\u5982\u679c\u6240\u67e5\u8be2\u503c\u4e3a\u660e\u786e\u7684\u503c\uff0c\u5219\u8fd4\u56de\u503c\u5bf9\u5e94\u7684\u7ed3\u679c\u884c\uff0c\u5982\u679c\u6ca1\u6709\u660e\u786e\u7684\u503c\uff0c\u5219\u5411\u4e0b\u53d6\u7684\u4e8e\u6240\u67e5\u8be2\u503c\u6700\u8fd1\u7684\u503c\n\n<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u6240\u4ee5\u5982\u679c\u8981\u7528\u4e0a\u9762\u7684\u65b9\u6cd5\uff0c\u5fc5\u987b\u628a\u67e5\u627e\u7684\u6570\u636e\u6e90\u5148\u6309\u7167\u5347\u5e8f\u6392\u5217\uff0c\u624d\u53ef\u4ee5\u518d\u4f7f\u7528\u516c\u5f0f\u67e5\u627e\u54e6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u53c8\u8981\u7528\u5230excel\u8868\u505a\u6570\u636e\uff0c\u8fd9\u6b21\u9700\u8981\u5f15\u7528\u522b\u7684\u6570\u636e\u5230\u8868\u4e2d\u3002\u67e5\u8be2\u53d1\u73b0\u53ef\u4ee5\u4f7f\u7528LOOKUP\u51fd\u6570 LOOKUP\uff08lookup_value\uff0clookup_vector&#8230;<\/p>\n<p class=\"read-more\"><a class=\"btn btn-default\" href=\"https:\/\/alisonyip.viekee.com\/?p=312\"> Read More<span class=\"screen-reader-text\">  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/312"}],"collection":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=312"}],"version-history":[{"count":3,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":331,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions\/331"}],"wp:attachment":[{"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alisonyip.viekee.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}