{"id":12177,"date":"2019-09-06T15:00:00","date_gmt":"2019-09-06T06:00:00","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=12177"},"modified":"2019-09-06T16:56:05","modified_gmt":"2019-09-06T07:56:05","slug":"excelxlookup%e9%96%a2%e6%95%b0%e3%81%a7%e3%82%88%e3%82%8a%e7%b0%a1%e5%8d%98%e3%81%ab%e5%80%a4%e3%82%92%e6%a4%9c%e7%b4%a2%e3%81%a7%e3%81%8d%e3%82%8b%e3%82%88%e3%81%86%e3%81%ab%e3%81%aa%e3%82%8a","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=12177","title":{"rendered":"[Excel]XLOOKUP\u95a2\u6570\u3067\u3088\u308a\u7c21\u5358\u306b\u5024\u3092\u691c\u7d22\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\uff01"},"content":{"rendered":"<p>\u4e0b\u8a18\u8a18\u4e8b\u306e\u901a\u308a\u30012019\u5e748\u6708\u672b\u306b<a href=\"https:\/\/support.office.com\/ja-jp\/article\/0bbc8083-26fe-4963-8ab8-93a18ad188a1\" title=\"VLOOKUP \u95a2\u6570 - Office \u30b5\u30dd\u30fc\u30c8\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP<\/a>\u95a2\u6570\u3084<a href=\"https:\/\/support.office.com\/ja-jp\/article\/a3034eec-b719-4ba3-bb65-e1ad662ed95f\" title=\"HLOOKUP \u95a2\u6570 - Office \u30b5\u30dd\u30fc\u30c8\" target=\"_blank\" rel=\"noopener noreferrer\">HLOOKUP<\/a>\u95a2\u6570\u306e\u5f8c\u7d99\u3068\u306a\u308b\u65b0\u3057\u3044\u95a2\u6570\u300c<span style=\"color: #ff0000; font-weight: bold;\">XLOOKUP<\/span>\u300d\u95a2\u6570\u304c\u767a\u8868\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/forest.watch.impress.co.jp\/docs\/news\/1204053.html\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=forest.watch.impress.co.jp\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">\u7a93\u306e\u675c<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/pz-linkcard\/cache\/0f73814f5b6cd1b0ff9648c253388b66d5e2548f9c5dba8b2195f23100ebd6ff.jpeg\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">Microsoft\u3001\u65b0\u3057\u3044Excel\u95a2\u6570\u300cXLOOKUP\u300d\u3092\u767a\u8868 \uff5e\u300cVLOOKUP\u300d\u3084\u300cHLOOKUP\u300d\u306e\u5f8c\u7d99...<\/div><div class=\"lkc-url\" title=\"https:\/\/forest.watch.impress.co.jp\/docs\/news\/1204053.html\">https:\/\/forest.watch.impress.co.jp\/docs\/news\/1204053.html<\/div><div class=\"lkc-excerpt\">\u3000\u7c73Microsoft\u306f8\u670828\u65e5\uff08\u73fe\u5730\u6642\u9593\uff09\u3001\u65b0\u3057\u3044\u300cExcel\u300d\u95a2\u6570\u300cXLOOKUP\u300d\u3092\u767a\u8868\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\u308b\u3002<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/www.atmarkit.co.jp\/ait\/articles\/1909\/04\/news079.html\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=www.atmarkit.co.jp\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">\uff20IT<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/pz-linkcard\/cache\/9bf6ad1928a7718970ef939e31f44cc1598c04a1aa88598e558108277e1992ea.jpeg\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">Microsoft\u3001Excel\u95a2\u6570\u300cXLOOKUP\u300d\u3092\u767a\u8868\u3001\u300cVLOOKUP\u300d\u306e\u5f8c\u7d99<\/div><div class=\"lkc-url\" title=\"https:\/\/www.atmarkit.co.jp\/ait\/articles\/1909\/04\/news079.html\">https:\/\/www.atmarkit.co.jp\/ait\/articles\/1909\/04\/news079.html<\/div><div class=\"lkc-excerpt\">Microsoft\u306f\u3001\u65b0\u3057\u3044Excel\u95a2\u6570\u300cXLOOKUP\u300d\u3092\u767a\u8868\u3057\u3001\u03b2\u7248\u3092\u63d0\u4f9b\u958b\u59cb\u3057\u305f\u3002\u300cVLOOKUP\u300d\u3084\u300cHLOOKUP\u300d\u306e\u5f8c\u7d99\u3068\u306a\u308b\u95a2\u6570\u3060\u3002\u4f75\u305b\u3066\u300cXMATCH\u300d\u95a2\u6570\u3082\u767a\u8868\u3057\u305f\u3002<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<blockquote class=\"twitter-tweet\" data-lang=\"ja\">\n<p lang=\"en\" dir=\"ltr\"><a href=\"https:\/\/twitter.com\/hashtag\/OfficeInsiders?src=hash&amp;ref_src=twsrc%5Etfw\">#OfficeInsiders<\/a>, we are excited to introduce you to XLOOKUP, the successor to the powerful VLOOKUP in <a href=\"https:\/\/twitter.com\/msexcel?ref_src=twsrc%5Etfw\">@msexcel<\/a>! Get all the details on XLOOKUP and how it will simplify your everyday work in Excel in our latest blog post from one of our PMs, Joe!<a href=\"https:\/\/t.co\/AEJVEyyitO\">https:\/\/t.co\/AEJVEyyitO<\/a> <a href=\"https:\/\/t.co\/lVSuZcdr2i\">pic.twitter.com\/lVSuZcdr2i<\/a><\/p>\n<p>&mdash; MS Office Insiders (@OfficeInsider) <a href=\"https:\/\/twitter.com\/OfficeInsider\/status\/1167134851075584000?ref_src=twsrc%5Etfw\">2019\u5e748\u670829\u65e5<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p><a href=\"https:\/\/insider.office.com\/ja-jp\/releasenotes\/pc\/fast\" title=\"Office Insiders\" target=\"_blank\" rel=\"noopener noreferrer\">\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8<\/a>\u306b\u3042\u308b\u901a\u308a\u3001Insider\u7248\u306eExcel(\u30d0\u30fc\u30b8\u30e7\u30f3 1909 (\u30d3\u30eb\u30c9 12026.20000)\u4ee5\u964d)\u3067\u306f\u3059\u3067\u306b\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u304a\u308a\u3001\u65e5\u672c\u8a9e\u7248\u306e\u95a2\u6570\u306e\u30d8\u30eb\u30d7\u30da\u30fc\u30b8\u3082\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/support.office.com\/ja-jp\/article\/B7FD680E-6D10-43E6-84F9-88EAE8BF5929\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=support.office.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">support.office.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fsupport.office.com%2Fja-jp%2Farticle%2FB7FD680E-6D10-43E6-84F9-88EAE8BF5929?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">XLOOKUP \u95a2\u6570<\/div><div class=\"lkc-url\" title=\"https:\/\/support.office.com\/ja-jp\/article\/B7FD680E-6D10-43E6-84F9-88EAE8BF5929\">https:\/\/support.office.com\/ja-jp\/article\/B7FD680E-6D10-43E6-84F9-88EAE8BF5929<\/div><div class=\"lkc-excerpt\">\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u9805\u76ee\u3084\u884c\u3054\u3068\u306e\u7bc4\u56f2\u3092\u691c\u7d22\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408\u306f\u3001XLOOKUP \u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002 \u305f\u3068\u3048\u3070\u3001\u81ea\u52d5\u8eca\u90e8\u54c1\u306e\u4fa1\u683c\u3092\u90e8\u54c1\u756a\u53f7\u3067\u691c\u7d22\u3059\u308b\u304b\u3001\u5f93\u696d\u54e1 ID \u306b\u57fa\u3065\u3044\u3066\u5f93\u696d\u54e1\u540d\u3092\u691c\u7d22\u3057\u307e\u3059\u3002 XLOOKUP \u3067\u306f\u3001\u623b\u308a\u5024\u306e\u5217\u304c\u3069\u306e\u5074\u306b\u3042\u308b\u304b\u306b\u304b\u304b\u308f\u3089\u305a\u3001\u691c\u7d22\u8a9e\u30921\u3064\u306e\u5217\u306b\u8868\u793a\u3057\u3066\u3001\u5225\u306e\u5217\u306e\u540c\u3058\u884c\u304b\u3089\u7d50\u679c\u3092\u8fd4\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<p>\u3053\u306e\u65b0\u3057\u304f\u8ffd\u52a0\u3055\u308c\u305fXLOOKUP\u95a2\u6570\u304c\u79c1\u306e\u74b0\u5883\u3067\u3082\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u306e\u3067\u3001\u3055\u3063\u305d\u304f\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<p><span style=\"color: #ff0000; font-weight: bold;\">\u203b \u4e0b\u8a18\u60c5\u5831\u306fInsider\u7248\u306eOffice\u3092\u5143\u306b\u3057\u3066\u3044\u307e\u3059\u3002\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u3063\u3066\u3001\u540d\u79f0\u3084\u6a5f\u80fd\u305d\u306e\u3082\u306e\u304c\u5909\u66f4\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/span><\/p>\n<h4 class=\"style4a\">XLOOKUP\u95a2\u6570\u306e\u8aac\u660e(\u95a2\u6570\u306e\u30c0\u30a4\u30a2\u30ed\u30b0\u3088\u308a)<\/h4>\n<p>\u7bc4\u56f2\u307e\u305f\u306f\u914d\u5217\u3067\u4e00\u81f4\u306e\u691c\u7d22\u3092\u884c\u3044\u30012 \u3064\u3081\u306e\u7bc4\u56f2\u307e\u305f\u306f\u914d\u5217\u304b\u3089\u5bfe\u5fdc\u3059\u308b\u9805\u76ee\u3092\u8fd4\u3057\u307e\u3059\u3002\u65e2\u5b9a\u3067\u306f\u3001\u5b8c\u5168\u4e00\u81f4\u304c\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_01.jpg\" alt=\"\" width=\"587\" height=\"403\" class=\"alignnone size-full wp-image-12178\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_01.jpg 587w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_01-300x206.jpg 300w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/a><\/p>\n<h5 class=\"style5a\">\u4f7f\u3044\u65b9<\/h5>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">=XLOOKUP(\u691c\u67fb\u5024, \u691c\u67fb\u7bc4\u56f2, \u623b\u308a\u914d\u5217, &#x5B;\u4e00\u81f4\u30e2\u30fc\u30c9], &#x5B;\u691c\u7d22\u30e2\u30fc\u30c9])<\/pre>\n<h5 class=\"style5a\">\u5f15\u6570<\/h5>\n<table>\n<tr>\n<th>\u5f15\u6570<\/th>\n<th>\u8aac\u660e<\/th>\n<\/tr>\n<tr>\n<td>\u691c\u7d22\u5024(\u5fc5\u9808)<\/td>\n<td>\u691c\u7d22\u3059\u308b\u5024\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td>\u691c\u7d22\u7bc4\u56f2(\u5fc5\u9808)<\/td>\n<td>\u691c\u7d22\u5bfe\u8c61\u306e\u914d\u5217\u307e\u305f\u306f\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td>\u623b\u308a\u914d\u5217(\u5fc5\u9808)<\/td>\n<td>\u8fd4\u3055\u308c\u308b\u914d\u5217\u307e\u305f\u306f\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td>\u4e00\u81f4\u30e2\u30fc\u30c9(\u7701\u7565\u53ef\u80fd)<\/td>\n<td>\u691c\u7d22\u7bc4\u56f2\u5185\u306e\u5024\u306b\u5bfe\u3059\u308b\u691c\u7d22\u5024\u306e\u4e00\u81f4\u65b9\u6cd5\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li> 0\uff1a\u5b8c\u5168\u4e00\u81f4(\u65e2\u5b9a)<\/li>\n<li>-1\uff1a\u5b8c\u5168\u4e00\u81f4\u307e\u305f\u306f\u6b21\u306b\u5c0f\u3055\u3044\u9805\u76ee<\/li>\n<li> 1\uff1a\u5b8c\u5168\u4e00\u81f4\u307e\u305f\u306f\u6b21\u306b\u5927\u304d\u3044\u9805\u76ee<\/li>\n<li> 2\uff1a\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u6587\u5b57\u3068\u306e\u4e00\u81f4<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td>\u691c\u7d22\u30e2\u30fc\u30c9(\u7701\u7565\u53ef\u80fd)<\/td>\n<td>\u4f7f\u7528\u3059\u308b\u691c\u7d22\u30e2\u30fc\u30c9\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u65e2\u5b9a\u3067\u306f\u3001\u5148\u982d\u304b\u3089\u672b\u5c3e\u3078\u306e\u691c\u7d22\u304c\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n<ul>\n<li> 1\uff1a\u5148\u982d\u304b\u3089\u672b\u5c3e\u3078\u691c\u7d22(\u65e2\u5b9a)<\/li>\n<li>-1\uff1a\u672b\u5c3e\u304b\u3089\u5148\u982d\u3078\u691c\u7d22<\/li>\n<li> 2\uff1a\u30d0\u30a4\u30ca\u30ea\u691c\u7d22 (\u6607\u9806\u3067\u4e26\u3079\u66ff\u3048)<\/li>\n<li>-2\uff1a\u30d0\u30a4\u30ca\u30ea\u691c\u7d22 (\u964d\u9806\u3067\u4e26\u3079\u66ff\u3048)<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/table>\n<h4 class=\"style4a\">\u95a2\u6570\u306e\u52d5\u4f5c<\/h4>\n<p>\u307e\u305a\u306f\u3001\u4e0b\u56f3\u306e\u3088\u3046\u306a\u7c21\u5358\u306a\u8868\u3067\u3001\u5f93\u696d\u54e1\u756a\u53f7\u3092\u691c\u7d22\u5024\u3068\u3057\u3066\u3001\u540d\u524d\u304b\u3089\u6027\u5225\u307e\u3067\u3092\u53d6\u5f97\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_02.jpg\" alt=\"\" width=\"733\" height=\"554\" class=\"alignnone size-full wp-image-12179\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_02.jpg 733w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_02-300x227.jpg 300w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/a><\/p>\n<ul>\n<li>\u691c\u7d22\u5024\uff1a$G$2<\/li>\n<li>\u691c\u7d22\u7bc4\u56f2\uff1a$A$2:$A$21<\/li>\n<li>\u623b\u308a\u914d\u5217\uff1a$B$2:$E$21<\/li>\n<li>\u5f0f\uff1a=XLOOKUP($G$2,$A$2:$A$21,$B$2:$E$21)<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_03.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_03.jpg\" alt=\"\" width=\"936\" height=\"575\" class=\"alignnone size-full wp-image-12180\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_03.jpg 936w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_03-300x184.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_03-768x472.jpg 768w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/a><\/p>\n<p>\u623b\u308a\u914d\u5217\u3068\u3057\u3066\u8907\u6570\u5217\u6307\u5b9a\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u7d50\u679c\u306f\u4e0b\u56f3\u306e\u3088\u3046\u306b<a href=\"https:\/\/support.office.com\/ja-jp\/article\/205c6b06-03ba-4151-89a1-87a7eb36e531\" title=\"\u52d5\u7684\u914d\u5217\u3068\u30b9\u30d4\u30eb\u914d\u5217\u306e\u52d5\u4f5c - Office \u30b5\u30dd\u30fc\u30c8\" target=\"_blank\" rel=\"noopener noreferrer\">\u30b9\u30d4\u30eb<\/a>(\u300c<a href=\"http:\/\/officetanaka.net\/excel\/excel2016\/13.htm\" title=\"Office TANAKA - Excel 2016\u30ec\u30d3\u30e5\u30fc\u300cExcel\u306e\u4f7f\u3044\u65b9\u304c\u6fc0\u5909\u3059\u308b\u300c\u30b9\u30d4\u30eb\u300d\u300d\" target=\"_blank\" rel=\"noopener noreferrer\">Excel\u306e\u4f7f\u3044\u65b9\u304c\u6fc0\u5909\u3059\u308b\u300c\u30b9\u30d4\u30eb\u300d<\/a>\u300d\u53c2\u7167)\u3067\u8fd4\u3063\u3066\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_04.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_04.jpg\" alt=\"\" width=\"556\" height=\"125\" class=\"alignnone size-full wp-image-12181\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_04.jpg 556w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_04-300x67.jpg 300w\" sizes=\"auto, (max-width: 556px) 100vw, 556px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_05.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_05.gif\" alt=\"\" width=\"1175\" height=\"554\" class=\"alignnone size-full wp-image-12182\" \/><\/a><\/p>\n<p>\u3082\u3061\u308d\u3093\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306b\u5f15\u6570\u3068\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">=XLOOKUP($G$2,\u30b5\u30f3\u30d7\u30eb\u30c6\u30fc\u30d6\u30eb&#x5B;\u5f93\u696d\u54e1\u756a\u53f7],\u30b5\u30f3\u30d7\u30eb\u30c6\u30fc\u30d6\u30eb&#x5B;&#x5B;\u540d\u524d]:&#x5B;\u6027\u5225]])<\/pre>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_06.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_06.jpg\" alt=\"\" width=\"1198\" height=\"558\" class=\"alignnone size-full wp-image-12183\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_06.jpg 1198w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_06-300x140.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_06-768x358.jpg 768w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_06-1024x477.jpg 1024w\" sizes=\"auto, (max-width: 1198px) 100vw, 1198px\" \/><\/a><\/p>\n<p>\u5217\u3067\u306f\u306a\u304f\u884c\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u4e0b\u56f3\u306e\u3088\u3046\u306b\u6c34\u5e73\u65b9\u5411\u306b\u691c\u7d22\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_07.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_07.gif\" alt=\"\" width=\"1004\" height=\"260\" class=\"alignnone size-full wp-image-12184\" \/><\/a><\/p>\n<p>\u3064\u307e\u308a\u3001XLOOKUP\u95a2\u6570\u3055\u3048\u3042\u308c\u3070\u3001VLOOKUP\u95a2\u6570\u3084HLOOKUP\u95a2\u6570\u3092\u4f7f\u3046\u5fc5\u8981\u306f\u306a\u304f\u306a\u308b\u308f\u3051\u3067\u3059\u3002<\/p>\n<h4 class=\"style4a\">\u4fbf\u5229\u306a\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9<\/h4>\n<p>\u4e0a\u8a18\u306e\u901a\u308a\u3001XLOOKUP\u95a2\u6570\u306e\u7b2c4\u5f15\u6570\u30fb\u4e00\u81f4\u30e2\u30fc\u30c9\u3092\u300c<span style=\"color: #ff0000; font-weight: bold;\">2<\/span>\u300d\u3068\u3059\u308b\u3053\u3068\u3067\u3001\u691c\u7d22\u306b\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9(\u300c?\u300d(\u7591\u554f\u7b26)\u3001\u300c*\u300d(\u30a2\u30b9\u30bf\u30ea\u30b9\u30af)\u3001\u300c~\u300d(\u30c1\u30eb\u30c0))\u3092\u7528\u3044\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<ul>\n<li>?\uff1a\u4efb\u610f\u306e\u4e00\u6587\u5b57\u3092\u8868\u3057\u307e\u3059\u3002<\/li>\n<li>*\uff1a\u4efb\u610f\u306e\u6587\u5b57\u6570\u306e\u6587\u5b57\u5217\u3092\u8868\u3057\u307e\u3059\u3002<\/li>\n<li>~\uff1a\u300c?\u300d\u3084\u300c*\u300d\u3001\u300c~\u300d\u3092\u691c\u7d22\u3059\u308b\u5834\u5408\u306b\u3001\u691c\u7d22\u6587\u5b57\u5217\u306e\u524d\u306b\u30c1\u30eb\u30c0\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_08.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_08.jpg\" alt=\"\" width=\"1268\" height=\"660\" class=\"alignnone size-full wp-image-12185\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_08.jpg 1268w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_08-300x156.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_08-768x400.jpg 768w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_08-1024x533.jpg 1024w\" sizes=\"auto, (max-width: 1268px) 100vw, 1268px\" \/><\/a><\/p>\n<div id=\"single_banner_area2\" class=\"clearfix one_banner\">\n<div class=\"single_banner single_banner_left\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- \u8a18\u4e8b\u4e2d(\u30c7\u30a3\u30b9\u30d7\u30ec\u30a4\u5e83\u544a\u30e6\u30cb\u30c3\u30c8) -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-7306936664602087\"\r\n     data-ad-slot=\"5429724765\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<div class=\"single_banner single_banner_right\">\n<a href=\"\" target=\"_blank\"><img decoding=\"async\" src=\"\" alt=\"\" title=\"\" \/><\/a>\n<\/div>\n<\/div>\n\n<h4 class=\"style4a\">\u304a\u308f\u308a\u306b<\/h4>\n<p>\u4eca\u56de\u3001\u8efd\u304f<a href=\"https:\/\/support.office.com\/ja-jp\/article\/B7FD680E-6D10-43E6-84F9-88EAE8BF5929\" title=\"XLOOKUP \u95a2\u6570 - Office \u30b5\u30dd\u30fc\u30c8\" target=\"_blank\" rel=\"noopener noreferrer\">XLOOKUP<\/a>\u95a2\u6570\u3092\u89e6\u3063\u3066\u307f\u307e\u3057\u305f\u304c\u3001<span style=\"color: #ff0000; font-weight: bold;\">\u975e\u5e38\u306b\u4fbf\u5229<\/span>\u3067\u3059\u3002\u4e0a\u3067\u3082\u66f8\u304d\u307e\u3057\u305f\u304c\u3001\u3053\u308c\u3055\u3048\u3042\u308c\u3070VLOOKUP\u95a2\u6570\u3084HLOOKUP\u95a2\u6570\u306f\u5fc5\u8981\u7121\u3044\u4f4d\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n<p>\u305f\u3060\u3001\u500b\u4eba\u7684\u306b\u306f\u3001<span style=\"color: #ff0000; font-weight: bold;\">\u201cXLOOKUP\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u4e0b\u4f4d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u4f7f\u7528\u3067\u304d\u306a\u3044\u306e\u306f\u5927\u304d\u306a\u5f31\u70b9\u201d<\/span>\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<br \/>\n(XLOOKUP\u95a2\u6570\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306eExcel\u3067\u306f\u3001\u300c_xlfn.XLOOKUP\u300d\u3068\u306a\u308a\u3001#NAME?\u30a8\u30e9\u30fc\u3092\u8fd4\u3057\u307e\u3059\u3002)<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_09.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_09.jpg\" alt=\"\" width=\"1207\" height=\"355\" class=\"alignnone size-full wp-image-12186\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_09.jpg 1207w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_09-300x88.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_09-768x226.jpg 768w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_XLOOKUP_Function_09-1024x301.jpg 1024w\" sizes=\"auto, (max-width: 1207px) 100vw, 1207px\" \/><\/a><\/p>\n<p>2019\u5e749\u6708\u6642\u70b9\u3067\u306f\u3001\u307e\u3060Insider\u7248\u306eExcel\u3067\u3057\u304b\u4f7f\u7528\u3067\u304d\u306a\u3044\u305f\u3081\u3001\u9867\u5ba2\u3084\u53d6\u5f15\u5148\u3068\u3044\u3063\u305f\u3001Office\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c\u7d71\u4e00\u3055\u308c\u3066\u3044\u306a\u3044\u74b0\u5883\u4e0b\u3067\u30d5\u30a1\u30a4\u30eb\u3092\u3084\u308a\u53d6\u308a\u3059\u308b\u5834\u5408\u306b\u306f\u3001\u672c\u95a2\u6570\u3092\u4f7f\u7528\u3057\u306a\u3044\u65b9\u304c\u826f\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u4e0b\u8a18\u8a18\u4e8b\u306e\u901a\u308a\u30012019\u5e748\u6708\u672b\u306bVLOOKUP\u95a2\u6570\u3084HLOOKUP\u95a2\u6570\u306e\u5f8c\u7d99\u3068\u306a\u308b\u65b0\u3057\u3044\u95a2\u6570\u300cXLOOKUP\u300d\u95a2\u6570\u304c\u767a\u8868\u3055\u308c\u307e\u3057\u305f\u3002 #OfficeInsiders, we are excited to introdu [&hellip;]","protected":false},"author":1,"featured_media":7111,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[[Excel]XLOOKUP\u95a2\u6570\u3067\u3088\u308a\u7c21\u5358\u306b\u5024\u3092\u691c\u7d22\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\uff01]","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,48],"tags":[],"class_list":["post-12177","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-excel-office"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Excel.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-3ap","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/12177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12177"}],"version-history":[{"count":2,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/12177\/revisions"}],"predecessor-version":[{"id":12188,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/12177\/revisions\/12188"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7111"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}