{"id":19274,"date":"2019-08-29T23:30:20","date_gmt":"2019-08-29T14:30:20","guid":{"rendered":"https:\/\/www.e-nekorakuen.net\/?p=19274"},"modified":"2019-08-31T00:11:04","modified_gmt":"2019-08-30T15:11:04","slug":"vlookup%e9%96%a2%e6%95%b0%e3%81%ae%e5%be%8c%e7%b6%99%e3%80%81xlookup%e9%96%a2%e6%95%b0%e3%82%92%e5%8d%8a%e5%b9%b4%e5%be%8c%e3%81%ab%e3%83%aa%e3%83%aa%e3%83%bc%e3%82%b9","status":"publish","type":"post","link":"https:\/\/www.e-nekorakuen.net\/?p=19274","title":{"rendered":"VLOOKUP\u95a2\u6570\u306e\u5f8c\u7d99\u3001XLOOKUP\u95a2\u6570\u3092\u534a\u5e74\u5f8c\u306b\u30ea\u30ea\u30fc\u30b9"},"content":{"rendered":"<p>\u7c73Microsoft\u306f8\u670828\u65e5\uff08\u73fe\u5730\u6642\u9593\uff09\u3001\u65b0\u3057\u3044\u300cExcel\u300d\u95a2\u6570\u300cXLOOKUP\u300d\u3092\u767a\u8868\u3057\u307e\u3057\u305f\u3002\u300cVLOOKUP\u300d\u3084\u300cHLOOKUP\u300d\u306e\u5f8c\u7d99\u3068\u306a\u308b\u95a2\u6570\u3067\u3001\u73fe\u5728\u201cOffice Insiders\u201d\u3067\u30c6\u30b9\u30c8\u53ef\u80fd\u3002\u4e00\u822c\u516c\u958b\u306f\u4eca\u5e74\u5f8c\u534a\u304c\u4e88\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/techcommunity.microsoft.com\/t5\/Excel-Blog\/Announcing-XLOOKUP\/ba-p\/811376\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Excel Blog \u8a72\u5f53\u8a18\u4e8b<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19275\" src=\"https:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2019\/08\/25529a29-8f61-4a71-92c0-f5d7b280641e.jpg\" alt=\"\" width=\"208\" height=\"160\" \/><\/p>\n<p>XLOOKUP\u95a2\u6570\u306fVLOOKUP\u95a2\u6570\u306e\u6b20\u70b9\u3092\u30ab\u30d0\u30fc\u3057\u307e\u3059\u3002\uff08\u21d2\u6539\u5584\u70b9\uff09<\/p>\n<p>\u6b20\u70b91\uff1a\u7b2c4\u5f15\u6570\u306e\u521d\u671f\u5024\u304c\u8fd1\u4f3c\u5024\uff08TRUE or 1)\u306b\u306a\u3063\u3066\u3044\u308b\u3002\u3000\u21d2\u521d\u671f\u5024\u304c\u5b8c\u5168\u4e00\u81f4<br \/>\n\u6b20\u70b92\uff1a\u53f3\u5217\u304b\u3089\u5de6\u5217\u3092\u691c\u7d22\u3067\u304d\u306a\u3044\u3002\u21d2\u5de6\u53f3\u3044\u305a\u308c\u306e\u65b9\u5411\u306b\u3082\u691c\u7d22\u53ef\u80fd<br \/>\n\u6b20\u70b93\uff1a\u7e26\u65b9\u5411\u306b\u3057\u304b\u691c\u7d22\u3067\u304d\u306a\u3044\u3002\uff08\u6a2a\u65b9\u5411\u306fHLOOKUP\u95a2\u6570\uff09\u21d2\u6307\u5b9a\u3057\u305f\u8868\uff08\u914d\u5217\uff09\u306e\u4e2d\u3092\u7e26\u6a2a\u306b\u691c\u7d22<br \/>\n\u6b20\u70b94\uff1a\u8fd1\u4f3c\u5024\u691c\u7d22\u3067\u306f\u691c\u7d22\u5217\u3092\u3042\u3089\u304b\u3058\u3081\u30bd\u30fc\u30c8\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002\u21d2\u30bd\u30fc\u30c8\u306f\u4e0d\u8981\u3001\u8fd1\u4f3c\u5024\u306e\u4e0a\u4e0b\u6307\u5b9a\u53ef\u80fd<br \/>\n\u203b\u3053\u308c\u4ee5\u5916\u306b\u3082\u7d30\u304b\u3044\u6539\u5584\u70b9\u3042\u308a\u3002<\/p>\n<p>\u3010XLOOKUP\u95a2\u6570\u306e\u5f62\u5f0f\u3011<br \/>\nXLOOKUP\uff08\u691c\u7d22\u3059\u308b\u5024\u3001\u691c\u7d22\u3059\u308b\u914d\u5217\u3001\u8fd4\u308a\u5024\u306e\u914d\u5217\uff09<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19276\" src=\"https:\/\/www.e-nekorakuen.net\/wp-content\/uploads\/2019\/08\/9bdc7843-ee8e-4815-833f-64cff5080775.jpg\" alt=\"\" width=\"208\" height=\"130\" \/><\/p>\n<p>IF\u95a2\u6570\u306b\u6b21\u3044\u30672\u756a\u76ee\u306e\u4eba\u6c17\u3092\u8a87\u308b\u95a2\u6570\u3060\u3051\u306b\u3001\u306a\u306b\u304b\u3068\u95a2\u5fc3\u3092\u96c6\u3081\u308b\u3053\u3068\u306b\u306a\u308a\u305d\u3046\u3067\u3059\u3002\u5f53\u7136\u3067\u3059\u304c\u3001Office 365\u306e\u6700\u65b0\u7248\u3067\u306a\u3044\u3068\u4f7f\u3048\u306a\u3044\u95a2\u6570\u3067\u3059\u304b\u3089\u3001\u4e0b\u4f4d\u4e92\u63db\u6027\u306f\u3042\u308a\u307e\u305b\u3093\u3002XLOOKUP\u95a2\u6570\u4ee5\u5916\u306b\u3001XMATCH\u95a2\u6570\u3082\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7c73Microsoft\u306f8\u670828\u65e5\uff08\u73fe\u5730\u6642\u9593\uff09\u3001\u65b0\u3057\u3044\u300cExcel\u300d\u95a2&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":19275,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","_veu_custom_css":"","veu_display_promotion_alert":"","footnotes":""},"categories":[36],"tags":[],"class_list":["post-19274","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-36"],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/posts\/19274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19274"}],"version-history":[{"count":0,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/posts\/19274\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=\/wp\/v2\/media\/19275"}],"wp:attachment":[{"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.e-nekorakuen.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}