{"id":16176,"date":"2021-12-13T15:58:39","date_gmt":"2021-12-13T06:58:39","guid":{"rendered":"https:\/\/www.agentgate.jp\/carechan\/change\/?post_type=carekotsu&#038;p=16176"},"modified":"2021-12-13T15:58:41","modified_gmt":"2021-12-13T06:58:41","slug":"index%e9%96%a2%e6%95%b0%e3%81%a8match%e9%96%a2%e6%95%b0%e3%81%ab%e3%81%af%e3%81%a9%e3%82%93%e3%81%aa%e9%81%95%e3%81%84%e3%81%8c%e3%81%82%e3%82%8b%ef%bc%9f%e4%bd%bf%e3%81%84%e6%96%b9%e3%82%84%e6%9b%b8","status":"publish","type":"carekotsu","link":"https:\/\/www.agentgate.jp\/carechan\/change\/carekotsu\/16176\/","title":{"rendered":"INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u306b\u306f\u3069\u3093\u306a\u9055\u3044\u304c\u3042\u308b\uff1f\u4f7f\u3044\u65b9\u3084\u66f8\u5f0f\u3092\u5b66\u307c\u3046"},"content":{"rendered":"\n<p>\u30a8\u30af\u30bb\u30eb\u3092\u4f7f\u7528\u3057\u3066\u4ed5\u4e8b\u3092\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u3042\u3089\u3086\u308b\u95a2\u6570\u3092\u899a\u3048\u305f\u308a\u3001\u30c4\u30fc\u30eb\u3092\u899a\u3048\u305f\u308a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3068\u306f\u3044\u3063\u3066\u3082\u3001\u3072\u3068\u3064\u3072\u3068\u3064\u899a\u3048\u3088\u3046\u3068\u3057\u3066\u3082\u3001\u5b9f\u969b\u306b\u4f7f\u3046\u30b7\u30fc\u30f3\u304c\u30a4\u30e1\u30fc\u30b8\u3067\u304d\u306a\u3051\u308c\u3070\u306a\u304b\u306a\u304b\u30a4\u30f3\u30d7\u30c3\u30c8\u3059\u308b\u3053\u3068\u306f\u56f0\u96e3\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30a8\u30af\u30bb\u30eb\u306e\u30c6\u30fc\u30d6\u30eb\u5185\u306b\u3042\u308b\u9805\u76ee\u3092\u3001\u95a2\u6570\u3092\u7528\u3044\u3066\u5225\u306e\u30bb\u30eb\u5185\u306b\u53c2\u7167\u3055\u305b\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3002<\/p>\n\n\n\n<p>\u4e3b\u306b\u4f7f\u3046\u306e\u306f\u3001<\/p>\n\n\n\n<ul><li><strong>INDEX\u95a2\u6570<\/strong><\/li><li><strong>MATCH\u95a2\u6570<\/strong><\/li><\/ul>\n\n\n\n<p>\u306e2\u3064\u306e\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<p>INDEX\u95a2\u6570\u3084MATCH\u95a2\u6570\u306e\u305d\u308c\u305e\u308c\u306e\u9055\u3044\u3068\u4f7f\u7528\u3059\u308b\u305f\u3081\u306e\u66f8\u5f0f\u3001\u8907\u5408\u3057\u3066\u3069\u306e\u3088\u3046\u306a\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u304b\u306b\u3064\u3044\u3066\u3001\u4e3b\u306a\u4f7f\u3044\u65b9\u3068\u5fdc\u7528\u3092\u4f7f\u3046\u30b7\u30fc\u30f3\u3092\u30a4\u30e1\u30fc\u30b8\u3057\u306a\u304c\u3089\u899a\u3048\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2>INDEX\u95a2\u6570\u3068\u306f<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img width=\"1280\" height=\"995\" src=\"https:\/\/www.agentgate.jp\/carechan\/change\/wp-content\/uploads\/2021\/12\/image25.png\" alt=\"\" class=\"wp-image-16061\"\/><\/figure>\n\n\n\n<p>INDEX\u95a2\u6570\u306f\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u306a\u3069\u304b\u3089\u6307\u5b9a\u3057\u305f\u5024\u3001\u307e\u305f\u306f\u305d\u306e\u5024\u3092\u53c2\u7167\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001INDEX\u95a2\u6570\u306f2\u3064\u306e\u4f7f\u3044\u65b9\u304c\u3042\u308a\u307e\u3059\u304b\u3089\u4f7f\u3044\u3084\u3059\u3044\u65b9\u3092\u9078\u3073\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3>\u914d\u5217\u5f62\u5f0f\u3068\u66f8\u5f0f<\/h3>\n\n\n\n<p>\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u3084\u30bb\u30eb\u306e\u914d\u5217\u306b\u5bfe\u3059\u308b\u5024\u3092\u6c42\u3081\u308b\u5834\u5408\u306f\u3010\u914d\u5217\u5f62\u5f0f\u3011\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u914d\u5217\u5f62\u5f0f\u3068\u306f\u3001\u884c\u3068\u5217\u306e\u6570\u5024\u306b\u3088\u3063\u3066\u9078\u3093\u3060\u30c6\u30fc\u30d6\u30eb\u3084\u30bb\u30eb\u306e\u5024\u3092\u8fd4\u3059\u5f62\u5f0f\u3067\u3059\u3002<\/p>\n\n\n\n<p>INDEX\u95a2\u6570\u306e1\u3064\u3081\u306e\u5f15\u6570\u304c\u914d\u5217\u5b9a\u6570\u3067\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u914d\u5217\u5f62\u5f0f\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u5834\u5408\u306e\u66f8\u5f0f\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>INDEX(\u914d\u5217,\u884c\u6570\u5024,[\u5217\u6570\u5024])<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u66f8\u5f0f\u306b\u306f3\u7a2e\u985e\u306e\u5f15\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u5f15\u65701:\u914d\u5217<\/h4>\n\n\n\n<p>INDEX\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3046\u3048\u3067\u5165\u529b\u5fc5\u9808\u306e\u5f15\u6570\u3067\u3001\u30bb\u30eb\u306e\u7bc4\u56f2\u3084\u914d\u5217\u306e\u5b9a\u6570\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u8a18\u5165\u3057\u306a\u3051\u308c\u3070\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<h4>\u5f15\u65702:\u884c\u756a\u53f7<\/h4>\n\n\n\n<p>\u884c\u6570\u5024\u3092\u6c42\u3081\u308b\u5834\u5408\u306f\u5165\u529b\u5fc5\u9808\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u914d\u5217\u306e\u306a\u304b\u306b\u3042\u308a\u3001\u5024\u3092\u8fd4\u3059\u884c\u3092\u884c\u306e\u5024\u306b\u3088\u3063\u3066\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5217\u6570\u5024\u306e\u307f\u3092\u6c42\u3081\u308b\u5834\u5408\u306f\u7701\u7565\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h4>\u5f15\u65703:\u5217\u6570\u5024<\/h4>\n\n\n\n<p>\u5217\u6570\u5024\u306b\u3088\u3063\u3066\u5024\u3092\u8fd4\u3059\u5834\u6240\u3092\u6307\u5b9a\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u5217\u6570\u5024\u3082\u884c\u756a\u53f7\u304a\u306a\u3058\u304f\u7701\u7565\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h3>\u30bb\u30eb\u7bc4\u56f2\u5f62\u5f0f<\/h3>\n\n\n\n<p>\u30bb\u30eb\u7bc4\u56f2\u5f62\u5f0f\u306f\u3001\u6307\u5b9a\u3057\u305f\u884c\u3068\u5217\u304c\u4ea4\u5dee\u3059\u308b\u90e8\u5206\u306b\u3042\u308b\u30bb\u30eb\u3092\u6c42\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u53c2\u7167\u304c\u96a3\u63a5\u3057\u3066\u304a\u3089\u305a\u96e2\u308c\u3066\u4f5c\u6210\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306b\u306f\u3001\u53c2\u7167\u3059\u308b\u7bc4\u56f2\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u6570\u5024\u3092\u6c42\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u5834\u5408\u306e\u66f8\u5f0f\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>INDEX(\u53c2\u7167,\u884c\u756a\u53f7,[\u5217\u756a\u53f7],\u9818\u57df\u756a\u53f7])<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306e\u5f15\u6570\u306e\u89e3\u8aac\u3092\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u53c2\u7167<\/h4>\n\n\n\n<p>1\u3064\u3001\u3082\u3057\u304f\u306f\u8907\u6570\u306e\u30bb\u30eb\u306e\u53c2\u7167\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\u4f7f\u7528\u3059\u308b\u305f\u3081\u5165\u529b\u306f\u5fc5\u9808\u3067\u3059\u3002<\/p>\n\n\n\n<h4>\u884c\u756a\u53f7<\/h4>\n\n\n\n<p>\u7bc4\u56f2\u5185\u306e\u30bb\u30eb\u3092\u6c42\u3081\u308b\u5834\u5408\u306b\u3001\u8fd4\u3059\u30bb\u30eb\u306e\u884c\u3092\u884c\u756a\u53f7\u3092\u7528\u3044\u3066\u6307\u5b9a\u3059\u308b\u305f\u3081\u3001\u5165\u529b\u306f\u5fc5\u9808\u3067\u3059\u3002<\/p>\n\n\n\n<h4>\u5217\u756a\u53f7<\/h4>\n\n\n\n<p>\u5217\u756a\u53f7\u306f\u4efb\u610f\u306b\u306a\u308a\u307e\u3059\u3002\u30bb\u30eb\u53c2\u7167\u3092\u8fd4\u3059\u30bb\u30eb\u306e\u4f4d\u7f6e\u3092\u5217\u756a\u53f7\u3092\u7528\u3044\u3066\u6570\u5024\u3067\u8fd4\u3059\u969b\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u9818\u57df\u756a\u53f7<\/h4>\n\n\n\n<p>\u9818\u57df\u756a\u53f7\u306f\u4efb\u610f\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3>INDEX\u95a2\u6570\u306e\u57fa\u672c\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/gRZ2biszAXvf9HB1mRZllPmsgBB_JwTk33eOAwu5bfe7rhTZ39x1HQSRgNs7gK-L2yPcl-RlzCvBSV0bUnKKKAg_Ad4eaeBCDq2NODPk9i2PuOgpZJ1kV3gv5nfwJpq8rANebgnS\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3067\u306f\u5546\u54c1\u540d\u304c\u672a\u8a18\u5165\u306a\u306e\u3067\u3001INDEX\u95a2\u6570\u3092\u4f7f\u3063\u3066\u8868\u793a\u3055\u305b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u306f3\u3064\u306e\u5f15\u6570\u3092\u4f7f\u3063\u305f\u5165\u529b\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n\n\n\n<p>D11\u306e\u30bb\u30eb\u306b\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u95a2\u6570\u3092\u5165\u529b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/7bOsHDLtNI5bI5C33mETeklmGe00LfepQDbTEoEXqvRVDwgXA-xyMvf7HVCkHZRPOX4v6R6NDdPwekz33JRE0N9L7Lr-aDsCI3QEEBoTHy_noXZDJwxYKkUls7qjXCAS47ODUaFG\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=INDEX(C4:C7,1,1)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u3053\u306e\u95a2\u6570\u306b\u306f\u3001C4\u304b\u3089C7\u306e\u30bb\u30eb\u306e\u306a\u304b\u304b\u30891\u884c\u76ee\u3001\u3055\u3089\u306b1\u5217\u76ee\u306e\u6570\u5024\u3092\u8fd4\u3059\u610f\u5473\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u3092\u5165\u529b\u3057\u305f\u3089\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/i9BnIFrjtEhEtfVrr2oUMtxoUKQBu2jMJxJbJ0SW2F5eEKWSMa3-bNLbqllxAP88vB1upAd40xBkuSeJwdFK0qhA-uZ7MJhZu2d5BVcGPHc5VtJjJKyIvfX0RxZnwspaOiDONKth\" alt=\"\"\/><\/figure>\n\n\n\n<p>INDEX\u95a2\u6570\u306b\u3088\u3063\u3066\u30ab\u30b9\u30df\u30bd\u30a6\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3067\u306f\u3064\u304e\u306b4\u3064\u306e\u5f15\u6570\u3092\u4f7f\u3063\u305f\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u5834\u5408\u306e\u95a2\u6570\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=INDEX(B4:E7,2,2,1)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/bs9Mu_dqOEUlJrZ9ieScommvmtmhovZMWUBqFveRBZ1GBqKVOYSssC1UuMuHRPriSlI2twlci59ktSQy82gwUGBkzdMjU9VQ1CJCzsoe9g0wzCrq3CCOlIK_nRIxJekbKaMV8kKG\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u307e\u305a\u306fB4\u304b\u3089C7\u306e\u30bb\u30eb\u3092\u7bc4\u56f2\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u30d0\u30e9\u306f\u7bc4\u56f2\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e2\u884c\u76ee\u30012\u5217\u76ee\u306b\u3042\u308b\u305f\u3081\u30102,2,\u3011\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u9818\u57df\u756a\u53f7\u306f\u30101\u3011\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u554f\u984c\u306a\u304f\u5165\u529b\u3067\u304d\u305f\u3089\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/8ADxtvUWN80Dub9vI0pH3Q0HQkvF4T20QhNlWzacFsAg1uwOHeON4Mx4ELjOxuRiWDOjRNrcPXbTpWFfAwTeHu-ZDbf7Qszb9uR65G8Xe77nvCcdl-UWGhUTTebjQJAg804Z14nq\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30d0\u30e9\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/aoN8U-gaGjyKu7I2lAFHhOxYsCK-83W0bmARx_Fjki7F7ylNjgqzneBfSpagUJ8eCBenajdXpoZG7zL3oQ31zI5yAbHpPVx3ObJRuiLoGDhcsuLuX0-Hc5Qtxnvz7obbzO9o_7BL\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u540c\u3058\u8981\u9818\u3067\u30ab\u30fc\u30cd\u30fc\u30b7\u30e7\u30f3\u3082\u8868\u793a\u3055\u305b\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u30673\u3064\u306e\u5f15\u6570\u3092\u4f7f\u7528\u3057\u305fINDEX\u95a2\u6570\u306e\u5165\u529b\u65b9\u6cd5\u3068\u30014\u3064\u306e\u5f15\u6570\u3092\u4f7f\u7528\u3057\u305fINDEX\u95a2\u6570\u306e2\u7a2e\u985e\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h3>\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u3063\u3066INDEX\u95a2\u6570\u3092\u4f7f\u3046\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u30a8\u30af\u30bb\u30eb\u306b\u306f\u624b\u5165\u529b\u3067\u95a2\u6570\u3092\u4f5c\u6210\u3057\u3066\u3044\u304f\u65b9\u6cd5\u3068\u3001\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u7528\u3057\u305f\u95a2\u6570\u306e\u4f5c\u6210\u65b9\u6cd5\u3068\u306e2\u7a2e\u985e\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u3053\u3067\u306f\u3001\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u3063\u305fINDEX\u95a2\u6570\u306e\u5165\u529b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u306e\u610f\u5473\u3084\u3001\u5f15\u6570\u306e\u6587\u8a00\u3001\u5f15\u6570\u306e\u5f79\u5272\u3092\u307e\u3060\u5b8c\u5168\u306b\u30de\u30b9\u30bf\u30fc\u3067\u304d\u3066\u3044\u306a\u3044\u65b9\u306b\u306f\u3001\u624b\u5165\u529b\u3088\u308a\u3082\u308f\u304b\u308a\u3084\u3059\u304f\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3067\u3001\u307e\u305a\u306f\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u3063\u305f\u3084\u308a\u65b9\u3067\u5b9f\u8df5\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/ij8CRny7Ai0zMh7NaHnVcgKsfh1gaf6SKZ2cCNvWC_GkVePqdxxYWtyRhimmfHAskva5mCLQmRYhDOc32mRwPVn9EP5213zgUAH23Zrvg4i2WeAUbJW1cib0mZ991l248f4iLi_K\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5148\u307b\u3069\u4f7f\u7528\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3064\u304e\u306f\u4fa1\u683c\u306e\u90e8\u5206\u304c\u672a\u8a18\u5165\u3068\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001INDEX\u95a2\u6570\u3092\u4f7f\u3063\u3066\u4fa1\u683c\u90e8\u5206\u3092\u6c42\u3081\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/4OHR8HlCkbgOYzmfLF9f5ct18q8bfWZQiBMsnVbn5nZbsbfmcrpnnnVyCTpPghrTlFti5RFwDU8ZCxY5kEQI-K-jLCZoNPoYmqcCS8CIayWvDaFnnP8n1zTepN-LjCem4Rp-dSri\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u95a2\u6570\u306e\u633f\u5165\u90e8\u5206\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u3059\u308b\u3068\u5f15\u6570\u306e\u9078\u629e\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u304d\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/Wsp_UhHGbjQxVQxYL1w6GpeUCoJut_xfXsMyI0k58rFk3czFrJ8eQddGbGb9PF2Ilq6VtiB6lER9uX4ibXyZwCuFx7tvQaWepr9gC7iWnaoD1hcEuZVk1BhD6Ry9db2bJ1f0UnO4\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li><strong>\u914d\u5217,\u884c\u756a\u53f7,\u5217\u756a\u53f7<\/strong><\/li><li><strong>\u53c2\u7167,\u884c\u756a\u53f7,\u5217\u756a\u53f7,\u9818\u57df\u756a\u53f7<\/strong><\/li><\/ul>\n\n\n\n<p>\u306e\u3069\u3061\u3089\u3092\u4f7f\u7528\u3059\u308b\u306e\u304b\u3092\u554f\u308f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3069\u3061\u3089\u3067\u3082\u554f\u984c\u306a\u304f\u4f5c\u6210\u3067\u304d\u307e\u3059\u304c\u3001\u9818\u57df\u756a\u53f7\u306a\u3069\u306f\u7279\u306b\u4e0d\u8981\u306a\u306e\u3067\u3001\u4eca\u56de\u306f\u524d\u8005\u306e<strong>\u914d\u5217,\u884c\u756a\u53f7,\u5217\u756a\u53f7<\/strong>\u3092\u4f7f\u3063\u3066INDEX\u95a2\u6570\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><strong>\u914d\u5217,\u884c\u756a\u53f7,\u5217\u756a\u53f7<\/strong>\u3092\u9078\u3093\u3060\u3089\u3010OK\u3011\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/QW2f1SfX3hv0PHvj8ur_oQzgi12D9r4Z6G-zmwzziJ17ReOHrwSWv8XLRIUcQsGff0O7ryn_hXQLkqmREz8jwSVvnOYvK7sZ2Jk7u9oN3KhZtSH83nRAkqEZRXLcdAkST3_KeFLw\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u95a2\u6570\u306e\u5f15\u6570\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u3044\u305f\u3089\u3001\u4e0a\u304b\u3089\u9806\u306b\u3001\u914d\u5217\u3001\u884c\u756a\u53f7\u3001\u5217\u756a\u53f7\u3092\u8a18\u5165\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u4fa1\u683c\u3092\u53c2\u7167\u3057\u305f\u3044\u30bb\u30eb\u306fD4\u304b\u3089D7\u3067\u3042\u308b\u305f\u3081\u3001D4\u304b\u3089D7\u306e\u30bb\u30eb\u3092\u30de\u30a6\u30b9\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/a_mYGR1pT62AYi4M6bbZ1uo_5zMPGvniOwmkrHDLd6KKUxQ5YMLrTKDNdAbO-crFXzRllnjRn0zUb8d51WOkAo-erDKxUI27fwn9-KIGGbMxWSznXMqzTcrvpNmdI111gFIs1fh6\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u9078\u629e\u3057\u305f\u3042\u3068\u3001\u3010F4\u3011\u30ad\u30fc\u3092\u62bc\u3059\u3053\u3068\u3067\u3010$\u3011\u304c\u4ed8\u304d\u3001\u3010\u7d76\u5bfe\u53c2\u7167\u3011\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u7d76\u5bfe\u53c2\u7167\u3092\u3057\u3066\u304a\u304f\u3053\u3068\u3067\u3001\u53c2\u7167\u7bc4\u56f2\u3092\u305a\u3089\u3059\u3053\u3068\u306a\u304f\u53c2\u7167\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\u306e\u3067\u3001F4\u30ad\u30fc\u3092\u62bc\u3059\u30af\u30bb\u3092\u4ed8\u3051\u3066\u304a\u304f\u3068\u826f\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u3064\u304e\u306b\u884c\u756a\u53f7\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/27CzgJYgNlM915NZipNlVebEH9a6OlyS2_qlac9Oz2dJ5tsvl8-NBNP5BA7Tf_QX4eV8NxVgVTEvTyf0_MfnpKGl5kWjczzmHsWneBxGDhIQ0NwTcdGVJXhBcv_itryZ1XO7Y1uG\" alt=\"\"\/><\/figure>\n\n\n\n<p>D4\u304b\u3089D7\u306e\u7bc4\u56f2\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u306a\u304b\u306b\u3001\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u4fa1\u683c\u306f\u4e00\u884c\u76ee\u306b\u8a18\u5165\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u305f\u3081\u3053\u306e\u90e8\u5206\u306f\u30101\u3011\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6700\u5f8c\u306b\u5217\u756a\u53f7\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/qKmPi2GboDjX8hfc9Z-RnONVtmyXOgHXNT-u6ROnuzDNlr96Cn_FbmDiaD0y-v1Ve7wdJqP-0td3pl-KEdp5Fq54hDlfWmIN5YJvuG2FYSvQz66I-9hSIJWySyHtRr131LGU7Zhw\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u90e8\u5206\u3082\u3001\u7bc4\u56f2\u6307\u5b9a\u3057\u305f\u90e8\u5206\u306f\u4fa1\u683c\u306e\u307f\u306e\u30bb\u30eb\u3067\u3042\u308b\u305f\u3081\u30101\u3011\u3092\u8a18\u5165\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/rSXTmLitJYxQhwpQ3XtddXz0kvpKBaq1xbdKDu9C8DaAKzw0_lDIj0zgnISCNyLbHf3DsSubieg4A3kRMTWeQM7gOak1_N4MLYPqsrfx97XqChwDQAa-YE5Iz53WNVo1EzhiC1LB\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u5f15\u6570\u304c\u4f5c\u6210\u3067\u304d\u305f\u3089\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/d4lJz8xsdOtl-38In9clemhLN_kBeDoE4LRV-DlPL6voqjI1Kb-FtFJHeobRdzLPW4taKKxwqnT-cc6I5-Q0RdwpKdDyJisxkjiycamQyA5HURVzUtNUQ0rSYZwHT8tZmWtMOhLi\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u95a2\u6570\u304c\u7121\u4e8b\u5165\u529b\u3055\u308c\u3001\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u4fa1\u683c\u90e8\u5206\u306b\u3010550\u3011\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/KLrIQQXMkqH4eLJC2bxGlcziOXtWs8qov8_lbzTr7AmW1uA6PpuksV0Q6v2JgoJQl30UJyABoC122kI59YKRQZAlh9DmRkZduP1arwrXQpdxE71-0ki8GdlzMYdqrz6lmnQ1oz5b\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u9006\u306b\u3001\u4eca\u5ea6\u306f\u53c2\u7167,\u884c\u756a\u53f7,\u5217\u756a\u53f7,\u9818\u57df\u756a\u53f7\u306e\u65b9\u3092\u4f7f\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/bD827yMqViklBatFciGnTgo_Xr8a-vUgu7wAUQlHVlJSymbSQIzFOz6AdCk5CLGUtmpn40F9rza9MirlQT3SXt9vaGNU09v59SOyBxbqQfcEyK209kQc2RcDKc7DPRkFSsaSC5ca\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u53c2\u7167\u90e8\u5206\u306b\u306fB4\u30bb\u30eb\u304b\u3089E7\u30bb\u30eb\u307e\u3067\u3092\u7bc4\u56f2\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/7-0xvuQX3eIbtD5_fGmHYOgTYrRbdpNXqmSlVGKFXLumnvfTV4afSCQqoToTSPQ1s1OQWgtiof-VgH0a22dkbxgt1Ob_gFUjebC66cf5XrzQYCtwiP3I1utvhZzW1p_kxAmoJsTp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u305d\u306e\u5f8c\u3001\u3055\u304d\u307b\u3069\u3068\u540c\u3058\u3088\u3046\u306b\u3010F4\u3011\u30ad\u30fc\u3092\u62bc\u3057\u3066\u3010\u7d76\u5bfe\u53c2\u7167\u3011\u3078\u3068\u5207\u308a\u66ff\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/gScmd5iw43JacQiihHUcb03yUN84UcGFThXVpBO9sQpI66VBXJgyhc1rtr0tmjP6UoYom-jUwki0ChN5SYlAnKloMCiwYp-_Xcf134oi0b5zzkMNGPLnBxcGRwPTcPYiewYo5afa\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3064\u304e\u306b\u884c\u756a\u53f7\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u4fa1\u683c\u306fB4\u304b\u3089E7\u307e\u3067\u306e\u7bc4\u56f2\u306e\u306a\u304b\u30671\u884c\u76ee\u306b\u3042\u308b\u305f\u3081\u30101\u3011\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/O5h5mEOwANRzjAYLzOSDOP-KM9sx8zzu-zxitybssciZ12YXVW3XyeYjEoYwFG8RM2BMBRFoYPWwLOQNlFYIegJn_s3_0ocYfoFvCASmAPP9Nsi-SyvWNaCQpyEN0GtZr4E4zX1B\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u5217\u756a\u53f7\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30ab\u30b9\u30df\u30bd\u30a6\u306fB4\u304b\u3089E7\u307e\u3067\u306e\u7bc4\u56f2\u306e\u306a\u304b\u3067\u4fa1\u683c\u306f3\u5217\u76ee\u306b\u3042\u308b\u305f\u3081\u30103\u3011\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6700\u5f8c\u306b\u9818\u57df\u756a\u53f7\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/aItNwT5uA5j9f4n68H5FvGeGCtrll7j5t7IiyxSDagyEa7N91dj-b_4EunBpbCjnBvaPJdgjZzQqsIxGgkx3_dxaTlI0qcyssN5S77yJbN8Dc4a2sDGFQq3PigJye8En2DWuS_WI\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u9818\u57df\u756a\u53f7\u306f\u6700\u521d\u306b\u9078\u629e\u3001\u3082\u3057\u304f\u306f\u5165\u529b\u3055\u308c\u305f\u9818\u57df\u306e\u9818\u57df\u756a\u53f7\u306e\u5834\u5408\u306f1\u30012\u756a\u76ee\u306b\u5165\u529b\u3055\u308c\u305f\u9818\u57df\u3067\u3042\u308b\u5834\u5408\u306f2\u3068\u306a\u308b\u305f\u3081\u3001\u3053\u3053\u3067\u306f\u30101\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/w0QZBxL5_yYgG0YRUgMaBXMMwQcdO1I5-1tMVppSsegqEKGz1blKDnrvhdapmpUsUFmgqbZHFEkeEgHcCBmgXiAy3Z4beKsCWP0i6qpxgaXpdfFClcHtkK7XSHUQdxsE-PqhGRtl\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306bINDEX\u95a2\u6570\u306e\u5f15\u6570\u304c\u5165\u529b\u3067\u304d\u305f\u3089\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/Gm3pgtRWTircYuDe1hn9icIgaEiPBdugCrb3EIPMd3FBs6GZSDeEDWj1s64yFXZ-UxZq8SHIg-clK438Cz0KfCpT5jJtNHa2WF8XO46AIOofGWhUMTDJCr0UOWXuM0jwDrztC5GX\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3082\u3046\u3072\u3068\u3064\u306e\u65b9\u6cd5\u3092\u7528\u3044\u3066\u3082\u3001\u30ab\u30fc\u30cd\u30fc\u30b7\u30e7\u30f3\u306e\u4fa1\u683c\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h2>MATCH\u95a2\u6570<\/h2>\n\n\n\n<p>MATCH\u95a2\u6570\u306f\u30bb\u30eb\u7bc4\u56f2\u6307\u5b9a\u3057\u305f\u90e8\u5206\u304b\u3089\u898b\u3066\u3001\u6307\u5b9a\u3057\u305f\u5024\u304c\u5217\u5185\u306e\u4f55\u756a\u76ee\u306b\u3042\u308b\u304b\u3092\u691c\u7d22\u3057\u3001\u6570\u5024\u3092\u8fd4\u3059\u305f\u3081\u306e\u95a2\u6570\u3092\u6307\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u5834\u5408\u306e\u66f8\u5f0f\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>MATCH(\u691c\u67fb\u5024,\u691c\u67fb\u7bc4\u56f2,[\u7167\u5408\u306e\u578b])<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306e\u5f15\u6570\u306e\u89e3\u8aac\u3092\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u691c\u67fb\u5024<\/h4>\n\n\n\n<p>\u691c\u67fb\u7bc4\u56f2\u306e\u4e2d\u3067\u7167\u5408\u3092\u3059\u308b\u305f\u3081\u306e\u5024\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002\u5165\u529b\u306f\u5fc5\u9808\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u691c\u67fb\u7bc4\u56f2<\/h4>\n\n\n\n<p>\u691c\u67fb\u7bc4\u56f2\u306f\u691c\u7d22\u3059\u308b\u30bb\u30eb\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002\u5165\u529b\u306f\u5fc5\u9808\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u7167\u5408\u306e\u578b<\/h4>\n\n\n\n<p>\u7167\u5408\u306e\u578b\u306f\u3010-1\u3011\u30100\u3011\u30101\u3011\u306e\u3044\u305a\u308c\u304b\u3092\u8a18\u5165\u3057\u6307\u5b9a\u3057\u307e\u3057\u3087\u3046\u3002\u7167\u5408\u306e\u578b\u306f\u306a\u304f\u3066\u3082\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<h3>MATCH\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>\u3067\u306fMATCH\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/5RGODyYOm9Y5AEFuTuMsNMy5L9Hy98loNJoX71VJ9KFGu2SIHyOvOds-y-VidD0sQnctcYlE9qRj6U5fXyfrsuTwbNEMaHcn8kSODsLkkBkjW9gM6WY07s7EX1v7qcYmmNebdofT\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30ab\u30b9\u30df\u30bd\u30a6\u306f\u4f55\u884c\u76ee\u306b\u3042\u308b\u306e\u304b\u3001\u4fa1\u683c\u306f\u4f55\u5217\u76ee\u306b\u3042\u308b\u306e\u304b\u3092\u3001MATCH\u95a2\u6570\u3092\u4f7f\u3063\u3066H2\u3001H3\u30bb\u30eb\u306b\u305d\u308c\u305e\u308c\u8868\u793a\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u306f\u30ab\u30b9\u30df\u30bd\u30a6\u304c\u4f55\u884c\u76ee\u306b\u3042\u308b\u304b\u3092\u6c42\u3081\u307e\u3059\u3002\u305d\u306e\u969b\u306e\u95a2\u6570\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/q0QuZymJxL4lFOVzc7mZgs_vR8FumagkZppeaqYObKJYvzBIOmMtpCiGgrRDHcpMhu53_qUD0q5I63hnVuf83K_3AvYoHh1pXnwRsH9G7N6H2k-6xPuTcj3BWLb3IYn3pz_mDHZy\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=MATCH(G2,C4:C7,0)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u5165\u529b\u3057\u7d42\u3048\u305f\u3089\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/RExuOF2aEOts_UPbyDRj15bJqTlVA5gLKHcfbE0pQJDN8LkB7IL2IXRoYsY9rpKNhS0WOXXes442pIZFMX-pwml9a7dDtzN09BiWMBgTRvleMVM3T-LyXq0--ScqUhfGf9Y1_gH5\" alt=\"\"\/><\/figure>\n\n\n\n<p>MATCH\u95a2\u6570\u3092\u4f7f\u3063\u3066\u30ab\u30fc\u30cd\u30fc\u30b7\u30e7\u30f3\u304c1\u884c\u76ee\u306b\u3042\u308b\u3053\u3068\u3092\u6c42\u3081\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u4fa1\u683c\u306f\u4f55\u5217\u76ee\u306b\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u306e\u304b\u3092\u6c42\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u5834\u5408\u306e\u95a2\u6570\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/3MWQG7mZnH6ZfleP7VphPs7Y7pz0sz8hkZT91rYtbOjsSooZoW16Ls7riEaseRFzwoNbBIuSSkcV5T-Kai6S9MGXgBaYRiUKCMxzMFaJEZDzMCVwm4Lmx5y_sfw_1mcyCZqlA8wZ\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=MATCH(G3,B3:E3,0)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/xXxhD8upkTLvPgvL2hRRXV9RUcNghZnCsvSBeFp7QipWT00-UUHdC3cUNWraD1yR7D8bgakANegKWPET0FFaNzokERLZbF83ug7qO7y8-GrR70Qv9wKTXI5vzGE5nOoeslRipovK\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4fa1\u683c\u304c\u4f55\u5217\u76ee\u306b\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u8868\u793a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h3>\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u3063\u3066MATCH\u95a2\u6570\u3092\u4f7f\u3046\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u3063\u305f\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/HtOtYC4vtlsJKEhBwuQYN9zGvGZd-3bjPon6GqEJZVKz9MkwRjrw15JadaO5xyYOShKNzKbID3-fznxSGRPg72CQbWu5oEyQCuGOods-uE-gSrJEarWTKoKAlGpvIV29024r5QC3\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u95a2\u6570\u306e\u633f\u5165\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><img src=\"https:\/\/lh5.googleusercontent.com\/E1HL9iIH0byohkdr4mPG_VVn-Ilyzf0Lot_E33PwSVzmVPKiFq4pkpxjejd-ZoAy09l23rrcEIK1uLFsIHymI2YcNPFD1ri8DrnhI3SyRdZY2ysVkGPXL4So7qHbuB6n3A4aZp5u\" width=\"602\" height=\"221\">\u3059\u308b\u3068\u95a2\u6570\u306e\u633f\u5165\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u304f\u306e\u3067\u3010MAT\u3011\u3068\u5165\u529b\u3057\u3010MATCH\u3011\u3092\u691c\u7d22\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/QPoLfRH3GtE80Ga4lEOI9qtSlqbTUyfQWCKBJ8N3NGA7rUpVPVh53rT6xzjBdmpDBGHqbzt7jjZxwwmyEo2iG-GgxL982ySWntclpkt2jDmCPwkLCcLBEtZrHQJC7JBLLSAfngL8\" alt=\"\"\/><\/figure>\n\n\n\n<p>MATCH\u95a2\u6570\u3092\u898b\u3064\u3051\u305f\u3089\u3010OK\u3011\u3092\u62bc\u3057\u3001\u95a2\u6570\u306e\u5f15\u6570\u3092\u305d\u308c\u305e\u308c\u5165\u529b\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6700\u521d\u306f\u30ab\u30b9\u30df\u30bd\u30a6\u304c\u4f55\u884c\u76ee\u306b\u3042\u308b\u306e\u304b\u3092\u6c42\u3081\u308b\u306e\u3067\u3001G2\u306e\u691c\u7d22\u5024\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/DcY_SS_vgOQswBHUPB0QS75DVxYoCEVk4hCJGFOHmWX5Y2xVKikP1ktZ3OVR1smfcy8eclkfpUpuv_I0d06oYPXkF-bgCJEyn2XQnwjDiU0So587sXNYA_0bbxQGFazRO3Fqdp3B\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u691c\u7d22\u7bc4\u56f2\u3092\u30de\u30a6\u30b9\u3067\u9078\u629e\u3057\u307e\u3059\u3002\u30ab\u30b9\u30df\u30bd\u30a6\u306fC4\u304b\u3089C7\u306e\u30bb\u30eb\u5185\u306b\u3042\u308b\u306e\u3067\u30de\u30a6\u30b9\u3067C4\u304b\u3089C7\u306e\u7bc4\u56f2\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/KHt7IWSifNfj1jVawpt8fbCaDwopshzKEA51JM79n6_KK1B2VVlx7vgaG6tV7GCIkMvxZ-2kmy8DrqVUXgGXRtjSpmtXv3lhXvY8BjUziE5sNTFMRD1wWDhl3ZTa39biFyW-uLpK\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u6700\u5f8c\u306b\u7167\u5408\u306e\u7a2e\u985e\u3092\u8a18\u5165\u3057\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u30100\u3011\u3092\u8a18\u5165\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/QdziaYiOaaKvwzC8DnXhSfCPj_CRLZDKNTw567FLVed57gdW50kecrxq-fwkk6tNJk1y9ADMFVpDhhzzWRK0n4SK4KNWMBgs7ttghS_jmQZqPXxxZrv_h3k2tqLFtgLTELXbH8Ng\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u5f15\u6570\u304c\u5b8c\u6210\u3057\u305f\u3089\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/qYxLF6aOGQWtji4qV5n_E10TCQWWfZvlNaM6jb1-F7Fk9ZPZRY-yO-rVtkEHUrF7Tbk3HEfuW2hvHLGVSLmIf0cbCYGqTRcA3RjhxsDieaOOOrMn3BoF5w2VTnmsvx8AnVJVdeFa\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30ab\u30b9\u30df\u30bd\u30a6\u306f1\u884c\u76ee\u306b\u3042\u308b\u3053\u3068\u304c\u6c42\u3081\u3089\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3067\u306f\u540c\u3058\u3088\u3046\u306b\u4fa1\u683c\u306f\u4f55\u5217\u76ee\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u306e\u304b\u3092\u6c42\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/axn5quXyYlPO0UERt-VFgrlF-OZJ9xHEiQDVJIs2CKYMfCn4faxvrr9p2cjkOD7kyipXV5a9TMjHENJHY00tgt1mwmrVu3F1-vaxTgkSn5_0Sm5LN7Wn1DROmyBKICRNQW3oxVWo\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u540c\u3058\u3088\u3046\u306b\u95a2\u6570\u306e\u633f\u5165\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u95a2\u6570\u306e\u691c\u7d22\u3092\u884c\u3044\u307e\u3059\u3002\u5148\u307b\u3069MATCH\u95a2\u6570\u3092\u4f7f\u3063\u305f\u3070\u304b\u308a\u306a\u306e\u3067\u4e0b\u90e8\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u304b\u3089\u3001\u305d\u306e\u307e\u307e\u3010MATCH\u3011\u306e\u90e8\u5206\u3092\u9078\u629e\u3057\u305f\u72b6\u614b\u3067\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/5ArKL1itw7nSrU8t-DS_oGXV6P3EyH67CLVffYvgmvQEu5G8-wOd_GWJrtdPdsWOovHBuLaCdvjk_9xLgd7od96GKiowAm3ijB3AGb3tG6kuA1uHHqYaVuqEfdDdAJVSHKUEVdEm\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u691c\u7d22\u5024\u3067\u3042\u308b\u30bb\u30eb\u5024\u3092\u8a18\u5165\u3057\u307e\u3059\u3002\u4fa1\u683c\u3092\u691c\u7d22\u3057\u305f\u3044\u306e\u3067\u3010G3\u3011\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306f\u8a18\u5165\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/wXbWZAo4SBJ0jQ47GlUWuQtqdIz5YveVM9F7K8jzayaiPbBBXPoZo5dQ1eH6uCDAxSV19a47tJCvmOZI04ZetO7Oxn8A5XCmGC9AlYhSEuJStO91U8-OPQti73QdIAKmd6cESjxi\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u691c\u7d22\u3057\u305f\u3044\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u5546\u54c1\u30b3\u30fc\u30c9\u304b\u3089\u5728\u5eab\u6570\u307e\u3067\u3092\u30de\u30a6\u30b9\u3067\u9078\u629e\u7bc4\u56f2\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/Pk5k-2etRybwbBCVxGKb9V61Kk1cnPU63c_MmSewdsasVofMToORRCQbiBUP-BUCrsnaMzvjfXa1X2EuUXf_2RpeS2I14L5IQ1UHsmF6UUe_oUSxsVGR1_-bJCsQH_IIcDJ3_Q29\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u6700\u5f8c\u306b\u7167\u5408\u306e\u7a2e\u985e\u3092\u30100\u3011\u3068\u8a18\u5165\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/NgBQ15PN7WeC65hZKOp9oeQUQ3haFGyf6ZuaAn-ImcpWikpxCVSyFDfQDemWQwA0dAYMv1RHpjbMTVNw0NtP5GXwHvS_mLeQa4SIrkKFzntzA9xqypRBTgFe0pDTIrMDvhYSWQne\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u5f15\u6570\u304c\u5b8c\u6210\u3057\u305f\u3089\u3010OK\u3011\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/iYpaj-KRU-5V0B7kEpS9N1RYwoaMSe5BIABXnhTpeUm2iAV6oQ43DL27YpslRhJCV1-zV2pub5MuUeAlhfi8vuDI9qehfwUQBSzTCYM0SuoXXpHqO3BRK-naf3GMpfpk8sOIek77\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4fa1\u683c\u304c\u4f55\u5217\u76ee\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u304b\u3082\u3001\u95a2\u6570\u306e\u633f\u5165\u3092\u7528\u3044\u3066\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h2>INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u5408\u308f\u305b\u3066\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u30fb\u62bd\u51fa\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n<p>\u3042\u3089\u304b\u3058\u3081\u4f5c\u6210\u3055\u308c\u305f\u30a8\u30af\u30bb\u30eb\u306b\u304a\u3044\u3066\u3001\u4fa1\u683c\u8868\u5185\u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092\u9055\u3046\u30ea\u30b9\u30c8\u306b\u8868\u793a\u3055\u305b\u305f\u3044\u3068\u304d\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u969b\u3001\u3044\u3061\u3044\u3061\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3057\u305f\u308a\u5546\u54c1\u306e\u8a73\u7d30\u3092\u691c\u7d22\u3057\u3066\u5165\u529b\u3057\u305f\u308a\u3059\u308b\u3053\u3068\u306a\u304f\u3001INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u8907\u5408\u3057\u3066\u30c7\u30fc\u30bf\u3092\u8fd4\u3059\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u65b9\u6cd5\u3092\u7528\u3044\u308b\u3053\u3068\u3067\u5165\u529b\u30df\u30b9\u306a\u3069\u3092\u9632\u3050\u3053\u3068\u304c\u3067\u304d\u3001\u307e\u305f\u95a2\u6570\u3092\u899a\u3048\u3066\u304a\u304f\u3053\u3068\u3067\u3069\u3093\u306a\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u306b\u3082\u5bfe\u5fdc\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u305f\u3081\u3001\u5165\u529b\u3084\u5546\u54c1\u8a73\u7d30\u3092\u30ea\u30b5\u30fc\u30c1\u3059\u308b\u6642\u9593\u3092\u5927\u5e45\u306b\u30ab\u30c3\u30c8\u3067\u304d\u3001\u52b9\u7387\u3088\u304f\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3067\u306f\u5b9f\u969b\u306b\u3069\u306e\u3088\u3046\u306a\u6d41\u308c\u306b\u306a\u308b\u304b\u3092\u753b\u50cf\u3092\u7528\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/yU2cnvpvw4QJzk09obe8TLa4IoJALv_LvGcnpDM0EH9DYp0SPBmWkQHF6ySJHSr5FO238eyNAgpeUyvWGl2bmm-mwnI4eU-8frdG2T_8GgiBWrIM2JMkyUVBROPmnwiamN-TreM7\" alt=\"\"\/><\/figure>\n\n\n\n<p>1\u3064\u306e\u30a8\u30af\u30bb\u30eb\u306b\u3001\u5546\u54c1\u306e\u4fa1\u683c\u8868\u3068\u53d7\u6ce8\u65e5\u3092\u8a18\u5165\u3059\u308b\u30ea\u30b9\u30c8\u304c\u3044\u304f\u3064\u304b\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u8907\u5408\u3057\u305f\u95a2\u6570\u3092\u4f7f\u3044\u3001C11\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u306e\u30bb\u30eb\u5185\u306b\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u5165\u529b\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/bxMEql-Dsn4vT5HGI_gs1Y9hnnPpvYq2q3RID5sGzZRDE-ZHdo4Ee9nAfHrB4Zc1w8tbbGqooX0eVKTWIPTwVyoKFwbxbTYAw2J21BoLqhgExQuh4NC06kO9CLMqCMS8nZC_vv0b\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u8868\u793a\u3055\u305b\u305f\u3044C11\u306e\u30bb\u30eb\u5185\u306b\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u66f8\u5f0f\u3092\u8a18\u5165\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=INDEX(B4:C7,MATCH(&#8220;\u30ab\u30b9\u30df\u30bd\u30a6&#8221;,C4:C7,0),1)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3>\u66f8\u5f0f\u306e\u89e3\u8aac<\/h3>\n\n\n\n<p>\u307e\u305a\u3010=INDEX(\u3011\u3068\u8a18\u5165\u3057\u3001\u7bc4\u56f2\u3092\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002\u9752\u3044\u7dda\u3067\u56f2\u308f\u308c\u3066\u3044\u308bB4\u304b\u3089C7\u306e\u30bb\u30eb\u3092\u30de\u30a6\u30b9\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u3001\u5165\u529b\u3057\u307e\u3059\u3002(\u3053\u3053\u3067\u306f\u3010B4:C7\u3011\u3068\u5165\u529b\u3055\u308c\u3066\u3044\u307e\u3059\u3002)<\/p>\n\n\n\n<p>\u3064\u3065\u3044\u3066INDEX\u95a2\u6570\u306e\u884c\u756a\u53f7\u3092MATCH\u95a2\u6570\u306b\u305d\u308c\u305e\u308c\u66f8\u304d\u63db\u3048\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u3010MATCH\u3011\u3068\u5165\u529b\u3057\u305f\u3042\u3068\u306f\u691c\u7d22\u5024\u3067\u3042\u308b\u3010\u30ab\u30b9\u30df\u30bd\u30a6\u3011\u3092\u3010&#8221;&#8221;\u3011\u3067\u56f2\u3063\u3066\u5165\u529b\u3057\u3001\u3010,\u3011\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u691c\u7d22\u5024\u306e\u7bc4\u56f2\u3092\u30de\u30a6\u30b9\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u3066\u6307\u5b9a\u3055\u305b\u307e\u3059\u3002\u3053\u306e\u5834\u5408\u306f\u7d2b\u306e\u67a0\u3067\u56f2\u308f\u308c\u305f\u90e8\u5206\u3092\u6307\u3057\u307e\u3059\u3002(\u5165\u529b\u3059\u308b\u5834\u5408\u306f\u3010C4:C7\u3011\u3068\u5165\u529b)<\/p>\n\n\n\n<p>\u79f0\u53f7\u306e\u7a2e\u985e\u3092\u9078\u629e\u3057\u305f\u306e\u3061\u3010),\u3011\u3092\u5165\u529b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u3055\u3089\u306b\u3001\u691c\u7d22\u5024\u3068\u5b8c\u5168\u4e00\u81f4\u3057\u305f\u6570\u5024\u3092\u8fd4\u3057\u305f\u3044\u306e\u3067\u30100\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>INDEX\u95a2\u6570\u306e\u5217\u756a\u53f7\u3092\u8a18\u5165\u3057\u305f\u3042\u3068\u306f\u3010)\u3011\u3092\u62bc\u3057\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u5546\u54c1\u30b3\u30fc\u30c9\u304c\u30bb\u30eb\u306e\u4e00\u5217\u76ee\u306b\u3042\u308b\u305f\u3081\u30101\u3011\u3068\u5165\u529b\u3057\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/dY8P4KMNm4-vKyF5R62j-MqeIgtl7cq2BR2sKMuEZ1I_dpLIF_SSVMvwEDF3dpGtxKFemACXe_QjbMu_4neO1qqmDKkYL2_mG2kxfxAfj-oGxxEBGJ2Et_NdsVWeBfJuUKw5qQ0o\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3010\u30ab\u30b9\u30df\u30bd\u30a6\u3011\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u304c\u5165\u529b\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3010\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3011\u3092\u4f7f\u3063\u3066\u306e\u81ea\u52d5\u5165\u529b\u306f\u691c\u7d22\u5024\u304c\u3010\u30ab\u30b9\u30df\u30bd\u30a6\u3011\u3068\u306a\u3063\u3066\u3044\u305f\u308a\u3001\u30bb\u30eb\u306e\u5024\u304c\u30ba\u30ec\u3066\u3057\u307e\u3046\u305f\u3081\u306b\u3001\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u3001INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u95a2\u6570\u3092\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u7528\u3057\u3066\u30b3\u30d4\u30fc\u3059\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/W31JmfFZLO6ffr7En5InAQ1qAC4AePuHM1JICjMzREEj4etCBrspBFETHZxejqB2u8LQLDwa41houVKFviCU_-o21xyPcyiNTLYkCLiLgjTDtc8UFHAeK3rwQPgqcBn24-TQ04-7\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u308c\u306f\u691c\u7d22\u5bfe\u8c61\u306e\u30bb\u30eb\u304c\u30ba\u30ec\u3066\u3057\u307e\u3044\u3001\u95a2\u6570\u304c\u4e71\u308c\u3066\u3057\u307e\u3063\u305f\u3053\u3068\u306b\u3088\u3063\u3066\u8d77\u304d\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u30a8\u30e9\u30fc\u3092\u9632\u304e\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u7528\u3057\u3066\u95a2\u6570\u3092\u5165\u529b\u3057\u305f\u3044\u5834\u5408\u306f\u30012\u6bb5\u968e\u306e\u5de5\u7a0b\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3>\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u305f\u3089\u3010F4\u3011\u3092\u62bc\u3057\u3010\u7d76\u5bfe\u53c2\u7167\u3011\u306b\u6307\u5b9a\u3059\u308b<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/Bk9ZLUpozcy_YOgo9oSpuj2ehGKZK9Gnh6mkSV71vXDgfxr1XZSPEoxaxJiqXYGBNAS8fxCzkaGGzTtIb7NOtBaIkwf05v-pS7yZ5E3Z4mJ3OnyRPGoJP-jVr6famySIrNn73hTq\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3010=INDEX(\u3011\u306e\u3042\u3068\u3084\u3010(&#8220;\u25cb\u25cb&#8221;,\u3011\u306e\u3042\u3068\u306b\u3001\u30c9\u30e9\u30c3\u30b0\u3057\u3066\u53c2\u7167\u3057\u305f\u3044\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u304c\u3001\u3053\u306e\u3068\u304d\u306b\u3010F4\u3011\u3092\u62bc\u3057\u3066\u3042\u3052\u308b\u3053\u3068\u3067\u3001\u53c2\u7167\u7bc4\u56f2\u3092\u3010\u7d76\u5bfe\u53c2\u7167\u3011\u306b\u8a2d\u5b9a\u3057\u5909\u66f4\u4e0d\u53ef\u80fd\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>(\u3010F4\u3011\u30ad\u30fc\u3092\u62bc\u3059\u3068\u30bb\u30eb\u7bc4\u56f2\u306e\u6570\u5024\u304c\u3010$B$4:$C$7\u3011\u3084\u3010$C$4:$C$7\u3011\u306a\u3069\u3010$\u3011\u3067\u56f2\u307e\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059)<\/p>\n\n\n\n<p>\u305d\u3046\u3059\u308b\u3053\u3068\u3067\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u7528\u3057\u3066\u691c\u7d22\u5024\u306b\u3057\u3066\u3082\u3001\u53c2\u7167\u3057\u305f\u30bb\u30eb\u304c\u4e00\u6bb5\u305a\u3064\u4e0b\u306b\u4e0b\u304c\u3063\u3066\u53c2\u7167\u3055\u308c\u308b\u3053\u3068\u304c\u306a\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3>\u691c\u7d22\u5024\u306e\u540d\u79f0\u3092\u5909\u66f4\u3059\u308b<\/h3>\n\n\n\n<p>\u7d76\u5bfe\u53c2\u7167\u3092\u884c\u3044\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/Az8VJK39xDmJGu-3KuM9jhaAL4eca8MdzSw6xJGr1V_cY-KZAoGnSJyNvpGZcjglBxhXr0dWOLT4Yw6tQv-sTO6q9uWwaZiWwzabeG_T2muH2-YORVHD1Og0ukie-L6J-OYWWnE9\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u306e\u307f\u304c\u305d\u306e\u307e\u307e\u30b3\u30d4\u30fc\u3055\u308c\u3066\u3057\u307e\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u306f\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3057\u3066\u3044\u308b\u305f\u3081\u306b\u8d77\u304d\u3066\u3057\u307e\u3046\u30a8\u30e9\u30fc\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u5834\u5408\u306f\u95a2\u6570\u306e\u306a\u304b\u306e\u3010\u30ab\u30b9\u30df\u30bd\u30a6\u3011\u306e\u90e8\u5206\u3092\u3001\u305d\u308c\u305e\u308c\u3010\u30d0\u30e9\u3011\u3084\u3010\u30ab\u30fc\u30cd\u30fc\u30b7\u30e7\u30f3\u3011\u306a\u3069\u306e\u5546\u54c1\u540d\u306b\u5909\u3048\u308b\u3060\u3051\u3067\u305d\u308c\u305e\u308c\u3075\u3055\u308f\u3057\u3044\u5546\u54c1\u30b3\u30fc\u30c9\u304c\u5165\u529b\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/w-MgEVmW5LPVrrXnhtK9ytXRBzIwZtd0IK710wuxfWp2-hHNRaJQG9VCCp7VHkzuB6qHhi3u-VrUutGm3SAhXKQlew7Nkv4v675mVTOzfdXXIlsCkqDuKbxxzMGT7nWwQVZcML5G\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/r96OxAUeeNgB7GdS39IQMtM9kY9-UbAkAAyk0y0a9BYuASsWGcePpHVy4x7nxn4_0u7SBkzxlbKDKA4dXVnXj5VxRrYmnIEXmWYb0_QBgnKhyjFE7trzRnXQZh0nHxch4Nj6aZBr\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/3A-2txzMD-sYtvi7SblSpfYOLkYmNqjpnPHt1vLfMk_0465AfMmrGMuqDqRUeQkY2nuRLfRxJrvW8N4bfFihI0P5s7bUiZywfrzcYlJyeuirl34VfdgrayJNY3hSzFMYCmED40lf\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u540c\u3058\u3088\u3046\u306b\u30ab\u30fc\u30cd\u30fc\u30b7\u30e7\u30f3\u3082\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u5f8c\u3001\u540d\u79f0\u306e\u307f\u3092\u5909\u66f4\u3057\u3001\u7121\u4e8b\u30ab\u30fc\u30cd\u30fc\u30b7\u30e7\u30f3\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u8868\u793a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h2>\u307e\u3068\u3081<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img width=\"1920\" height=\"1280\" src=\"https:\/\/www.agentgate.jp\/carechan\/change\/wp-content\/uploads\/2021\/11\/image11-1.jpg\" alt=\"\" class=\"wp-image-15394\"\/><\/figure>\n\n\n\n<p>2\u7a2e\u985e\u306e\u95a2\u6570\u3092\u7528\u3044\u308b\u3068\u6587\u5b57\u3060\u3051\u3067\u898b\u308b\u3068\u3068\u3066\u3082\u8907\u96d1\u3067\u30a4\u30e1\u30fc\u30b8\u3057\u306b\u304f\u304b\u3063\u305f\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u3057\u304b\u3057\u3001\u3069\u3093\u306a\u30a8\u30af\u30bb\u30eb\u306e\u30c7\u30fc\u30bf\u306b\u4f7f\u3048\u308b\u306e\u304b\u3092\u753b\u50cf\u3092\u898b\u306a\u304c\u3089\u4f7f\u3044\u65b9\u3092\u5b66\u3076\u3053\u3068\u3067\u3001\u30aa\u30d5\u30a3\u30b9\u5185\u306e\u4f5c\u696d\u306e\u306a\u304b\u3067\u4f7f\u3048\u308b\u30b7\u30fc\u30f3\u304c\u3075\u3063\u3068\u6d6e\u304b\u3093\u3060\u306e\u3067\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n\n\n\n<p>INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u8907\u5408\u3057\u3066\u6570\u5024\u3092\u8fd4\u3059\u3053\u3068\u3067\u3001\u5165\u529b\u30df\u30b9\u3092\u9632\u3050\u3060\u3051\u3067\u306a\u304f\u3001\u3055\u307e\u3056\u307e\u306a\u4f5c\u696d\u3092\u52b9\u7387\u3088\u304f\u9032\u3081\u3089\u308c\u307e\u3059\u304b\u3089\u3001\u305c\u3072\u3053\u306e\u6a5f\u4f1a\u306b\u30de\u30b9\u30bf\u30fc\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"featured_media":15337,"template":"","tags":[1539,1839,1837,1911,1817,1861,2100,1794],"acf":[],"_links":{"self":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/carekotsu\/16176"}],"collection":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/carekotsu"}],"about":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/types\/carekotsu"}],"version-history":[{"count":0,"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/carekotsu\/16176\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/media\/15337"}],"wp:attachment":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/media?parent=16176"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/tags?post=16176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}