{"id":16157,"date":"2021-12-10T16:39:07","date_gmt":"2021-12-10T07:39:07","guid":{"rendered":"https:\/\/www.agentgate.jp\/carechan\/change\/?post_type=carekotsu&#038;p=16157"},"modified":"2021-12-10T16:39:09","modified_gmt":"2021-12-10T07:39:09","slug":"index%e9%96%a2%e6%95%b0%e3%81%a8%e3%81%af%ef%bc%9f%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%e3%82%92%e4%bd%bf%e3%81%84%e3%81%93%e3%81%aa%e3%81%97%e3%81%9f%e3%81%84%e3%81%aa%e3%82%89%e8%a6%9a%e3%81%88","status":"publish","type":"carekotsu","link":"https:\/\/www.agentgate.jp\/carechan\/change\/carekotsu\/16157\/","title":{"rendered":"INDEX\u95a2\u6570\u3068\u306f\uff1f\u30a8\u30af\u30bb\u30eb\u3092\u4f7f\u3044\u3053\u306a\u3057\u305f\u3044\u306a\u3089\u899a\u3048\u3066\u304a\u304f\u3079\u304d\u5fc5\u9808\u95a2\u6570"},"content":{"rendered":"\n<p>\u30a8\u30af\u30bb\u30eb\u306f\u30aa\u30d5\u30a3\u30b9\u30ef\u30fc\u30af\u306e\u307f\u306a\u3089\u305a\u3001\u81ea\u5b85\u3067\u306e\u30d1\u30bd\u30b3\u30f3\u30ef\u30fc\u30af\u306b\u3082\u5e45\u5e83\u304f\u6d3b\u8e8d\u3059\u308b\u4f5c\u696d\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u3092\u899a\u3048\u3066\u304a\u304f\u3060\u3051\u3067\u3001\u591a\u5c90\u306b\u308f\u305f\u3063\u3066\u6d3b\u7528\u3067\u304d\u308b\u305f\u3081\u3001\u30d1\u30bd\u30b3\u30f3\u3067\u4f5c\u696d\u3059\u308b\u65b9\u306b\u306f\u899a\u3048\u3066\u304a\u304d\u305f\u3044\u5fc5\u9808\u9805\u76ee\u3068\u8a00\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30a8\u30af\u30bb\u30eb\u95a2\u6570\u306e\u3072\u3068\u3064\u3067\u3042\u308b\u3010INDEX\u95a2\u6570\u3011\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u89e3\u8aac\u3002<\/p>\n\n\n\n<p>\u3055\u3089\u306b\u30a8\u30e9\u30fc\u304c\u8d77\u304d\u3066\u3057\u307e\u3046\u7406\u7531\u3068\u89e3\u6c7a\u65b9\u6cd5\u3001\u8907\u6570\u306e\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u3066\u4f7f\u3046\u5fdc\u7528\u65b9\u6cd5\u306b\u3064\u3044\u3066\u3082\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u305c\u3072\u3053\u306e\u6a5f\u4f1a\u306bINDEX\u95a2\u6570\u3092\u30de\u30b9\u30bf\u30fc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2>INDEX\u95a2\u6570\u3068\u306f\uff1f<\/h2>\n\n\n\n<p>INDEX\u95a2\u6570\u3068\u306f\u3001\u884c\u3068\u5217\u304c\u4ea4\u5dee\u3057\u305f\u30bb\u30eb\u306b\u6570\u5024\u3092\u8fd4\u3059\u95a2\u6570\u3092\u6307\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/2cduDY_kW-zOLwx7C-XA4mO0kad7oS4q5T_dhqLDuasbapZrTcU0FyAHwSu_HOLC91i-0DJ4HgbzhVoif-gRUcOjPuuCKucawSKt1OcsMnudsziK-mn8pv72xSiYIyCryFgVBUbC\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u95a2\u6570\u3067\u7bc4\u56f2\u3068\u30bb\u30eb\u3092\u305d\u308c\u305e\u308c\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u305d\u306e\u5834\u6240\u306e\u6570\u5024\u304c\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2>INDEX\u95a2\u6570\u306e\u66f8\u5f0f\u6570\u306f2\u901a\u308a<\/h2>\n\n\n\n<p>INDEX\u95a2\u6570\u306e\u66f8\u5f0f\u306f\u4ee5\u4e0b\u306e2\u901a\u308a\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u914d\u5217\u5f62\u5f0f<\/strong><\/td><td><strong>=INDEX(\u914d\u5217,\u884c\u756a\u53f7,[\u5217\u756a\u53f7])<\/strong><\/td><\/tr><tr><td><strong>\u53c2\u7167\u5f62\u5f0f<\/strong><\/td><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\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3>\u914d\u5217\u5f62\u5f0f<\/h3>\n\n\n\n<p>\u914d\u5217\u5f62\u5f0f\u306b\u306f3\u3064\u306e\u5f15\u6570\u3092\u8981\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u914d\u5217\u5f62\u5f0f1\u3064\u3081\u306e\u5f15\u6570:\u914d\u5217<\/h4>\n\n\n\n<p>1\u3064\u3081\u306e\u5f15\u6570\u306f\u914d\u5217\u3067\u3059\u3002\u5165\u529b\u306f\u5fc5\u9808\u3067\u3001\u30bb\u30eb\u3092\u7bc4\u56f2\u6307\u5b9a\u3001\u307e\u305f\u306f\u5165\u529b\u3057\u3066\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u914d\u5217\u5f62\u5f0f2\u3064\u3081\u306e\u5f15\u6570:\u884c\u756a\u53f7<\/h4>\n\n\n\n<p>2\u3064\u3081\u306e\u5f15\u6570\u306f\u884c\u756a\u53f7\u3067\u3059\u3002\u5165\u529b\u306f\u5fc5\u9808\u3067\u3059\u304c\u3001\u914d\u5217\u304c\u4e00\u884c\u306e\u5834\u5408\u306f\u7701\u7565\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u914d\u5217\u306a\u3044\u306e\u4f4d\u7f6e\u3092\u6570\u5024\u3067\u6307\u5b9a\u3057\u3001\u30100\u3011\u3092\u8a2d\u5b9a\u3057\u305f\u5834\u5408\u306f\u3001\u884c\u5168\u4f53\u306e\u6570\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u914d\u5217\u5f62\u5f0f3\u3064\u3081\u306e\u5f15\u6570:\u5217\u756a\u53f7<\/h4>\n\n\n\n<p>3\u3064\u3081\u306e\u5f15\u6570\u306f\u5217\u756a\u53f7\u3067\u3059\u3002\u3053\u306e\u5f15\u6570\u306f\u5165\u529b\u4efb\u610f\u3067\u3059\u304c\u3001\u884c\u756a\u53f7\u3092\u7701\u7565\u3057\u305f\u5834\u5408\u306f\u5165\u529b\u5fc5\u9808\u3067\u3059\u3002<\/p>\n\n\n\n<h3>\u53c2\u7167\u5f62\u5f0f<\/h3>\n\n\n\n<p>\u53c2\u7167\u5f62\u5f0f\u306b\u306f4\u3064\u306e\u5f15\u6570\u3092\u8981\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u53c2\u7167\u5f62\u5f0f1\u3064\u3081\u306e\u5f15\u6570:\u53c2\u7167<\/h4>\n\n\n\n<p>1\u3064\u3081\u306e\u5f15\u6570\u306f\u53c2\u7167\u3067\u3059\u3002\u3053\u306e\u5f15\u6570\u306e\u5165\u529b\u306f\u5fc5\u9808\u3067\u3042\u308a\u30011\u3064\u3001\u307e\u305f\u306f\u8907\u6570\u306e\u30bb\u30eb\u3092\u7bc4\u56f2\u6307\u5b9a\u3001\u307e\u305f\u306f\u5165\u529b\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u96a3\u63a5\u3057\u3066\u3044\u306a\u3044\u7bc4\u56f2\u3092\u8907\u6570\u8a2d\u5b9a\u3059\u308b\u5834\u5408\u306b\u306f\u3001\u3010()\u3011\u3067\u56f2\u3044\u3010,\u3011\u3067\u533a\u5207\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h4>\u53c2\u7167\u5f62\u5f0f2\u3064\u3081\u306e\u5f15\u6570:\u884c\u756a\u53f7<\/h4>\n\n\n\n<p>2\u3064\u3081\u306e\u5f15\u6570\u306f\u884c\u756a\u53f7\u3067\u3059\u3002\u5165\u529b\u306f\u5fc5\u9808\u3067\u3042\u308a\u3001\u7bc4\u56f2\u5185\u306e\u884c\u306e\u4f4d\u7f6e\u3092\u3001\u30bb\u30eb\u306e\u7bc4\u56f2\u6307\u5b9a\u3001\u307e\u305f\u306f\u5165\u529b\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30100\u3011\u3068\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u884c\u5168\u4f53\u3092\u8fd4\u3059\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h4>\u53c2\u7167\u5f62\u5f0f3\u3064\u3081\u306e\u5f15\u6570:\u5217\u756a\u53f7<\/h4>\n\n\n\n<p>3\u3064\u3081\u306e\u5f15\u6570\u306f\u5217\u756a\u53f7\u3067\u3059\u3002\u3053\u306e\u5f15\u6570\u306e\u5165\u529b\u306f\u4efb\u610f\u3067\u3042\u308a\u3001\u7bc4\u56f2\u5185\u306e\u5217\u306e\u4f4d\u7f6e\u3092\u8a2d\u5b9a\u3059\u308b\u969b\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30100\u3011\u3068\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u5217\u5168\u4f53\u3092\u8fd4\u3059\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h4>\u53c2\u7167\u5f62\u5f0f4\u3064\u3081\u306e\u5f15\u6570:\u9818\u57df\u756a\u53f7<\/h4>\n\n\n\n<p>4\u3064\u3081\u306e\u5f15\u6570\u306f\u9818\u57df\u756a\u53f7\u3067\u3059\u3002\u5165\u529b\u306f\u4efb\u610f\u3067\u3042\u308a\u3001\u7701\u7565\u3057\u305f\u5834\u5408\u53c2\u7167\u3067\u8a2d\u5b9a\u3057\u305f\u7bc4\u56f2\u306e\u306a\u304b\u304b\u3089\u4e00\u756a\u76ee\u306e\u7bc4\u56f2\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u53c2\u7167\u3067\u96a3\u63a5\u3057\u3066\u3044\u306a\u3044\u7bc4\u56f2\u3092\u8907\u6570\u8a2d\u5b9a\u3057\u305f\u5834\u5408\u306f\u3001\u3069\u306e\u7bc4\u56f2\u3092\u4f7f\u3046\u304b\u3092\u7bc4\u56f2\u6307\u5b9a\u3001\u307e\u305f\u306f\u5165\u529b\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2>INDEX\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<p>\u305d\u308c\u3067\u306f\u5b9f\u969b\u306bINDEX\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/gnGr2Bw2Yd-Xl8dz7euGCcfO_Laom2b1ENdO6tsJv2cxoIL2r3lXez6gvbyqDnMBgY2Vz4P75uCr5LpMVfZ0UjWxKl-fMDoJntj8EfaZVOWQdzcPZq3Cb_pmcMD7YUKu6g916NB9\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u307e\u305a\u306f\u3053\u306e\u3088\u3046\u306a\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>A\u304b\u3089E\u30012\u304b\u30895\u307e\u3067\u306e\u884c\u3068\u5217\u306b\u8907\u6570\u306e\u6570\u5024\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u30c7\u30fc\u30bf\u3092INDEX\u95a2\u6570\u3092\u7528\u3044\u308a\u3001\u6307\u5b9a\u3057\u305f\u884c\u756a\u53f7\u3068\u5217\u756a\u53f7\u306b\u306a\u3093\u306e\u6570\u5024\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u53c2\u7167\u3057\u3066\u691c\u7d22\u7d50\u679c\u306b\u8fd4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/p1E_oriOlwAZ83qWdeOPZlAE-aZgWaSELpH3FVL5vULT0vclSZe1Ckb3f5wGXUKFSjYwLrDPYGh7bXp7GWOrwWcP2UkpQaeqS9jIZYnILgv0123IO5ztoUJ0H3lc-R_6qWcg0J3b\" alt=\"\"\/><\/figure>\n\n\n\n<p>I2\u3068I3\u306e\u6570\u5024\u691c\u7d22\u306e\u6570\u5024\u306b\u306f\u305d\u308c\u305e\u308c\u4e0a\u304b\u30893\u884c\u76ee\u3001\u5de6\u304b\u30893\u5217\u76ee\u3068\u6307\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3068\u3044\u3046\u3053\u3068\u306f\u3001\u301013\u3011\u3068\u3044\u3046\u6570\u5024\u304c\u7b54\u3048\u3068\u306a\u308a\u3001\u691c\u7d22\u7d50\u679c\u306e\u30bb\u30eb\u306b\u306f\u301013\u3011\u304c\u5165\u308c\u3070\u6b63\u89e3\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u5834\u5408\u306e\u95a2\u6570\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(A2:E5,I2,I3)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>A2:E5\u306f\u30c7\u30fc\u30bf\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30de\u30a6\u30b9\u3067\u7bc4\u56f2\u6307\u5b9a\u3001\u307e\u305f\u306f\u5165\u529b\u3057\u3066\u8a2d\u5b9a\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u3010,\u3011\u3067\u533a\u5207\u3063\u305f\u3089\u3001\u305d\u308c\u305e\u308c\u5217\u756a\u53f7\u3068\u884c\u756a\u53f7\u3092\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u3010I2\u3011\u3068\u3010I3\u3011\u3092\u3010,\u3011\u3067\u91d8\u5730\u306a\u304c\u3089\u5165\u529b\u3057\u3001\u3010)\u3011\u3067\u9589\u3058\u3001\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/wk1Byy6SBYRfT-BEl9YARcEIFhZ9FEc-HSKt2fHwqgUY_14JzlFiPnJQR60rErSTDcvmmKL01MK3021_90fkPO4z876ba0eBiVeAbGRvF1cLNp4qjEy5ubJJ6ZHl4n3ts6mv9Z-0\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u301013\u3011\u3068\u3044\u3046\u6570\u5024\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>A2\u304b\u3089E5\u307e\u3067\u306e\u7bc4\u56f2\u6307\u5b9a\u3055\u308c\u305f\u30c7\u30fc\u30bf\u306e\u306a\u304b\u3067\u3001\u300c\u4e0a\u304b\u30893\u884c\u76ee\u300d\u3001\u300c\u5de6\u304b\u30893\u5217\u76ee\u300d\u306e\u30bb\u30eb\u306e\u4e2d\u306b\u306f\u301013\u3011\u3068\u3044\u3046\u6570\u5024\u304c\u3042\u308b\u3053\u3068\u304c\u95a2\u6570\u3067\u6c42\u3081\u3089\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h3>\u95a2\u6570\u306e\u633f\u5165\u3092\u7528\u3044\u3066INDEX\u95a2\u6570\u3092\u884c\u3046\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u30a8\u30af\u30bb\u30eb\u3067\u306f\u95a2\u6570\u3092\u624b\u5165\u529b\u3067\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306e\u307b\u304b\u306b\u3001\u3010\u95a2\u6570\u306e\u633f\u5165\u3011\u3068\u3044\u3046\u30c4\u30fc\u30eb\u3092\u7528\u3044\u3066\u95a2\u6570\u3092\u691c\u7d22\u3057\u3066\u5f15\u6570\u306e\u610f\u5473\u3092\u78ba\u8a8d\u3057\u306a\u304c\u3089\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u3053\u3067\u306f\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u3063\u305fINDEX\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u306e\u633f\u5165\u306f\u3001\u30a8\u30af\u30bb\u30eb\u521d\u5fc3\u8005\u3084\u30a8\u30af\u30bb\u30eb\u3092\u307e\u3060\u89e6\u3063\u305f\u3053\u3068\u304c\u306a\u3044\u65b9\u3001\u30d1\u30bd\u30b3\u30f3\u304c\u81ea\u5b85\u306b\u3042\u308b\u305f\u3081\u95a2\u6570\u3092\u899a\u3048\u3066\u307f\u3088\u3046\u3068\u8003\u3048\u308b\u65b9\u306b\u3068\u3063\u3066\u5927\u5909\u4fbf\u5229\u306a\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001\u95a2\u6570\u306e\u30b9\u30da\u30eb\u3092\u5fd8\u308c\u3066\u3057\u307e\u3044\u3001\u3046\u307e\u304f\u95a2\u6570\u3092\u4f5c\u6210\u3067\u304d\u306a\u3044\u3068\u3044\u3063\u305f\u30b7\u30fc\u30f3\u3067\u3082\u6d3b\u8e8d\u3057\u3066\u304f\u308c\u307e\u3059\u304b\u3089\u3001\u624b\u5165\u529b\u3060\u3051\u3067\u306a\u304f\u3001\u95a2\u6570\u306e\u633f\u5165\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u3082\u3042\u308f\u305b\u3066\u5b66\u3093\u3067\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/-ysUvVIDQ6roIowkHip2oCrp0xAYFDJWXOfcfO9_9RIJqrjSk8AseRjNI-toWKrdotdZlXl30qZ4b90eUweiVnW3xkHG6KZPJ8P716CAb-MX2j6SHdEMuxgIkbSk-JGRDLcc99ig\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u2705<\/p>\n\n\n\n<p>\u307e\u305a\u306f\u95a2\u6570\u306e\u633f\u5165\u306e\u5834\u6240\u306b\u3064\u3044\u3066\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u306e\u633f\u5165\u3092\u884c\u3046\u5834\u5408\u306f\u3010fx\u3011\u3068\u66f8\u304b\u308c\u305f\u8a18\u53f7\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3053\u3068\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u753b\u50cf\u306e\u8d64\u67a0\u306e\u90e8\u5206\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/BZSTom6Hm9SYie0juH3orsg6e4WapDgoQPMAkkmfui51vw_a2Ufm258RYevNxL8011WU4tvPX9r8bsUA4TnNOOXe2RP3CrT4uP7pCrLX0zy4Di8ErorfrstDLdInBTPpiCtNXU-D\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u95a2\u6570\u306e\u633f\u5165\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u304f\u306e\u3067\u3001\u3010\u4f55\u304c\u3057\u305f\u3044\u304b\u3092\u7c21\u5358\u306b\u5165\u529b\u3057\u3066\u3001[\u691c\u7d22\u958b\u59cb]\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3011\u306e\u90e8\u5206\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/g-JUFN1_t170CvgPSoSguagTo7yPQmP3RPR7qSW5Gq5voaVokjJJvj2ypnTc_jBE3qaAtOh1gHPywDDe2byH2_uRZt6CO6k5i50UYFe71wvO9uXCi05iFngpS6dgFd9kF7RIpwBq\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u691c\u7d22\u7a93\u306b\u3010IN\u3011\u3068\u5165\u529b\u3057\u3010\u691c\u7d22\u958b\u59cb\u3011\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3010IN\u3011\u3092\u542b\u3080\u95a2\u6570\u304c\u4e00\u89a7\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u306a\u304b\u304b\u3089\u3010INDEX\u3011\u3092\u9078\u629e\u3057\u305f\u3089\u3010OK\u3011\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/TWNBuBaxy90jABnbTSFJfC05Rozy-cVDUWlTtosyoGiHEi5Q0iAEZNvbbl_plSzII3JKdqr73LktTXF1sCvZpH2m57bnH6z6DRpErTQAAg3RtGS26UzOQ4lfZNAhB5y7fYBCLxzN\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5f15\u6570\u306e\u9078\u629e\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u304f\u306e\u3067\u3001<\/p>\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\u304b\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u203b\u4eca\u56de\u306f\u53c2\u7167\u3059\u308b\u30c7\u30fc\u30bf\u304c\u3072\u3068\u3064\u3067\u3042\u308b\u305f\u3081\u3001\u4e0a\u8a18\u306e\u3010\u914d\u5217,\u884c\u756a\u53f7,\u5217\u756a\u53f7\u3011\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u96a3\u63a5\u3057\u3066\u3044\u306a\u3044\u8907\u6570\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u3066\u53c2\u7167\u3059\u308b\u5834\u5408\u306b\u306f\u30012\u3064\u76ee\u306e\u3010\u53c2\u7167,\u884c\u756a\u53f7,\u5217\u756a\u53f7,\u9818\u57df\u756a\u53f7\u3011\u3092\u9078\u3073\u3001\u3010\u53c2\u7167\u3011\u306e\u90e8\u5206\u306b\u306f\u7bc4\u56f2\u6307\u5b9a\u3057\u305f\u3044\u30bb\u30eb\u6570\u5024\u3092\u3010()\u3011\u3067\u56f2\u3044\u3010,\u3011\u3067\u533a\u5207\u3063\u3066\u95a2\u6570\u3092\u4f5c\u6210\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/mUwU21Su2b4r00sQ0aDEnuAP4UGN3xukri1Y4eNGKxMAJseTAv2n7p6NO81b75hF1uhXXnDjRgefUzeDRj-vzs_qrsiivgIJ7kA8wnKrHUf-AKG5hFnzJjJ6kSGXUmNDuRiWDELK\" 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\u3010\u914d\u5217\u3011\u3092\u6307\u5b9a\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u914d\u5217\u3067\u306f\u624b\u5165\u529b\u3067\u3010A2:E5\u3011\u3068\u5165\u529b\u3057\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3057\u3001\u30de\u30a6\u30b9\u3067A2\u304b\u3089E5\u3092\u7bc4\u56f2\u9078\u629e\u3057\u3066\u5165\u529b\u3057\u3066\u3082\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/udhWXaj9DPTzsi_MCmKYaCmkZpTIFPCkDRLGuf4klMUN2GZmi_iQPMr4-P0y2m_NImDC6LAyHbm-_HpOxOdGVzfNTZRc1Yt-Hk42Fx_LtGj2LGZ6XKgF2_GErk81e8BJtVT4Plmo\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3064\u304e\u306b\u3001\u884c\u756a\u53f7\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3010\u4e0a\u304b\u3089\u3011\u3068\u66f8\u304b\u308c\u305f\u6a2a\u306e\u30bb\u30eb(I2)\u306b\u30103\u3011\u884c\u76ee\u3068\u6307\u5b9a\u3057\u3066\u3042\u308b\u306e\u3067\u3001I2\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306f\u624b\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/0vPiHgWe9daiM8_pXpGJXKJDAr24XGqCQQfYa53QRq1PSAteBp8SjDtzy9mzBXRIKcUsJ5J-_FpbFPZLwzLzPMKrtbTu6fB3eIurABNYlqpugZtUGdlUC9YTSsfNuPS2f2o61AY9\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u6700\u5f8c\u306b\u5217\u756a\u53f7\u3092\u6307\u5b9a\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u5217\u756a\u53f7\u3082I3\u30bb\u30eb\u306b\u30103\u3011\u5217\u76ee\u3068\u6307\u5b9a\u3057\u3066\u3042\u308b\u306e\u3067\u3001\u3010I3\u3011\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306f\u624b\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/_AK-FgrIplSvqvUdnHQ9v225IUxss0K0GEjivdyz_kj0VCsiy3UTnZdGtjKEuosEsnyEi-8IwAcvukub3w7jjI8wbIOcrw-g_FSLvyfxJPly4LQ9o-etqEZeAUzP0B__4AR7sLtF\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u7bc4\u56f2\u3084\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u6570\u5024\u306b\u9593\u9055\u3044\u304c\u306a\u3044\u304b\u3092\u78ba\u8a8d\u3057\u305f\u3089\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/vok8fo0obyujaDErdDi_heAKPmdjEQxLj2VolKSe3IjLzaJvOmEAXRCWRHKfMeA8t72z1QBS6Y7S_14VuuM1WEmbOHslPDU-o-SvTK0n2Sayp8WgV_bnHBPo5j-7zXxTRmecyB4t\" alt=\"\"\/><\/figure>\n\n\n\n<p>A2\u304b\u3089E5\u306e\u30c7\u30fc\u30bf\u5185\u3067\u3001\u4e0a\u304b\u30893\u884c\u76ee\u3001\u5de6\u304b\u30893\u5217\u76ee\u306e\u6570\u5024\u306f\u301013\u3011\u3067\u3042\u308b\u3053\u3068\u304c\u95a2\u6570\u306e\u633f\u5165\u3067\u3082\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h2>INDEX\u95a2\u6570\u306e\u5fdc\u7528\u65b9\u6cd5\uff5eMATCH\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\uff5e<\/h2>\n\n\n\n<p>INDEX\u95a2\u6570\u3092\u4f7f\u3063\u305f\u5fdc\u7528\u65b9\u6cd5\u306f\u3069\u306e\u3088\u3046\u306a\u3082\u306e\u304c\u3042\u308b\u306e\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n\n\n\n<p>\u3053\u3053\u3067\u306f\u30a8\u30af\u30bb\u30eb\u3092\u6d3b\u7528\u3057\u3066\u3044\u304f\u3046\u3048\u3067\u899a\u3048\u3066\u304a\u304f\u3068\u826f\u3044\u3001<\/p>\n\n\n\n<ol><li>INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u5408\u308f\u305b\u305f\u6d3b\u7528\u6cd5<\/li><li>INDEX\u95a2\u6570\u3068SUMPRODUCT\u95a2\u6570\u3092\u5408\u308f\u305b\u305f\u6d3b\u7528\u6cd5<\/li><\/ol>\n\n\n\n<p>\u306e2\u7a2e\u985e\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3069\u3061\u3089\u3082\u753b\u50cf\u4ed8\u304d\u3067\u30a4\u30e1\u30fc\u30b8\u3057\u3084\u3059\u3044\u3088\u3046\u306b\u8aac\u660e\u3057\u3066\u3044\u307e\u3059\u304b\u3089\u3001\u305c\u3072\u4e00\u7dd2\u306b\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u306fINDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u5408\u308f\u305b\u305f\u6d3b\u7528\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u304c\u3001\u305d\u306e\u307e\u3048\u306b\u3001MATCH\u95a2\u6570\u3068\u306f\u306a\u306b\u304b\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3>MATCH\u95a2\u6570\u3068\u306f\uff1f\u66f8\u5f0f\u3068\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>MATCH\u95a2\u6570\u3068\u306f\u3001\u7bc4\u56f2\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u9805\u76ee\u3092\u691c\u7d22\u3057\u3066\u3001\u305d\u306e\u7bc4\u56f2\u5185\u306e\u9805\u76ee\u3068\u5bfe\u7167\u7684\u306a\u4f4d\u7f6e\u3092\u8fd4\u3059\u3053\u3068\u3092\u6307\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/Dkat4wTjhGAsrYPXWlNGmh3ige5E6GYEwMRSmiwKH5KJEMgwHvoXQKEq5gyaLo5EgHjOajZJoiyEfmhVOgcwuQ94orSzBAeNKkhIozQM4LQKiaPKWMvL6BlstimCUE0C1Xkfs515\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u753b\u50cf\u306e\u30ea\u30b9\u30c8\u5185\u306b\u3042\u308b\u3010\u30d0\u30e9\u3011\u3092MATCH\u95a2\u6570\u3092\u7528\u3044\u3066\u3069\u3053\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u6c42\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/Pmz084ov42Ko1CzEnzcRCgxcLS12FwYjUd1whm5LCqeV1aViPBPnSHEFVxN07BZPNa5bQsERFea9u2_LLDUhQoCzwmbxgAURNU24s2wzxDXAaGTIxnOOMfRt4VKZmJZYrsJ4yTd6\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u305d\u306e\u969b\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(F2,B3:B6,0)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u66f8\u5f0f\u306e\u610f\u5473\u3068\u3057\u3066\u306f\u3001<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>F2<\/strong><\/td><td><strong>\u691c\u7d22\u3057\u305f\u3044\u5546\u54c1\u540d<\/strong><\/td><\/tr><tr><td><strong>B3:B6<\/strong><\/td><td><strong>\u691c\u7d22\u3057\u305f\u3044\u5546\u54c1\u540d\u304c\u542b\u307e\u308c\u305f\u30bb\u30eb\u306e\u7bc4\u56f2\u6307\u5b9a<\/strong><\/td><\/tr><tr><td><strong>0<\/strong><\/td><td><strong>\u5b8c\u5168\u4e00\u81f4\u3067\u63a2\u3057\u305f\u3044\u306e\u3067\u30100\u3011\u3092\u5165\u529b<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u306e\u610f\u5473\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/aszZw_52Huqr3kYYMYJQS-g6Smzj6mrBxSSp1ud61iSZ6t3VPQwQ9numtiihrvWzaxIypt5X_wfUnElRlJ_dyXE6yQpS7QkWdx9T7c8kSEePSXSCxK3lqp22UKgsYE640keSC-GG\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u66f8\u5f0f\u3092\u5165\u529b\u3057\u7d42\u3048\u305f\u3089\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002\u3059\u308b\u3068\u30102\u3011\u3068\u3044\u3046\u6570\u5b57\u306f\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u7bc4\u56f2\u9078\u629e\u3057\u305f\u969b\u3001\u30d0\u30e9\u3068\u3044\u3046\u9805\u76ee\u306f\u305d\u306e\u306a\u304b\u306e2\u884c\u76ee\u306b\u3042\u308b\u3053\u3068\u304c\u6c42\u3081\u3089\u308c\u305f\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n\n\n\n<h3>INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u8907\u5408\u3057\u3066\u5fdc\u7528\u3059\u308b<\/h3>\n\n\n\n<p>\u3053\u306eMATCH\u95a2\u6570\u3092\u3068\u3042\u308f\u305b\u3066\u3001\u5fdc\u7528\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/18-U7o6jV2X0T1SHw7fxIjW8nryk69mCnyi3Ln2B4m73pWaL0GtjsJe6VAkHnZFWPZ31RPfEExUUCV9ohH3oq68B6IjzhPg3ma258uLbNDYoCXxtA_2iA3i0ojCjbteJ52oDPUDP\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u5546\u54c1\u540d\u3001\u4fa1\u683c\u3001\u5728\u5eab\u6570\u304c\u66f8\u304b\u308c\u305f\u30ea\u30b9\u30c8\u3068\u3001\u53d7\u6ce8\u3057\u305f\u65e5\u304c\u308f\u304b\u308b\u30ea\u30b9\u30c8\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/SqChTlxqSLQjq0zR0rrqv7FMqVkE3Zxzmxi79RjdSfwuyqDtxcXDfZN0EojS_Dh2grei809kDwJcc89eYM4jnboy6BbzpR4xAYhpSwjGdROuwf1tVoofcampdivJsNcq9kx8lUMC\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u53d7\u6ce8\u65e5\u304c\u66f8\u304b\u308c\u305f\u30b7\u30fc\u30c8\u5185\u306b\u3001\u307e\u3060\u5546\u54c1\u30b3\u30fc\u30c9\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u306a\u3044\u306e\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u90e8\u5206\u3092\u3001INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u4f7f\u3063\u3066\u4e0a\u90e8\u306e\u30ea\u30b9\u30c8\u304b\u3089\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u53c2\u7167\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u969b\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(B4:C7,MATCH(&#8220;\u30ab\u30b9\u30df\u30bd\u30a6&#8221;,C4:C7,0),1)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/a0MEXhqYe_9oIhSFN22BYVDKCyqqEBf2SZP82ok79BQqs4C31j9QlJ8QEDOtR7s6v6oJqpzQI98KKJwDOKQnJAGleTYPADDyFH1hX5nm6azUdRicrmRccLx13y2l2UqXdXniulk8\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u8fd4\u3057\u305f\u3044C11\u306e\u30bb\u30eb\u306b\u3001\u4e0a\u8a18\u306e\u66f8\u5f0f\u3067\u95a2\u6570\u3092\u8a18\u5165\u3057\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/gWFAWdVmFYUh2Jj0mr1-zt36mrt8j-igD6r25LHY7EOGt-OZJIMVGDXdLt7dPMOJMhxKygn55V-ZZwgspy5POCcEEZ0FPi2kSGt6l3PsYniN487e-7r0MGBHVx9xn3WgOuL8Abxr\" alt=\"\"\/><\/figure>\n\n\n\n<p>2\u3064\u306e\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u7d50\u679c\u3001\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u8fd4\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3055\u3089\u306b\u4e0b\u306e2\u3064\u306b\u3082\u540c\u3058\u3088\u3046\u306b\u8fd4\u3057\u305f\u3044\u3067\u3059\u3088\u306d\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/rdmqIz0tlnGSws07vClDlCjNj0qxNwCb2s8WvVDjhPzqYOXJA4yFZe-iOjjmONGvpRx4Qvx5tcwsq5-nUUMVAYYfodALqy6eRwQXeP588C8lmkTqzBd_-d_4K8ZS2VyanAsz6lOs\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3057\u304b\u3057\u3001\u3010\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3011\u3092\u4f7f\u3046\u3068\u3001\u691c\u7d22\u5024\u306e\u540d\u79f0\u304c\u3010\u30ab\u30b9\u30df\u30bd\u30a6\u3011\u3068\u306a\u3063\u3066\u3044\u308b\u305f\u3081\u3001\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3053\u3068\u306a\u304f\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3063\u3066\u8fd4\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<h4>\u7bc4\u56f2\u6307\u5b9a\u3057\u3010F4(\u7d76\u5bfe\u53c2\u7167)\u3011\u3092\u62bc\u3059<\/h4>\n\n\n\n<p>\u3010=INDEX(\u3011\u3084\u3010(&#8220;\u25cb\u25cb&#8221;,\u3011\u306b\u7bc4\u56f2\u6307\u5b9a\u3057\u307e\u3059\u304c\u3001\u3053\u306e\u3068\u304d\u306b\u3010F4\u3011\u3092\u62bc\u3059\u3053\u3068\u3067\u3010\u7d76\u5bfe\u53c2\u7167\u3011\u3057\u3001\u5909\u66f4\u3092\u4e0d\u53ef\u80fd\u306b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\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>\u3053\u306e\u4f5c\u696d\u3092\u884c\u3046\u3053\u3068\u3067\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u7528\u3057\u3066\u3082\u53c2\u7167\u3057\u305f\u30bb\u30eb\u304c\u4e00\u6bb5\u305a\u3064\u4e0b\u304c\u3089\u306a\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3>\u691c\u7d22\u5024\u3092\u5909\u66f4<\/h3>\n\n\n\n<p>\u7d76\u5bfe\u53c2\u7167\u3092\u4f7f\u3044\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u3059\u308b\u3068\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/fN4laML5oki25o3lw36Sw-c3JI3uIxjWEyQVmNKKB7iw9Q_ES9VoPwBLgVmrCIvRLWSD0RAzBK62ldK4sJS34eQhHmngADDwvZh4GLpt_-_QwRnABlxu0xDevAf56GS98XDQSg-a\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u304c\u305d\u306e\u307e\u307e\u30b3\u30d4\u30fc\u3055\u308c\u3066\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u306f\u300c\u30ab\u30b9\u30df\u30bd\u30a6\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u8fd4\u3059\u95a2\u6570\u300d\u3092\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3057\u3066\u3044\u308b\u305f\u3081\u306b\u8d77\u304d\u308b\u30a8\u30e9\u30fc\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u5834\u5408\u306f\u95a2\u6570\u5185\u306e\u3010\u30ab\u30b9\u30df\u30bd\u30a6\u3011\u3092\u3001\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\u89e3\u6c7a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/3Uvus-Prt8A9Cu1RzWbTTFqzY171CcOMxYPXVwShJDLRWuch2DqMv4Kn7B5BuGZsjBAG1xO5v_S5mIx106fRn33fO_B6r8XM4MAU4GzKmnNuOEgIQJA6ial-Vfr22G4a4-fOmq7k\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/zpjBoDgCv1HTbb2682E_xxeSm7IRmne0YESlgtMTGKFY2W9vNO5QfLiUpDPoXX6lXwK4bj3oCzTCbzMBqN93NxHaaFUqrL1EWCV9cNpDwrfBlmJVVB64LdUgc_O7j14SIzdyyA8J\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/N2TEZduZVD26K4Tet2l5SlCBDKFlfKYp9yg-W1hssEI4yhEIe7KS-OrTu1XYSZEx6fRitKDAJavOFarhTnZqIc3iJAFzpo9eWi83dhmwdkMCXxa1JRye3HEL35uaNVMdvNisJ5Ko\" 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<p>\u3053\u308c\u304c\u3001INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u306e\u8907\u5408\u3057\u305f\u4f7f\u3044\u65b9\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3>SUMPRODUCT\u95a2\u6570\u3068\u306f\uff1f\u66f8\u5f0f\u3068\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/office-hack.com\/excel\/sumproduct\/\n<\/div><\/figure>\n\n\n\n<p>\u6b21\u306bINDEX\u95a2\u6570\u3068\u8907\u5408\u3055\u305b\u305f\u3044\u95a2\u6570\u3067\u3042\u308bSUMPRODUCT(\u30b5\u30e0\u30d7\u30ed\u30c0\u30af\u30c8)\u95a2\u6570\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>SUMPRODUCT\u95a2\u6570\u3068\u306f\u7bc4\u56f2\u3084\u5217\u306b\u5bfe\u3059\u308b\u8981\u7d20\u306e\u7a4d\u3092\u5408\u308f\u305b\u305f\u7d50\u679c\u3092\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u66f8\u5f0f\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=SUMPRODUCT(\u914d\u52171,[\u914d\u52172],[\u914d\u52173],\u2026\u2026)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306e\u5f15\u6570\u306e\u610f\u5473\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u914d\u52171<\/strong><\/td><td><strong>\u8a08\u7b97\u5bfe\u8c61\u3068\u306a\u308b\u8981\u7d20\u3092\u542b\u3080\u6700\u521d\u306e\u914d\u5217\u3092\u6307\u5b9a\u3055\u305b\u308b\u3002\u5165\u529b\u5fc5\u9808\u3002<\/strong><\/td><\/tr><tr><td><strong>[\u914d\u52172],[\u914d\u52173],\u2026\u2026<\/strong><\/td><td><strong>\u8a08\u7b97\u5bfe\u8c61\u3068\u306a\u308b\u8981\u7d20\u3092\u542b\u3080\u914d\u5217\u3092\u6307\u5b9a\u3055\u305b\u308b\u3002\u4efb\u610f<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>SUMPRODUCT\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306f\u3053\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/fFUWAoGwmlk65HWis2abA_iVSWVw-iqpvNB52ps7qQrJ8eFBDOc1lu-6sjzrj8ROo3iGS5KNZM9vG5BCV7G_rftHe5775qWeIsCPH5KyytTmh-fhaO6QUF3c4tCCpt_8gUY90kun\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u30ea\u30b9\u30c8\u304c\u3042\u3063\u305f\u3068\u3057\u307e\u3057\u3087\u3046\u3002\u5408\u8a08\u306e\u5728\u5eab\u6570\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u5206\u304b\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u5408\u8a08\u5728\u5eab\u6570\u3092\u3001SUMPRODUCT\u95a2\u6570\u3092\u4f7f\u3063\u3066\u6c42\u3081\u3066\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/9B5ktKX5LQdrBXKEwz0VdOBacebK9x6Yhq_Isb5UWqWwoPjBVGXo9D20pSxAZPc-7JYS43T2U4p6N-ykKnYtajuLqgpJ_woKE698URpV-dlMub3S7cewec45gw9JC0TXSuT8qcOZ\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5408\u8a08\u6570\u3092\u6c42\u3081\u305f\u3044\u30bb\u30eb\u5185\u306b\u3001\u4ee5\u4e0b\u306e\u66f8\u5f0f\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=SUMPRODUCT(E3:E6)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u203b\u7bc4\u56f2\u6307\u5b9a\u3059\u308b\u969b\u306b\u306f\u3001\u30de\u30a6\u30b9\u3067\u306e\u30c9\u30e9\u30c3\u30b0\u3067\u3082\u554f\u984c\u306a\u304f\u5165\u529b\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u3092\u5165\u529b\u3057\u305f\u3089\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/oufWNLMPJYRG_-UwpeVO8ULPJnQ2K__v3VhVTqjSRmHuG179PDzM1uR0uMU3QHuvZlD1IHkNVgiNq5yyYP0-okek2n-BqGlEpM_TG5lFZbDEA1te4Wm_6-gdLeB6JedDHRH3lED8\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5408\u8a08\u306e\u5728\u5eab\u6570\u304c400\u3068\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>SUMPRODUCT\u95a2\u6570\u306e\u57fa\u672c\u306f\u3053\u306e\u3088\u3046\u306b\u3057\u3066\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3>INDEX\u95a2\u6570\u3068SUMPRODUCT\u95a2\u6570\u3092\u8907\u5408\u3057\u3066\u5fdc\u7528\u3059\u308b\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u3067\u306fINDEX\u95a2\u6570\u3068SUMPRODUCT\u95a2\u6570\u3092\u8907\u5408\u3057\u3066\u8907\u6570\u306e\u6761\u4ef6\u306b\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u3092\u8fd4\u3059\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/U_NGH2KcE3SAI1Pm2m25nHSphfVQoQFoorqH10I8Kv6rSH2RljY2cNGwRASSCmD0UJrs073WA-QsS-ytfI1_-ARo6DfF0gpFYRXNLyr5WKO5LkZfhmKSYDvObC5ZzF8a9t3pm8SI\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u30ea\u30b9\u30c8\u3092\u5143\u306b\u3001\u8907\u6570\u6307\u5b9a\u3057\u305f\u5217\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3057\u305f\u7d50\u679c\u3092\u3010\u691c\u7d22\u7d50\u679c\u3011\u306b\u8fd4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6761\u4ef61\u3092\u3010\u65ed\u5ddd\u3011\u6761\u4ef62\u3092\u3010\u58f2\u4e0a\u500b\u6570\u3011\u306b\u8a2d\u5b9a\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u4ee5\u4e0b\u306e\u66f8\u5f0f\u3092H2\u30bb\u30eb\u306b\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=INDEX(A1:D5,SUMPRODUCT((B1:B5=F2)*(C1:C5=G2)*ROW(B1:B5)),1)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/1sxklbRwFc4nVh1_J9DgFvFDFHJJxv07hdpOYuovA2qU4QYaG0L-U2d-mZlH2acpYHa8v1CfoTBINKKS_HOQ9HRQ5WgyUHKZTW-YJn3h7e6MXXHilq2uJEv1UfQKHOPZaQ6DejF4\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/qbnH3UShuSFOUL_fHvqMz-R_3VhCqef8Rs5zkBvmYDMa8CZAdBaRzLO6VqW_QJAXWeDQ35U4OpkcDEwvbk3UDSs2aTGd73p8Hpu6l3qJbJ02t5MUbayOeMSAlM5Bet9qYa16pivQ\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u6761\u4ef61\u306e\u3010\u65ed\u5ddd\u3011\u3068\u3001\u6761\u4ef62\u306e\u3010\u58f2\u4e0a\u500b\u6570\u3011\u304b\u3089\u3001\u30ab\u30b9\u30df\u30bd\u30a6\u3067\u3042\u308b\u3053\u3068\u3092\u691c\u7d22\u3057\u8fd4\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h2>INDEX\u95a2\u6570\u306b\u304a\u3051\u308b\u3010#REF\u3011\u30a8\u30e9\u30fc\u306e\u7406\u7531\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h2>\n\n\n\n<p>INDEX\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u969b\u3001\u6700\u3082\u591a\u304f\u898b\u3089\u308c\u308b\u306e\u304c\u3010#REF\u3011\u30a8\u30e9\u30fc\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/mrWuKylcjgIlmqAEqufjYkfWy3O3z2Zjx4rhCYUCnkDPMS_i3Gmxp31Qt0EBkdn0JjqAFIDyhmRcPJARfyfo5DRqU5ToDqGolKXWQ0zyEe4nsSptRTWdp7tDr61XR02bdOnynA9U\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3010#REF\u3011\u30a8\u30e9\u30fc\u3068\u306a\u308b\u7406\u7531\u306f\u3001\u884c\u3084\u5217\u306e\u756a\u53f7\u304c\u53c2\u7167\u306e\u7bc4\u56f2\u3092\u8d85\u3048\u3066\u3044\u308b\u3053\u3068\u304c\u8003\u3048\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u753b\u50cf\u3092\u898b\u3066\u307f\u308b\u3068\u3001<\/p>\n\n\n\n<p>\u6570\u5024\u691c\u7d22\u306e\u6a2a\u306e\u6761\u4ef6\u90e8\u5206\u3001\u3010\u4e0a\u304b\u3089\u3011\u306e\u6761\u4ef6\u304c7\u884c\u76ee\u3068\u8a18\u5165\u3055\u308c\u3066\u3044\u3066\u3001\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u7bc4\u56f2\u3092\u8d85\u3048\u3066\u3044\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u3067\u306f\u53c2\u7167\u3067\u304d\u308b\u3082\u306e\u304c\u306a\u3044\u305f\u3081\u3001\u3010#REF\u3011\u30a8\u30e9\u30fc\u3068\u306a\u3063\u3066\u3057\u307e\u3046\u306e\u3067\u3059\u3002<\/p>\n\n\n\n<h2>\u307e\u3068\u3081<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img width=\"2000\" height=\"1125\" src=\"https:\/\/www.agentgate.jp\/carechan\/change\/wp-content\/uploads\/2021\/12\/pixta_82439723_M.jpg\" alt=\"\" class=\"wp-image-16158\"\/><\/figure>\n\n\n\n<p>INDEX\u95a2\u6570\u306f\u3068\u3066\u3082\u4f7f\u3044\u3084\u3059\u3044\u305f\u3081\u3001\u30a8\u30af\u30bb\u30eb\u3092\u30de\u30b9\u30bf\u30fc\u3057\u305f\u3044\u65b9\u306b\u306f\u3059\u3050\u306b\u899a\u3048\u3089\u308c\u308b\u95a2\u6570\u3068\u8a00\u3048\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u8907\u6570\u306e\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u3066\u4f7f\u3046\u3053\u3068\u3067\u3001\u69d8\u3005\u306a\u4f5c\u696d\u52b9\u7387\u3092\u30a2\u30c3\u30d7\u3055\u305b\u3066\u304f\u308c\u308bINDEX\u95a2\u6570\u3002<\/p>\n\n\n\n<p>\u305c\u3072\u3053\u306e\u6a5f\u4f1a\u306b\u3001\u30a8\u30af\u30bb\u30eb\u306e\u95a2\u6570\u3092\u30de\u30b9\u30bf\u30fc\u3057\u3001\u4e0a\u7d1a\u8005\u3089\u3057\u3044\u30c7\u30fc\u30bf\u4f5c\u6210\u3092\u884c\u3063\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"featured_media":16072,"template":"","tags":[1539,1902,1839,1837,2097,1888,1817,1793,1794],"acf":[],"_links":{"self":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/carekotsu\/16157"}],"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\/16157\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/media\/16072"}],"wp:attachment":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/media?parent=16157"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/tags?post=16157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}