{"id":1620,"date":"2017-07-13T19:26:33","date_gmt":"2017-07-13T10:26:33","guid":{"rendered":"https:\/\/pasocollege.com\/book\/?page_id=1620"},"modified":"2026-03-25T15:28:33","modified_gmt":"2026-03-25T06:28:33","slug":"excel_short_vlookup","status":"publish","type":"page","link":"https:\/\/pasocollege.com\/book\/titles\/excel_short_vlookup\/","title":{"rendered":"\u4ed5\u4e8b\u3067\u4f7f\u3048\u308b\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5eVLOOKUP\u5fdc\u7528"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

\u300c\u4ed5\u4e8b\u3067\u4f7f\u3048\u308b\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5eVLOOKUP\u5fdc\u7528\u300d\u306f\u3001\u898b\u7a4d\u66f8\u30fb\u8acb\u6c42\u66f8\u306a\u3069\u3067\u30c7\u30fc\u30bf\u53c2\u7167\u3092\u8a2d\u5b9a\u3059\u308b\u3068\u304d\u306b\u3001VLOOKUP\u95a2\u6570\u3092\u4f7f\u3048\u308b\u3088\u3046\u306b\u3059\u308b\u30c6\u30ad\u30b9\u30c8\u3067\u3059\u3002<\/p>\n\n\n\n

VLOOKUP\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u4e00\u5ea6\u4ee5\u4e0a\u5b66\u3070\u308c\u305f\u65b9\u3092\u60f3\u5b9a\u3057\u3001\u540d\u524d\u306e\u5b9a\u7fa9\u3084\u8907\u6570\u306e\u30c7\u30fc\u30bf\u306e\u7167\u5408\u3001\u95a2\u6570\u306e\u30cd\u30b9\u30c8\uff08\u7d44\u307f\u5408\u308f\u305b\uff09\u3001\u300c\uff03N\/A\u300d\u3068\u3044\u3063\u305f\u30a8\u30e9\u30fc\u5024\u3092\u975e\u8868\u793a\u306b\u3059\u308b\u65b9\u6cd5\u306a\u3069\u304c\u5b66\u3079\u307e\u3059\u3002<\/p>\n\n\n\n

\u6559\u6750\u3068\u3057\u3066\u63d0\u6848\u66f8\u3001\u8acb\u6c42\u66f8\u3001\u898b\u7a4d\u66f8\u3092\u7528\u610f\u3057\u3066\u304a\u308a\u3001
\u5404\u66f8\u985e\u3054\u3068\u306b\u64cd\u4f5c\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u305f\u5b9f\u8df5\u7684\u306a\u5185\u5bb9\u3068\u306a\u3063\u3066\u304a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n\n\n

<\/div>\n\n\n\n

\u3054\u8cfc\u5165\u60c5\u5831<\/h3>\n\n\n\n
\u63a8\u5968\u5b66\u7fd2\u6642\u9593<\/td>2\u6642\u9593<\/td><\/tr>
\u5b66\u7fd2\u5bfe\u8c61\u8005<\/td>\u30a8\u30af\u30bb\u30eb\u4e2d\u7d1a\u4fee\u4e86\u7a0b\u5ea6<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u5185\u5bb9<\/h2>\n\n\n\n
    \n
  1. \u63d0\u6848\u66f8\u306e\u4f5c\u6210\uff08\u95a2\u6570\u306e\u5165\u529b\u3001\u30b3\u30d4\u30fc\u30fb\u30d7\u30eb\u30c0\u30a6\u30f3\u30e1\u30cb\u30e5\u30fc\u306e\u4f5c\u6210\u30fb\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u4f7f\u7528\u3057\u305f\u30bb\u30eb\u306e\u7a7a\u6b04\u8868\u793a\uff09<\/li>\n\n\n\n
  2. \u8acb\u6c42\u66f8\u306e\u4f5c\u6210\uff08\uff03N\/A\u306e\u7a7a\u6b04\u8868\u793a\uff09<\/li>\n\n\n\n
  3. \u898b\u7a4d\u66f8\u306e\u4f5c\u6210\uff08\u7bc4\u56f2\u306e\u540d\u524d\u5b9a\u7fa9\u30fb\u5b9a\u7fa9\u3057\u305f\u540d\u524d\u3092\u95a2\u6570\u3067\u4f7f\u3046\u30fb\u7df4\u7fd2\u554f\u984c\uff09<\/li>\n\n\n\n
  4. \u5fdc\u7528\uff1a\u30c7\u30fc\u30bf\u306e\u7167\u5408\uff08\uff12\u3064\u306e\u30c7\u30fc\u30bf\u304b\u3089\u5b58\u5426\u3092\u7167\u5408\u3059\u308b\u30fb\u7df4\u7fd2\u554f\u984c\uff09<\/li>\n\n\n\n
  5. STEP UP!<\/li>\n<\/ol>\n\n\n","protected":false},"excerpt":{"rendered":"

    IF\u3001SUMIF\u3001COUNTIF\u3001VLOOKUP\u3001IFERROR\u95a2\u6570\u306a\u3069\u3092\u7d44\u307f\u5408\u308f\u305b\u3066
    \n\u5b9f\u52d9\u3067VLOOKUP\u95a2\u6570\u3092\u4f7f\u3044\u3053\u306a\u305b\u308b\u3088\u3046\u306b\u306a\u308b\u3053\u3068\u3092\u76ee\u7684\u306b\u5b66\u7fd2\u3057\u307e\u3059\u3002\u57fa\u672c\u7684\u306aExcel\u64cd\u4f5c\u304c\u3067\u304d\u308b\u65b9\u304c\u5bfe\u8c61\u3067\u3059\u3002<\/p>\n","protected":false},"author":6,"featured_media":2244,"parent":1514,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"vkexunit_cta_each_option":"","footnotes":""},"categories":[115,26,91,99,71,94,89,95,49,37],"tags":[],"class_list":["post-1620","page","type-page","status-publish","has-post-thumbnail","hentry","category-elearning","category-excel","category-consultant","category-text","category-marketing","category-hr","category-planning","category-medical","category-licentiate","category-practical"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/comments?post=1620"}],"version-history":[{"count":14,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1620\/revisions"}],"predecessor-version":[{"id":5822,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1620\/revisions\/5822"}],"up":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/media\/2244"}],"wp:attachment":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/media?parent=1620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/categories?post=1620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/tags?post=1620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}