{"id":25556,"date":"2026-06-15T10:28:29","date_gmt":"2026-06-15T01:28:29","guid":{"rendered":"https:\/\/ardent.jp\/rentoffice-consultation-center\/?p=25556"},"modified":"2026-06-15T10:28:29","modified_gmt":"2026-06-15T01:28:29","slug":"spreadsheet-pulldown-rendou","status":"publish","type":"post","link":"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\uff082\u6bb5\u968e\uff09\u306e\u4f5c\u308a\u65b9\uff5cINDIRECT\u3067\u81ea\u52d5\u7d5e\u308a\u8fbc\u307f"},"content":{"rendered":"<p><script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [\n    {\n      \"@type\": \"Question\",\n      \"name\": \"\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\uff082\u6bb5\u968e\u30d7\u30eb\u30c0\u30a6\u30f3\uff09\u3068\u306f\u4f55\u3067\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"1\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3067\u9078\u3093\u3060\u5185\u5bb9\u306b\u5fdc\u3058\u3066\u30012\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u306e\u9078\u629e\u80a2\u304c\u81ea\u52d5\u3067\u7d5e\u308a\u8fbc\u307e\u308c\u308b\u4ed5\u7d44\u307f\u3067\u3059\u3002\u305f\u3068\u3048\u3070\u300c\u6771\u4eac\u90fd\u300d\u3092\u9078\u3076\u30682\u6bb5\u968e\u76ee\u306b\u300c\u6e0b\u8c37\u533a\u30fb\u65b0\u5bbf\u533a\u2026\u300d\u3060\u3051\u304c\u51fa\u308b\u3088\u3046\u306b\u3067\u304d\u307e\u3059\u3002Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u306f\u300e\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u300f\u3068\u300eINDIRECT\u95a2\u6570\u300f\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u4f5c\u308a\u307e\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u306f\u3069\u3046\u3084\u3063\u3066\u4f5c\u308a\u307e\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"\u2460\u9078\u629e\u80a2\u306e\u8868\uff08\u30de\u30b9\u30bf\u30fc\uff09\u3092\u7528\u610f\u3057\u3001\u24611\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308a\u3001\u24622\u6bb5\u968e\u76ee\u306e\u5404\u30ea\u30b9\u30c8\u306b1\u6bb5\u968e\u76ee\u3068\u540c\u3058\u540d\u524d\u3067\u300e\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u300f\u3092\u8a2d\u5b9a\u3057\u3001\u24632\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u306e\u7bc4\u56f2\u306b\u300e=INDIRECT(1\u6bb5\u968e\u76ee\u306e\u30bb\u30eb)\u300f\u3092\u6307\u5b9a\u3059\u308b\u3001\u3068\u3044\u30464\u30b9\u30c6\u30c3\u30d7\u3067\u4f5c\u308c\u307e\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"2\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u306b#REF!\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u306e\u306f\u306a\u305c\u3067\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"1\u6bb5\u968e\u76ee\u304c\u307e\u3060\u672a\u9078\u629e\u306e\u3068\u304d\u3001INDIRECT\u304c\u53c2\u7167\u3059\u308b\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u304c\u5b58\u5728\u305b\u305a\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u30021\u6bb5\u968e\u76ee\u3092\u9078\u3079\u3070\u89e3\u6d88\u3057\u307e\u3059\u3002\u6c17\u306b\u306a\u308b\u5834\u5408\u306f\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u306e\u540d\u524d\u30681\u6bb5\u968e\u76ee\u306e\u5024\u304c\u5b8c\u5168\u306b\u4e00\u81f4\u3057\u3066\u3044\u308b\u304b\u3001INDIRECT\u306e\u30bb\u30eb\u6307\u5b9a\u306b\u4f59\u8a08\u306a$\u304c\u4ed8\u3044\u3066\u3044\u306a\u3044\u304b\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3067\u8907\u6570\u9078\u629e\u306f\u3067\u304d\u307e\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"\u6a19\u6e96\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u306f1\u30bb\u30eb1\u3064\u306e\u9078\u629e\u304c\u57fa\u672c\u3067\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u7684\u306a\u8907\u6570\u9078\u629e\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u3002\u8907\u6570\u9078\u629e\u304c\u5fc5\u8981\u306a\u5834\u5408\u306fGAS\uff08Apps Script\uff09\u3067\u4f5c\u308a\u8fbc\u3080\u304b\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3068TEXTJOIN\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u306a\u3069\u306e\u5de5\u592b\u304c\u5fc5\u8981\u3067\u3059\u3002\u5165\u529b\u9805\u76ee\u304c\u5897\u3048\u308b\u306a\u3089\u3001\u30ce\u30fc\u30b3\u30fc\u30c9\u306e\u696d\u52d9\u30a2\u30d7\u30ea\u306b\u5207\u308a\u66ff\u3048\u305f\u307b\u3046\u304c\u624b\u9593\u306a\u304f\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002\"\n      }\n    }\n  ]\n}\n<\/script><\/p>\n<div style=\"height: 20px;\"><\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_77 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u6b21<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E3%81%AF%E3%81%98%E3%82%81%E3%81%AB%E3%80%9C%E3%80%8C%E9%80%A3%E5%8B%95%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%80%8D%E3%81%A7%E5%85%A5%E5%8A%9B%E3%83%9F%E3%82%B9%E3%81%A8%E6%89%8B%E9%96%93%E3%82%92%E6%B8%9B%E3%82%89%E3%81%99\" >\u306f\u3058\u3081\u306b\u301c\u300c\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u300d\u3067\u5165\u529b\u30df\u30b9\u3068\u624b\u9593\u3092\u6e1b\u3089\u3059<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E9%80%A3%E5%8B%95%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%EF%BC%882%E6%AE%B5%E9%9A%8E%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%EF%BC%89%E3%81%A8%E3%81%AF%EF%BC%9F%E4%BB%95%E7%B5%84%E3%81%BF%E3%82%92%E3%82%84%E3%81%95%E3%81%97%E3%81%8F%E8%A7%A3%E8%AA%AC\" >\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\uff082\u6bb5\u968e\u30d7\u30eb\u30c0\u30a6\u30f3\uff09\u3068\u306f\uff1f\u4ed5\u7d44\u307f\u3092\u3084\u3055\u3057\u304f\u89e3\u8aac<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E3%80%90%E6%89%8B%E9%A0%86%E3%80%91Google%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E3%81%A7%E9%80%A3%E5%8B%95%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%82%92%E4%BD%9C%E3%82%8B5%E3%82%B9%E3%83%86%E3%83%83%E3%83%97\" >\u3010\u624b\u9806\u3011Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308b5\u30b9\u30c6\u30c3\u30d7<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E2%91%A0_%E9%81%B8%E6%8A%9E%E8%82%A2%E3%81%AE%E8%A1%A8%EF%BC%88%E3%83%9E%E3%82%B9%E3%82%BF%E3%83%BC%EF%BC%89%E3%82%92%E7%94%A8%E6%84%8F%E3%81%99%E3%82%8B\" >\u2460 \u9078\u629e\u80a2\u306e\u8868\uff08\u30de\u30b9\u30bf\u30fc\uff09\u3092\u7528\u610f\u3059\u308b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E2%91%A1_1%E6%AE%B5%E9%9A%8E%E7%9B%AE%E3%81%AE%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%82%92%E4%BD%9C%E3%82%8B\" >\u2461 1\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E2%91%A2_2%E6%AE%B5%E9%9A%8E%E7%9B%AE%E3%81%AE%E3%83%AA%E3%82%B9%E3%83%88%E3%81%AB%E3%80%8C%E5%90%8D%E5%89%8D%E4%BB%98%E3%81%8D%E7%AF%84%E5%9B%B2%E3%80%8D%E3%82%92%E8%A8%AD%E5%AE%9A%E3%81%99%E3%82%8B\" >\u2462 2\u6bb5\u968e\u76ee\u306e\u30ea\u30b9\u30c8\u306b\u300c\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u300d\u3092\u8a2d\u5b9a\u3059\u308b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E2%91%A3_INDIRECT%E9%96%A2%E6%95%B0%E3%81%A72%E6%AE%B5%E9%9A%8E%E7%9B%AE%E3%81%AE%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%82%92%E4%BD%9C%E3%82%8B\" >\u2463 INDIRECT\u95a2\u6570\u30672\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E2%91%A4_%E3%82%AA%E3%83%BC%E3%83%88%E3%83%95%E3%82%A3%E3%83%AB%E3%81%A7%E4%B8%8B%E3%81%AE%E8%A1%8C%E3%81%BE%E3%81%A7%E3%82%B3%E3%83%94%E3%83%BC%E3%81%99%E3%82%8B\" >\u2464 \u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067\u4e0b\u306e\u884c\u307e\u3067\u30b3\u30d4\u30fc\u3059\u308b<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E3%81%A4%E3%81%BE%E3%81%9A%E3%81%8D%E3%82%84%E3%81%99%E3%81%84%E3%83%9D%E3%82%A4%E3%83%B3%E3%83%88%E3%81%A8%E5%AF%BE%E5%87%A6%E6%B3%95\" >\u3064\u307e\u305a\u304d\u3084\u3059\u3044\u30dd\u30a4\u30f3\u30c8\u3068\u5bfe\u51e6\u6cd5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E3%82%82%E3%81%A3%E3%81%A8%E4%BE%BF%E5%88%A9%E3%81%AB%EF%BC%9A%E8%89%B2%E5%88%86%E3%81%91%E3%83%BB3%E6%AE%B5%E9%9A%8E%E9%80%A3%E5%8B%95%E3%83%BB%E8%A4%87%E6%95%B0%E9%81%B8%E6%8A%9E\" >\u3082\u3063\u3068\u4fbf\u5229\u306b\uff1a\u8272\u5206\u3051\u30fb3\u6bb5\u968e\u9023\u52d5\u30fb\u8907\u6570\u9078\u629e<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E9%81%B8%E6%8A%9E%E8%82%A2%E3%81%94%E3%81%A8%E3%81%AB%E8%89%B2%E3%82%92%E4%BB%98%E3%81%91%E3%82%8B\" >\u9078\u629e\u80a2\u3054\u3068\u306b\u8272\u3092\u4ed8\u3051\u308b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#3%E6%AE%B5%E9%9A%8E%E4%BB%A5%E4%B8%8A%E3%81%AB%E5%A2%97%E3%82%84%E3%81%99\" >3\u6bb5\u968e\u4ee5\u4e0a\u306b\u5897\u3084\u3059<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E8%A4%87%E6%95%B0%E9%81%B8%E6%8A%9E%E3%82%92%E3%81%97%E3%81%9F%E3%81%84%E5%A0%B4%E5%90%88\" >\u8907\u6570\u9078\u629e\u3092\u3057\u305f\u3044\u5834\u5408<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E3%81%AE%E3%80%8C%E9%80%A3%E5%8B%95%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%80%8D%E3%81%A7%E9%99%90%E7%95%8C%E3%82%92%E6%84%9F%E3%81%98%E3%81%9F%E3%82%89\" >\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u300c\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u300d\u3067\u9650\u754c\u3092\u611f\u3058\u305f\u3089<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E3%83%87%E3%82%B8%E3%82%BF%E3%83%AB%E5%8C%96%E3%83%BBAI%E5%B0%8E%E5%85%A5%E8%A3%9C%E5%8A%A9%E9%87%91%E3%81%AF%E4%BD%BF%E3%81%88%E3%82%8B%EF%BC%9F\" >\u30c7\u30b8\u30bf\u30eb\u5316\u30fbAI\u5c0e\u5165\u88dc\u52a9\u91d1\u306f\u4f7f\u3048\u308b\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E3%82%88%E3%81%8F%E3%81%82%E3%82%8B%E8%B3%AA%E5%95%8F%EF%BC%88FAQ%EF%BC%89\" >\u3088\u304f\u3042\u308b\u8cea\u554f\uff08FAQ\uff09<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/spreadsheet-pulldown-rendou\/#%E3%81%BE%E3%81%A8%E3%82%81\" >\u307e\u3068\u3081<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%81%AF%E3%81%98%E3%82%81%E3%81%AB%E3%80%9C%E3%80%8C%E9%80%A3%E5%8B%95%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%80%8D%E3%81%A7%E5%85%A5%E5%8A%9B%E3%83%9F%E3%82%B9%E3%81%A8%E6%89%8B%E9%96%93%E3%82%92%E6%B8%9B%E3%82%89%E3%81%99\"><\/span><span class=\"ez-toc-section\" id=\"hajimeni\"><\/span>\u306f\u3058\u3081\u306b\u301c\u300c\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u300d\u3067\u5165\u529b\u30df\u30b9\u3068\u624b\u9593\u3092\u6e1b\u3089\u3059<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u540d\u7c3f\u3084\u53d7\u6ce8\u8868\u3092\u307f\u3093\u306a\u3067\u5165\u529b\u3057\u3066\u3044\u308b\u3068\u3001\u8868\u8a18\u3086\u308c\u3084\u9078\u629e\u30df\u30b9\u304c\u8d77\u304d\u304c\u3061\u3067\u3059\u3002<strong>\u300c\u5206\u985e\u3092\u9078\u3076\u3068\u3001\u305d\u308c\u306b\u5408\u3046\u9805\u76ee\u3060\u3051\u304c\u6b21\u306e\u6b04\u306b\u51fa\u3066\u304f\u308b\u300d<\/strong>\u2015\u2015\u305d\u3093\u306a<strong>\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\uff082\u6bb5\u968e\u30d7\u30eb\u30c0\u30a6\u30f3\uff09<\/strong>\u3092\u4f5c\u308c\u3070\u3001\u5165\u529b\u306e\u8ff7\u3044\u3068\u30df\u30b9\u3092\u3050\u3063\u3068\u6e1b\u3089\u305b\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308b\u624b\u9806\u3092\u3001\u753b\u9762\u3092\u89e6\u3063\u305f\u3053\u3068\u304c\u3042\u308b\u65b9\u306a\u3089\u305d\u306e\u307e\u307e\u771f\u4f3c\u3067\u304d\u308b\u3088\u3046\u306b\u3001\u3084\u3055\u3057\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002\u3064\u307e\u305a\u304d\u3084\u3059\u3044\u30a8\u30e9\u30fc\u306e\u5bfe\u51e6\u3001\u8272\u5206\u3051\u30843\u6bb5\u968e\u3078\u306e\u767a\u5c55\u3001\u305d\u3057\u3066\u300c\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u306f\u624b\u306b\u8ca0\u3048\u306a\u304f\u306a\u3063\u305f\u3068\u304d\u300d\u306e\u6b21\u306e\u4e00\u624b\u307e\u3067\u3001\u4e2d\u5c0f\u4f01\u696d\u306e\u73fe\u5834\u76ee\u7dda\u3067\u307e\u3068\u3081\u307e\u3057\u305f\u3002<\/p>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/google-spreadsheet-pulldown\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">\u9032\u5316\u3057\u305fGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u30e1\u30cb\u30e5\u30fc\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5 &#x27a1;<\/a>\n<\/div>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E9%80%A3%E5%8B%95%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%EF%BC%882%E6%AE%B5%E9%9A%8E%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%EF%BC%89%E3%81%A8%E3%81%AF%EF%BC%9F%E4%BB%95%E7%B5%84%E3%81%BF%E3%82%92%E3%82%84%E3%81%95%E3%81%97%E3%81%8F%E8%A7%A3%E8%AA%AC\"><\/span><span class=\"ez-toc-section\" id=\"toha\"><\/span>\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\uff082\u6bb5\u968e\u30d7\u30eb\u30c0\u30a6\u30f3\uff09\u3068\u306f\uff1f\u4ed5\u7d44\u307f\u3092\u3084\u3055\u3057\u304f\u89e3\u8aac<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u3068\u306f\u3001<strong>1\u6bb5\u968e\u76ee\u3067\u9078\u3093\u3060\u5185\u5bb9\u306b\u5fdc\u3058\u3066\u30012\u6bb5\u968e\u76ee\u306b\u51fa\u3066\u304f\u308b\u9078\u629e\u80a2\u304c\u81ea\u52d5\u3067\u5909\u308f\u308b<\/strong>\u30d7\u30eb\u30c0\u30a6\u30f3\u306e\u3053\u3068\u3067\u3059\u3002\u300c2\u6bb5\u968e\u30d7\u30eb\u30c0\u30a6\u30f3\u300d\u300c\u89aa\u5b50\u30d7\u30eb\u30c0\u30a6\u30f3\u300d\u3068\u3082\u547c\u3070\u308c\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u305f\u3068\u3048\u3070\u30011\u6bb5\u968e\u76ee\u3067\u300c\u6771\u4eac\u90fd\u300d\u3092\u9078\u3076\u30682\u6bb5\u968e\u76ee\u306b\u306f\u300c\u6e0b\u8c37\u533a\u30fb\u65b0\u5bbf\u533a\u30fb\u6e2f\u533a\u2026\u300d\u3060\u3051\u304c\u8868\u793a\u3055\u308c\u3001\u300c\u5927\u962a\u5e9c\u300d\u3092\u9078\u3079\u3070\u5927\u962a\u306e\u5e02\u533a\u753a\u6751\u306b\u5207\u308a\u66ff\u308f\u308b\u3001\u3068\u3044\u3046\u30a4\u30e1\u30fc\u30b8\u3067\u3059\u3002\u53d7\u6ce8\u8868\u306a\u3089\u300c\u5546\u54c1\u30ab\u30c6\u30b4\u30ea\u2192\u5546\u54c1\u540d\u300d\u3001\u6848\u4ef6\u7ba1\u7406\u306a\u3089\u300c\u90e8\u7f72\u2192\u62c5\u5f53\u8005\u300d\u3068\u3044\u3063\u305f\u4f7f\u3044\u65b9\u304c\u3067\u304d\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u4ed5\u7d44\u307f\u306e\u30ab\u30ae\u306f2\u3064\u3060\u3051\u3067\u3059\u3002\u3072\u3068\u3064\u306f\u9078\u629e\u80a2\u306e\u304b\u305f\u307e\u308a\u306b\u540d\u524d\u3092\u4ed8\u3051\u308b<strong>\u300c\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u300d<\/strong>\u3001\u3082\u3046\u3072\u3068\u3064\u306f\u305d\u306e\u540d\u524d\u3092\u6587\u5b57\u3069\u304a\u308a\u306b\u53c2\u7167\u3057\u3066\u304f\u308c\u308b<strong>\u300cINDIRECT\u95a2\u6570\u300d<\/strong>\u3067\u3059\u30021\u6bb5\u968e\u76ee\u3067\u9078\u3093\u3060\u6587\u5b57\uff08\u4f8b\uff1a\u6771\u4eac\u90fd\uff09\u3092\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u306e\u540d\u524d\u3068\u3057\u3066\u4f7f\u3044\u3001INDIRECT\u304c\u305d\u306e\u7bc4\u56f2\u3092\u547c\u3073\u51fa\u3059\u3053\u3068\u3067\u9023\u52d5\u304c\u5b9f\u73fe\u3057\u307e\u3059\u3002<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%80%90%E6%89%8B%E9%A0%86%E3%80%91Google%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E3%81%A7%E9%80%A3%E5%8B%95%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%82%92%E4%BD%9C%E3%82%8B5%E3%82%B9%E3%83%86%E3%83%83%E3%83%97\"><\/span><span class=\"ez-toc-section\" id=\"tejun\"><\/span>\u3010\u624b\u9806\u3011Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308b5\u30b9\u30c6\u30c3\u30d7<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u3053\u3053\u304b\u3089\u306f\u5b9f\u969b\u306e\u4f5c\u308a\u65b9\u3067\u3059\u3002\u4f8b\u3068\u3057\u3066\u30011\u6bb5\u968e\u76ee\u300c\u90fd\u9053\u5e9c\u770c\u300d\u30012\u6bb5\u968e\u76ee\u300c\u5e02\u533a\u753a\u6751\u300d\u306e\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308a\u307e\u3059\u3002\u5546\u54c1\u30ab\u30c6\u30b4\u30ea\u3084\u90e8\u7f72\u306a\u3069\u3001\u3054\u81ea\u8eab\u306e\u30c7\u30fc\u30bf\u306b\u7f6e\u304d\u63db\u3048\u3066\u8aad\u3093\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E2%91%A0_%E9%81%B8%E6%8A%9E%E8%82%A2%E3%81%AE%E8%A1%A8%EF%BC%88%E3%83%9E%E3%82%B9%E3%82%BF%E3%83%BC%EF%BC%89%E3%82%92%E7%94%A8%E6%84%8F%E3%81%99%E3%82%8B\"><\/span><span class=\"ez-toc-section\" id=\"step1\"><\/span>\u2460 \u9078\u629e\u80a2\u306e\u8868\uff08\u30de\u30b9\u30bf\u30fc\uff09\u3092\u7528\u610f\u3059\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u307e\u305a\u3001\u9078\u629e\u80a2\u306e\u3082\u3068\u306b\u306a\u308b\u8868\u3092\u4f5c\u308a\u307e\u3059\u3002<strong>1\u884c\u76ee\u306b1\u6bb5\u968e\u76ee\u306e\u5024\uff08\u6771\u4eac\u90fd\u30fb\u5927\u962a\u5e9c\u2026\uff09\u3092\u6a2a\u306b\u4e26\u3079\u3001\u305d\u306e\u4e0b\u306e\u5217\u306b\u305d\u308c\u305e\u308c\u306e2\u6bb5\u968e\u76ee\u306e\u5024\uff08\u5e02\u533a\u753a\u6751\uff09\u3092\u7e26\u306b\u4e26\u3079\u307e\u3059<\/strong>\u3002<br \/>\n&nbsp;<br \/>\n\u5165\u529b\u6b04\u3068\u5206\u3051\u305f\u3044\u3068\u304d\u306f\u3001\u5225\u30b7\u30fc\u30c8\uff08\u4f8b\uff1a\u300c\u30de\u30b9\u30bf\u30fc\u300d\u30b7\u30fc\u30c8\uff09\u306b\u4f5c\u308b\u3068\u8868\u304c\u6563\u3089\u304b\u3089\u305a\u304a\u3059\u3059\u3081\u3067\u3059\u3002\u7a7a\u767d\u884c\u304c\u6df7\u3056\u308b\u3068\u9078\u629e\u80a2\u306b\u7a7a\u6b04\u304c\u51fa\u308b\u305f\u3081\u3001\u30c7\u30fc\u30bf\u306f\u8a70\u3081\u3066\u4e26\u3079\u307e\u3057\u3087\u3046\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E2%91%A1_1%E6%AE%B5%E9%9A%8E%E7%9B%AE%E3%81%AE%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%82%92%E4%BD%9C%E3%82%8B\"><\/span><span class=\"ez-toc-section\" id=\"step2\"><\/span>\u2461 1\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>1\u6bb5\u968e\u76ee\u3092\u5165\u529b\u3059\u308b\u30bb\u30eb\u3092\u9078\u3073\u3001\u30e1\u30cb\u30e5\u30fc\u306e<strong>\u300c\u30c7\u30fc\u30bf\u300d\u2192\u300c\u30c7\u30fc\u30bf\u306e\u5165\u529b\u898f\u5247\u300d<\/strong>\u3092\u958b\u304d\u307e\u3059\u3002\u6761\u4ef6\u3092<strong>\u300c\u30d7\u30eb\u30c0\u30a6\u30f3\uff08\u7bc4\u56f2\u5185\uff09\u300d<\/strong>\u306b\u3057\u3066\u3001\u7bc4\u56f2\u306b\u30de\u30b9\u30bf\u30fc\u306e1\u884c\u76ee\uff08\u90fd\u9053\u5e9c\u770c\u304c\u4e26\u3093\u3060\u7bc4\u56f2\uff09\u3092\u6307\u5b9a\u3059\u308c\u3070\u30011\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u306f\u5b8c\u6210\u3067\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E2%91%A2_2%E6%AE%B5%E9%9A%8E%E7%9B%AE%E3%81%AE%E3%83%AA%E3%82%B9%E3%83%88%E3%81%AB%E3%80%8C%E5%90%8D%E5%89%8D%E4%BB%98%E3%81%8D%E7%AF%84%E5%9B%B2%E3%80%8D%E3%82%92%E8%A8%AD%E5%AE%9A%E3%81%99%E3%82%8B\"><\/span><span class=\"ez-toc-section\" id=\"step3\"><\/span>\u2462 2\u6bb5\u968e\u76ee\u306e\u30ea\u30b9\u30c8\u306b\u300c\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u300d\u3092\u8a2d\u5b9a\u3059\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u3053\u3053\u304c\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u306e\u5fc3\u81d3\u90e8\u3067\u3059\u3002\u30de\u30b9\u30bf\u30fc\u3067<strong>\u300c\u6771\u4eac\u90fd\u300d\u306e\u4e0b\u306b\u4e26\u3093\u3060\u5e02\u533a\u753a\u6751\u306e\u7bc4\u56f2\u3092\u9078\u629e<\/strong>\u3057\u3001\u30e1\u30cb\u30e5\u30fc\u306e<strong>\u300c\u30c7\u30fc\u30bf\u300d\u2192\u300c\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u300d<\/strong>\u3092\u958b\u3044\u3066\u3001\u540d\u524d\u3092<strong>\u300c\u6771\u4eac\u90fd\u300d<\/strong>\u3068\u4ed8\u3051\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u30dd\u30a4\u30f3\u30c8\u306f\u3001<strong>\u540d\u524d\u30921\u6bb5\u968e\u76ee\u306e\u5024\u3068\u307e\u3063\u305f\u304f\u540c\u3058\u6587\u5b57\u306b\u3059\u308b<\/strong>\u3053\u3068\u3067\u3059\u3002\u300c\u5927\u962a\u5e9c\u300d\u306e\u7bc4\u56f2\u306b\u306f\u300c\u5927\u962a\u5e9c\u300d\u3068\u3044\u3046\u540d\u524d\u3092\u3001\u3068\u3044\u3046\u3088\u3046\u306b\u30011\u6bb5\u968e\u76ee\u306e\u9078\u629e\u80a2\u306e\u6570\u3060\u3051\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E2%91%A3_INDIRECT%E9%96%A2%E6%95%B0%E3%81%A72%E6%AE%B5%E9%9A%8E%E7%9B%AE%E3%81%AE%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%82%92%E4%BD%9C%E3%82%8B\"><\/span><span class=\"ez-toc-section\" id=\"step4\"><\/span>\u2463 INDIRECT\u95a2\u6570\u30672\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>2\u6bb5\u968e\u76ee\u3092\u5165\u529b\u3059\u308b\u30bb\u30eb\u3092\u9078\u3073\u3001\u518d\u3073<strong>\u300c\u30c7\u30fc\u30bf\u300d\u2192\u300c\u30c7\u30fc\u30bf\u306e\u5165\u529b\u898f\u5247\u300d<\/strong>\u3092\u958b\u304d\u307e\u3059\u3002\u6761\u4ef6\u3092\u300c\u30d7\u30eb\u30c0\u30a6\u30f3\uff08\u7bc4\u56f2\u5185\uff09\u300d\u306b\u3057\u3066\u3001\u7bc4\u56f2\u306e\u5165\u529b\u6b04\u306b<strong>\u300c=INDIRECT(1\u6bb5\u968e\u76ee\u306e\u30bb\u30eb)\u300d<\/strong>\u3068\u5165\u529b\u3057\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u305f\u3068\u3048\u30701\u6bb5\u968e\u76ee\u304cA2\u30bb\u30eb\u306a\u3089\u3001<strong>=INDIRECT(A2)<\/strong> \u3068\u5165\u308c\u307e\u3059\u3002\u3053\u3046\u3059\u308b\u3068\u3001A2\u3067\u300c\u6771\u4eac\u90fd\u300d\u3092\u9078\u3093\u3060\u3068\u304d\u3001INDIRECT\u304c\u300c\u6771\u4eac\u90fd\u300d\u3068\u3044\u3046\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3092\u547c\u3073\u51fa\u3057\u30012\u6bb5\u968e\u76ee\u306b\u6771\u4eac\u90fd\u306e\u5e02\u533a\u753a\u6751\u3060\u3051\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E2%91%A4_%E3%82%AA%E3%83%BC%E3%83%88%E3%83%95%E3%82%A3%E3%83%AB%E3%81%A7%E4%B8%8B%E3%81%AE%E8%A1%8C%E3%81%BE%E3%81%A7%E3%82%B3%E3%83%94%E3%83%BC%E3%81%99%E3%82%8B\"><\/span><span class=\"ez-toc-section\" id=\"step5\"><\/span>\u2464 \u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067\u4e0b\u306e\u884c\u307e\u3067\u30b3\u30d4\u30fc\u3059\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>1\u884c\u76ee\u3067\u52d5\u4f5c\u3092\u78ba\u8a8d\u3067\u304d\u305f\u3089\u30012\u6bb5\u968e\u76ee\u306e\u30bb\u30eb\u3092<strong>\u4e0b\u306e\u884c\u307e\u3067\u30b3\u30d4\u30fc\uff08\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\uff09<\/strong>\u3057\u307e\u3059\u3002\u3053\u308c\u30672\u884c\u76ee\u4ee5\u964d\u3082\u3001\u305d\u308c\u305e\u308c\u306e\u884c\u306e1\u6bb5\u968e\u76ee\u306b\u9023\u52d5\u3059\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u3053\u306e\u3068\u304d\u3001INDIRECT\u306e\u30bb\u30eb\u6307\u5b9a\u306b<strong>\u300c$\u300d\u304c\u4ed8\u3044\u3066\u3044\u306a\u3044\u304b<\/strong>\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<strong>=INDIRECT($A$2)<\/strong> \u306e\u3088\u3046\u306b$\u304c\u4ed8\u3044\u3066\u3044\u308b\u3068\u3001\u3059\u3079\u3066\u306e\u884c\u304c2\u884c\u76ee\u3092\u53c2\u7167\u3057\u3066\u3057\u307e\u3044\u9023\u52d5\u3057\u307e\u305b\u3093\u3002$\u3092\u5916\u3057 <strong>=INDIRECT(A2)<\/strong> \u306e\u5f62\u306b\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<p align=\"center\"><img decoding=\"async\" data-src=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-content\/uploads\/2026\/06\/rendou_2.png\" alt=\"\u4f5c\u6210\u624b\u9806\" width=\"480\" height=\"320\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 480px; --smush-placeholder-aspect-ratio: 480\/320;\" \/><\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%81%A4%E3%81%BE%E3%81%9A%E3%81%8D%E3%82%84%E3%81%99%E3%81%84%E3%83%9D%E3%82%A4%E3%83%B3%E3%83%88%E3%81%A8%E5%AF%BE%E5%87%A6%E6%B3%95\"><\/span><span class=\"ez-toc-section\" id=\"error\"><\/span>\u3064\u307e\u305a\u304d\u3084\u3059\u3044\u30dd\u30a4\u30f3\u30c8\u3068\u5bfe\u51e6\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u3067\u3088\u304f\u3042\u308b\u300c\u3046\u307e\u304f\u3044\u304b\u306a\u3044\u300d\u3092\u3001\u539f\u56e0\u3068\u3042\u308f\u305b\u3066\u6574\u7406\u3057\u307e\u3059\u3002<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<thead>\n<tr>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: left;\">\u75c7\u72b6<\/th>\n<th style=\"background-color: #296b91; color: #ffffff; padding: 10px; border: 1px solid #ccc; font-weight: bold; text-align: left;\">\u4e3b\u306a\u539f\u56e0\u3068\u5bfe\u51e6<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">2\u6bb5\u968e\u76ee\u306b\u4f55\u3082\u51fa\u306a\u3044\uff0f#REF!\u30a8\u30e9\u30fc<\/td>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">1\u6bb5\u968e\u76ee\u304c\u672a\u9078\u629e\u3002\u307e\u305f\u306f\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u306e\u540d\u524d\u30681\u6bb5\u968e\u76ee\u306e\u5024\u304c\u4e00\u81f4\u3057\u3066\u3044\u306a\u3044\u3002\u6587\u5b57\u306e\u8868\u8a18\uff08\u30b9\u30da\u30fc\u30b9\u30fb\u5168\u89d2\u534a\u89d2\uff09\u3092\u5408\u308f\u305b\u308b<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u5168\u90e8\u306e\u884c\u304c\u540c\u3058\u9078\u629e\u80a2\u306b\u306a\u308b<\/td>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">INDIRECT\u306e\u30bb\u30eb\u6307\u5b9a\u306b$\u304c\u4ed8\u3044\u3066\u3044\u308b\u3002=INDIRECT($A$2) \u2192 =INDIRECT(A2) \u306b\u76f4\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u9078\u629e\u80a2\u306b\u7a7a\u6b04\u304c\u6df7\u3056\u308b<\/td>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u306b\u7a7a\u767d\u30bb\u30eb\u3092\u542b\u3081\u3066\u3044\u308b\u3002\u30c7\u30fc\u30bf\u3092\u8a70\u3081\u3066\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u76f4\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">1\u6bb5\u968e\u76ee\u3092\u5909\u3048\u3066\u30822\u6bb5\u968e\u76ee\u304c\u53e4\u3044\u307e\u307e<\/td>\n<td style=\"background-color: #edf1fa; color: #000000; padding: 10px; border: 1px solid #ccc;\">2\u6bb5\u968e\u76ee\u306b\u53e4\u3044\u5024\u304c\u6b8b\u3063\u3066\u3044\u308b\u3060\u3051\u3002\u9078\u3073\u76f4\u305b\u3070\u305d\u306e\u6642\u70b9\u306e\u9078\u629e\u80a2\u306b\u66f4\u65b0\u3055\u308c\u308b<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<br \/>\n\u306a\u304a\u3001\u672a\u9078\u629e\u6642\u306e#REF!\u8868\u793a\u304c\u6c17\u306b\u306a\u308b\u5834\u5408\u306f\u3001\u4f5c\u696d\u7528\u306e\u30bb\u30eb\u3067 <strong>=IFERROR(INDIRECT(A2),&#8221;&#8221;)<\/strong> \u306e\u3088\u3046\u306bIFERROR\u95a2\u6570\u3067\u5305\u3080\u3068\u3001\u30a8\u30e9\u30fc\u3092\u7a7a\u6b04\u306b\u7f6e\u304d\u63db\u3048\u3089\u308c\u307e\u3059\u3002\u30de\u30b9\u30bf\u30fc\u3092\u5225\u30b7\u30fc\u30c8\u306b\u7f6e\u3044\u305f\u5834\u5408\u306f\u3001\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3092\u4f7f\u3046\u3053\u3068\u3067\u30b7\u30fc\u30c8\u540d\u3092\u610f\u8b58\u305b\u305a\u306b\u53c2\u7167\u3067\u304d\u3001\u904b\u7528\u304c\u30e9\u30af\u306b\u306a\u308a\u307e\u3059\u3002\u8907\u6570\u4eba\u3067\u4f7f\u3046\u3068\u304d\u306f\u3001<strong>\u30de\u30b9\u30bf\u30fc\u30b7\u30fc\u30c8\u3092\u4fdd\u8b77\u3057\u3066\u76f4\u63a5\u7de8\u96c6\u3067\u304d\u306a\u3044\u3088\u3046\u306b\u3057\u3066\u304a\u304f<\/strong>\u3068\u3001\u9078\u629e\u80a2\u304c\u58ca\u308c\u306b\u304f\u304f\u5b89\u5fc3\u3067\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u307e\u305f\u3001\u904b\u7528\u3057\u3066\u3044\u308b\u3068<strong>\u3042\u3068\u304b\u3089\u9078\u629e\u80a2\u3092\u5897\u3084\u3057\u305f\u3044<\/strong>\u5834\u9762\u304c\u51fa\u3066\u304d\u307e\u3059\u3002\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u306f\u6307\u5b9a\u3057\u305f\u7bc4\u56f2\u3057\u304b\u53cd\u6620\u3055\u308c\u306a\u3044\u305f\u3081\u3001\u9805\u76ee\u3092\u8ffd\u52a0\u3057\u305f\u3089<strong>\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u306e\u7bc4\u56f2\u3082\u5e83\u3052\u308b<\/strong>\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u6700\u521d\u304b\u3089\u5c11\u3057\u5e83\u3081\u306b\u7bc4\u56f2\u3092\u53d6\u3063\u3066\u304a\u304f\u304b\u3001\u5217\u5168\u4f53\u3092\u7bc4\u56f2\u306b\u6307\u5b9a\u3057\u3066\u7a7a\u6b04\u3092IFERROR\u3067\u9664\u5916\u3059\u308b\u306a\u3069\u3001\u5897\u6e1b\u3092\u898b\u8fbc\u3093\u3060\u4f5c\u308a\u306b\u3057\u3066\u304a\u304f\u3068\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u304c\u30e9\u30af\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p align=\"center\">\n<a href=\"https:\/\/support.google.com\/docs\/answer\/3503919\" target=\"_blank\" rel=\"noopener\" class=\"q_button bt_red\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u516c\u5f0f\u30d8\u30eb\u30d7\uff08\u30d7\u30eb\u30c0\u30a6\u30f3\uff09\u3092\u898b\u308b &#x27a1;<\/a>\n<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%82%82%E3%81%A3%E3%81%A8%E4%BE%BF%E5%88%A9%E3%81%AB%EF%BC%9A%E8%89%B2%E5%88%86%E3%81%91%E3%83%BB3%E6%AE%B5%E9%9A%8E%E9%80%A3%E5%8B%95%E3%83%BB%E8%A4%87%E6%95%B0%E9%81%B8%E6%8A%9E\"><\/span><span class=\"ez-toc-section\" id=\"benri\"><\/span>\u3082\u3063\u3068\u4fbf\u5229\u306b\uff1a\u8272\u5206\u3051\u30fb3\u6bb5\u968e\u9023\u52d5\u30fb\u8907\u6570\u9078\u629e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u57fa\u672c\u304c\u3067\u304d\u305f\u3089\u3001\u73fe\u5834\u3067\u5f79\u7acb\u3064\u5fdc\u7528\u3082\u62bc\u3055\u3048\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E9%81%B8%E6%8A%9E%E8%82%A2%E3%81%94%E3%81%A8%E3%81%AB%E8%89%B2%E3%82%92%E4%BB%98%E3%81%91%E3%82%8B\"><\/span><span class=\"ez-toc-section\" id=\"iro\"><\/span>\u9078\u629e\u80a2\u3054\u3068\u306b\u8272\u3092\u4ed8\u3051\u308b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u30d7\u30eb\u30c0\u30a6\u30f3\u306f<strong>\u9078\u3093\u3060\u5024\u3054\u3068\u306b\u8272\u3092\u5909\u3048\u308b<\/strong>\u3068\u4e00\u6c17\u306b\u898b\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002\u6700\u8fd1\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306f\u30d7\u30eb\u30c0\u30a6\u30f3\u4f5c\u6210\u6642\u306b\u9805\u76ee\u3054\u3068\u306e\u8272\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u304c\u3001\u300c\u5b8c\u4e86\uff1d\u7dd1\uff0f\u5bfe\u5fdc\u4e2d\uff1d\u9ec4\u300d\u306e\u3088\u3046\u306b\u7d30\u304b\u304f\u7ba1\u7406\u3057\u305f\u3044\u5834\u5408\u306f<strong>\u300c\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u300d<\/strong>\u3092\u4f7f\u3046\u3068\u81ea\u7531\u5ea6\u9ad8\u304f\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3%E6%AE%B5%E9%9A%8E%E4%BB%A5%E4%B8%8A%E3%81%AB%E5%A2%97%E3%82%84%E3%81%99\"><\/span><span class=\"ez-toc-section\" id=\"three\"><\/span>3\u6bb5\u968e\u4ee5\u4e0a\u306b\u5897\u3084\u3059<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u300c\u5927\u5206\u985e\u2192\u4e2d\u5206\u985e\u2192\u5c0f\u5206\u985e\u300d\u3068<strong>3\u6bb5\u968e\u4ee5\u4e0a\u306b\u9023\u52d5<\/strong>\u3055\u305b\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u8003\u3048\u65b9\u306f\u540c\u3058\u3067\u30012\u6bb5\u968e\u76ee\u306e\u5024\u3092\u540d\u524d\u306b\u3057\u305f\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3092\u3055\u3089\u306b\u7528\u610f\u3057\u30013\u6bb5\u968e\u76ee\u306e\u7bc4\u56f2\u306b <strong>=INDIRECT(2\u6bb5\u968e\u76ee\u306e\u30bb\u30eb)<\/strong> \u3092\u6307\u5b9a\u3059\u308b\u3060\u3051\u3067\u3059\u3002\u305f\u3060\u3057\u6bb5\u968e\u3084\u9805\u76ee\u304c\u5897\u3048\u308b\u307b\u3069\u3001\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u306e\u7ba1\u7406\u306f\u7169\u96d1\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E8%A4%87%E6%95%B0%E9%81%B8%E6%8A%9E%E3%82%92%E3%81%97%E3%81%9F%E3%81%84%E5%A0%B4%E5%90%88\"><\/span><span class=\"ez-toc-section\" id=\"multi\"><\/span>\u8907\u6570\u9078\u629e\u3092\u3057\u305f\u3044\u5834\u5408<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u6a19\u6e96\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u306f<strong>1\u30bb\u30eb\u306b1\u3064\u306e\u9078\u629e\u304c\u57fa\u672c<\/strong>\u3067\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306e\u3088\u3046\u306a\u8907\u6570\u9078\u629e\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u3002\u3069\u3046\u3057\u3066\u3082\u8907\u6570\u9078\u629e\u304c\u5fc5\u8981\u306a\u3089\u3001GAS\uff08Apps Script\uff09\u3067\u30ab\u30b9\u30bf\u30e0\u306e\u4ed5\u7d44\u307f\u3092\u4f5c\u308b\u304b\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3068TEXTJOIN\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u4f5c\u308a\u8fbc\u307f\u3068\u4fdd\u5b88\u306e\u624b\u9593\u304c\u304b\u304b\u308b\u305f\u3081\u3001\u9805\u76ee\u304c\u591a\u3044\u306a\u3089\u6b21\u7ae0\u306e\u30ce\u30fc\u30b3\u30fc\u30c9\u30c4\u30fc\u30eb\u3092\u691c\u8a0e\u3057\u305f\u307b\u3046\u304c\u73fe\u5b9f\u7684\u3067\u3059\u3002<\/p>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/google-spreadsheet-kansuu\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u304a\u3059\u3059\u3081\u306e\u95a2\u657011\u9078\uff01 &#x27a1;<\/a>\n<\/div>\n<p align=\"center\"><img decoding=\"async\" data-src=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-content\/uploads\/2026\/06\/rendou_3.png\" alt=\"\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af\" width=\"480\" height=\"320\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 480px; --smush-placeholder-aspect-ratio: 480\/320;\" \/><\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E3%81%AE%E3%80%8C%E9%80%A3%E5%8B%95%E3%83%97%E3%83%AB%E3%83%80%E3%82%A6%E3%83%B3%E3%80%8D%E3%81%A7%E9%99%90%E7%95%8C%E3%82%92%E6%84%9F%E3%81%98%E3%81%9F%E3%82%89\"><\/span><span class=\"ez-toc-section\" id=\"genkai\"><\/span>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u300c\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u300d\u3067\u9650\u754c\u3092\u611f\u3058\u305f\u3089<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u306f\u4fbf\u5229\u3067\u3059\u304c\u3001\u904b\u7528\u304c\u5927\u304d\u304f\u306a\u308b\u3068\u6b21\u306e\u3088\u3046\u306a\u58c1\u306b\u3076\u3064\u304b\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li>\u9078\u629e\u80a2\uff08\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\uff09\u304c\u5897\u3048\u3066\u3001\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u304c\u8ffd\u3044\u3064\u304b\u306a\u3044<\/li>\n<li>\u8907\u6570\u4eba\u304c\u540c\u6642\u306b\u7de8\u96c6\u3057\u3066\u3001\u6570\u5f0f\u3084\u9078\u629e\u80a2\u304c\u58ca\u308c\u308b<\/li>\n<li>\u30b9\u30de\u30db\u304b\u3089\u624b\u65e9\u304f\u5165\u529b\u3057\u305f\u3044\u304c\u3001\u8868\u3060\u3068\u4f7f\u3044\u306b\u304f\u3044<\/li>\n<li>\u5165\u529b\u5f8c\u306b\u300c\u627f\u8a8d\u300d\u300c\u96c6\u8a08\u300d\u300c\u901a\u77e5\u300d\u307e\u3067\u81ea\u52d5\u3067\u3084\u308a\u305f\u3044<\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n\u3053\u3046\u3057\u305f<strong>\u300c\u8868\u8a08\u7b97\u306e\u9650\u754c\u300d<\/strong>\u3092\u611f\u3058\u59cb\u3081\u305f\u3089\u3001<strong>\u30ce\u30fc\u30b3\u30fc\u30c9\u30c4\u30fc\u30eb\u3067\u696d\u52d9\u30a2\u30d7\u30ea\u306b\u3059\u308b<\/strong>\u306e\u304c\u6b21\u306e\u4e00\u624b\u3067\u3059\u3002Google\u306eAppSheet\u3084\u30b5\u30a4\u30dc\u30a6\u30ba\u306ekintone\u306a\u3089\u3001\u9023\u52d5\u3059\u308b\u9078\u629e\u80a2\uff08\u53c2\u7167\uff09\u3084\u30b9\u30de\u30db\u5165\u529b\u3001\u627f\u8a8d\u30d5\u30ed\u30fc\u3001\u81ea\u52d5\u96c6\u8a08\u307e\u3067\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306a\u3057\u3067\u4f5c\u308c\u307e\u3059\u3002\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u305d\u306e\u307e\u307e\u30a2\u30d7\u30ea\u306e\u571f\u53f0\u306b\u4f7f\u3048\u308b\u30c4\u30fc\u30eb\u3082\u3042\u308a\u3001\u3053\u308c\u307e\u3067\u306e\u8cc7\u7523\u3092\u6d3b\u304b\u3057\u306a\u304c\u3089\u79fb\u884c\u3067\u304d\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u300c\u3069\u3053\u307e\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u9811\u5f35\u308a\u3001\u3069\u3053\u304b\u3089\u30a2\u30d7\u30ea\u5316\u3059\u308b\u304b\u300d\u306f\u3001\u696d\u52d9\u91cf\u3068\u4eba\u6570\u3067\u5909\u308f\u308a\u307e\u3059\u3002\u30a2\u30fc\u30c7\u30f3\u30c8\u306f\u4e2d\u5c0f\u4f01\u696d\u306e\u30ce\u30fc\u30b3\u30fc\u30c9\u5c0e\u5165\u3092\u6570\u591a\u304f\u652f\u63f4\u3057\u3066\u304a\u308a\u3001\u6700\u9069\u306a\u7dda\u5f15\u304d\u304b\u3089\u3054\u63d0\u6848\u3067\u304d\u307e\u3059\u3002<\/p>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/appsheet-dekiru\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">AppSheet\u3067\u3067\u304d\u308b\u3053\u3068\u306f\uff1f\u4e2d\u5c0f\u4f01\u696d\u306e\u696d\u52d9\u30a2\u30d7\u30ea\u3092\u201c\u81ea\u793e\u3067\u201d\u4f5c\u308b\u65b9\u6cd5\u3092\u3084\u3055\u3057\u304f\u89e3\u8aac &#x27a1;<\/a>\n<\/div>\n<div style=\"border: 1px solid #f0d6d8; border-left: 5px solid #c8161d; background: #fdf5f5; padding: 14px 18px; margin: 16px 0; border-radius: 4px;\">\n<div style=\"font-size: 12px; color: #8b5a5d; margin-bottom: 6px; font-weight: bold; letter-spacing: 0.05em;\">\u25bc \u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/div>\n<p><a href=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/costdown\/google-microsoft\/kintone-vs-appsheet\/\" style=\"color: #8a0e15; text-decoration: none; font-weight: bold; font-size: 15px; line-height: 1.5;\">\u30102026\u5e74\u7248\u3011kintone\u3068AppSheet\u3092\u5fb9\u5e95\u6bd4\u8f03\uff01\u30b3\u30b9\u30c8\u30fb\u6a5f\u80fd\u30fb\u958b\u767a\u306e\u3057\u3084\u3059\u3055\u3067\u9078\u3076 &#x27a1;<\/a>\n<\/div>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%83%87%E3%82%B8%E3%82%BF%E3%83%AB%E5%8C%96%E3%83%BBAI%E5%B0%8E%E5%85%A5%E8%A3%9C%E5%8A%A9%E9%87%91%E3%81%AF%E4%BD%BF%E3%81%88%E3%82%8B%EF%BC%9F\"><\/span><span class=\"ez-toc-section\" id=\"hojyokin\"><\/span>\u30c7\u30b8\u30bf\u30eb\u5316\u30fbAI\u5c0e\u5165\u88dc\u52a9\u91d1\u306f\u4f7f\u3048\u308b\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u306e\u3088\u3046\u306a\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u5de5\u592b\u306f<strong>\u7121\u6599\u3067\u4eca\u3059\u3050\u59cb\u3081\u3089\u308c\u308b<\/strong>\u306e\u304c\u9b45\u529b\u3067\u3059\u3002\u4e00\u65b9\u3067\u3001\u672c\u683c\u7684\u306b\u30ce\u30fc\u30b3\u30fc\u30c9\u3067\u696d\u52d9\u30a2\u30d7\u30ea\u5316\u3057\u305f\u308a\u3001Google Workspace\u3084Microsoft 365\u3068\u3044\u3063\u305f\u30af\u30e9\u30a6\u30c9\u306e\u571f\u53f0\u3092\u6574\u3048\u305f\u308a\u3059\u308b\u6bb5\u968e\u306b\u306a\u308b\u3068\u3001<strong>\u30c7\u30b8\u30bf\u30eb\u5316\u30fbAI\u5c0e\u5165\u88dc\u52a9\u91d1\u3092\u6d3b\u7528\u3057\u3066\u30b3\u30b9\u30c8\u3092\u6291\u3048\u3089\u308c\u308b<\/strong>\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\nkintone\u3084Google Workspace\u306a\u3069\u306f\u88dc\u52a9\u91d1\u306e\u5bfe\u8c61\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u3001\u30c4\u30fc\u30eb\u8cbb\u7528\u3084\u5c0e\u5165\u652f\u63f4\u8cbb\u3092\u88dc\u52a9\u91d1\u3067\u307e\u304b\u306a\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u300c\u307e\u305a\u306f\u7121\u6599\u306e\u5de5\u592b\u304b\u3089\u59cb\u3081\u3001\u672c\u683c\u5316\u3059\u308b\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u88dc\u52a9\u91d1\u3092\u4f7f\u3046\u300d\u3068\u3044\u3046\u9032\u3081\u65b9\u306a\u3089\u3001\u7121\u7406\u306a\u304fDX\u3092\u5e83\u3052\u3089\u308c\u307e\u3059\u3002\u88dc\u52a9\u91d1\u306f\u5e74\u5ea6\u3084\u67a0\u3067\u6761\u4ef6\u304c\u5909\u308f\u308b\u305f\u3081\u3001\u691c\u8a0e\u6642\u306f\u6700\u65b0\u60c5\u5831\u306e\u78ba\u8a8d\u3084\u5c02\u9580\u5bb6\u3078\u306e\u76f8\u8ac7\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n<p align=\"center\"><img decoding=\"async\" data-src=\"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-content\/uploads\/2026\/06\/rendou_4.png\" alt=\"\u88dc\u52a9\u91d1\u3067\u5c0e\u5165\" width=\"480\" height=\"320\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 480px; --smush-placeholder-aspect-ratio: 480\/320;\" \/><\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%82%88%E3%81%8F%E3%81%82%E3%82%8B%E8%B3%AA%E5%95%8F%EF%BC%88FAQ%EF%BC%89\"><\/span><span class=\"ez-toc-section\" id=\"faq\"><\/span>\u3088\u304f\u3042\u308b\u8cea\u554f\uff08FAQ\uff09<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Q1. \u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\uff082\u6bb5\u968e\u30d7\u30eb\u30c0\u30a6\u30f3\uff09\u3068\u306f\u4f55\u3067\u3059\u304b\uff1f<\/strong><br \/>\n&nbsp;<br \/>\nA. 1\u6bb5\u968e\u76ee\u3067\u9078\u3093\u3060\u5185\u5bb9\u306b\u5fdc\u3058\u3066\u30012\u6bb5\u968e\u76ee\u306e\u9078\u629e\u80a2\u304c\u81ea\u52d5\u3067\u7d5e\u308a\u8fbc\u307e\u308c\u308b\u4ed5\u7d44\u307f\u3067\u3059\u3002Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u306f\u300c\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u300d\u3068\u300cINDIRECT\u95a2\u6570\u300d\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u4f5c\u308a\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n<strong>Q2. \u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u306f\u3069\u3046\u3084\u3063\u3066\u4f5c\u308a\u307e\u3059\u304b\uff1f<\/strong><br \/>\n&nbsp;<br \/>\nA. \u2460\u9078\u629e\u80a2\u306e\u8868\u3092\u7528\u610f\u3001\u24611\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u6210\u3001\u24622\u6bb5\u968e\u76ee\u306e\u5404\u30ea\u30b9\u30c8\u306b1\u6bb5\u968e\u76ee\u3068\u540c\u3058\u540d\u524d\u3067\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3092\u8a2d\u5b9a\u3001\u24632\u6bb5\u968e\u76ee\u306e\u7bc4\u56f2\u306b\u300c=INDIRECT(1\u6bb5\u968e\u76ee\u306e\u30bb\u30eb)\u300d\u3092\u6307\u5b9a\u3001\u306e\u624b\u9806\u3067\u4f5c\u308c\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n<strong>Q3. #REF!\u30a8\u30e9\u30fc\u3084\u3001\u5168\u884c\u304c\u540c\u3058\u9078\u629e\u80a2\u306b\u306a\u308b\u306e\u306f\u306a\u305c\u3067\u3059\u304b\uff1f<\/strong><br \/>\n&nbsp;<br \/>\nA. #REF!\u306f1\u6bb5\u968e\u76ee\u304c\u672a\u9078\u629e\u304b\u3001\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u306e\u540d\u524d\u3068\u5024\u304c\u4e0d\u4e00\u81f4\u306a\u3068\u304d\u306b\u51fa\u307e\u3059\u3002\u5168\u884c\u304c\u540c\u3058\u306b\u306a\u308b\u306e\u306fINDIRECT\u306b$\u304c\u4ed8\u3044\u3066\u3044\u308b\u306e\u304c\u539f\u56e0\u3067\u3001=INDIRECT(A2)\u306e\u5f62\u306b\u76f4\u3059\u3068\u89e3\u6d88\u3057\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n<strong>Q4. \u30d7\u30eb\u30c0\u30a6\u30f3\u3067\u8907\u6570\u9078\u629e\u306f\u3067\u304d\u307e\u3059\u304b\uff1f<\/strong><br \/>\n&nbsp;<br \/>\nA. \u6a19\u6e96\u3067\u306f1\u30bb\u30eb1\u3064\u306e\u9078\u629e\u304c\u57fa\u672c\u3067\u3001\u8907\u6570\u9078\u629e\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u3002GAS\u3084\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\uff0bTEXTJOIN\u3067\u4ee3\u66ff\u3067\u304d\u307e\u3059\u304c\u3001\u9805\u76ee\u304c\u591a\u3044\u306a\u3089\u30ce\u30fc\u30b3\u30fc\u30c9\u306e\u696d\u52d9\u30a2\u30d7\u30ea\u5316\u304c\u73fe\u5b9f\u7684\u3067\u3059\u3002<\/p>\n<div style=\"height: 20px;\"><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E3%81%BE%E3%81%A8%E3%82%81\"><\/span><span class=\"ez-toc-section\" id=\"matome\"><\/span>\u307e\u3068\u3081<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\u306f\u3001<strong>\u300c\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u300d\uff0b\u300cINDIRECT\u95a2\u6570\u300d<\/strong>\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u4f5c\u308c\u307e\u3059\u3002\u2460\u9078\u629e\u80a2\u306e\u8868\u3092\u7528\u610f\u3057\u3001\u24611\u6bb5\u968e\u76ee\u306e\u30d7\u30eb\u30c0\u30a6\u30f3\u3092\u4f5c\u308a\u3001\u24622\u6bb5\u968e\u76ee\u306b1\u6bb5\u968e\u76ee\u3068\u540c\u3058\u540d\u524d\u306e\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3092\u8a2d\u5b9a\u3057\u3001\u24632\u6bb5\u968e\u76ee\u306e\u7bc4\u56f2\u306b=INDIRECT(1\u6bb5\u968e\u76ee\u306e\u30bb\u30eb)\u3092\u6307\u5b9a\u3059\u308b\u2015\u2015\u3053\u306e4\u30b9\u30c6\u30c3\u30d7\u304c\u57fa\u672c\u3067\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u3046\u307e\u304f\u3044\u304b\u306a\u3044\u3068\u304d\u306f\u3001\u540d\u524d\u3068\u5024\u306e\u4e00\u81f4\u3001INDIRECT\u306e$\u306e\u6709\u7121\u3001\u7a7a\u767d\u30bb\u30eb\u306e\u6df7\u5165\u3092\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002\u8272\u5206\u3051\u30843\u6bb5\u968e\u9023\u52d5\u307e\u3067\u5e83\u3052\u308c\u3070\u3001\u5165\u529b\u306e\u6b63\u78ba\u3055\u3068\u898b\u3084\u3059\u3055\u304c\u3055\u3089\u306b\u9ad8\u307e\u308a\u307e\u3059\u3002<br \/>\n&nbsp;<br \/>\n\u305d\u3057\u3066\u904b\u7528\u304c\u5927\u304d\u304f\u306a\u308a\u300c\u8868\u8a08\u7b97\u3067\u306f\u9650\u754c\u300d\u3068\u611f\u3058\u305f\u3089\u3001AppSheet\u3084kintone\u3067\u306e\u696d\u52d9\u30a2\u30d7\u30ea\u5316\u304c\u6b21\u306e\u4e00\u624b\u3067\u3059\u3002\u30a2\u30fc\u30c7\u30f3\u30c8\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u6d3b\u7528\u304b\u3089\u30ce\u30fc\u30b3\u30fc\u30c9\u5c0e\u5165\u3001\u88dc\u52a9\u91d1\u3092\u4f7f\u3063\u305f\u30b3\u30b9\u30c8\u524a\u6e1b\u307e\u3067\u3092\u4e00\u8cab\u3057\u3066\u3054\u652f\u63f4\u3057\u307e\u3059\u3002\u696d\u52d9\u306e\u52b9\u7387\u5316\u3084DX\u3092\u3054\u691c\u8a0e\u306e\u65b9\u306f\u3001\u304a\u6c17\u8efd\u306b\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044\u3002<\/p>\n<p align=\"center\"><a href=\"https:\/\/ardent.jp\/ict-soudanshitu-form\/\" class=\"q_button bt_red\">\u304a\u554f\u5408\u305b\u306f\u3053\u3061\u3089&#x27a1;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u9023\u52d5\u30d7\u30eb\u30c0\u30a6\u30f3\uff082\u6bb5\u968e\u30d7\u30eb\u30c0\u30a6\u30f3\uff09\u306e\u4f5c\u308a\u65b9\u3092\u3001\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3068INDIRECT\u95a2\u6570\u3092\u4f7f\u3063\u30665\u30b9\u30c6\u30c3\u30d7\u3067\u89e3\u8aac\u3002#REF!\u30a8\u30e9\u30fc\u3084$\u8a18\u53f7\u306e\u5bfe\u51e6\u3001\u8272\u5206\u3051\u30fb3\u6bb5\u968e\u9023\u52d5\u30fb\u8907\u6570\u9078\u629e\u3001\u30ce\u30fc\u30b3\u30fc\u30c9\u6d3b\u7528\u3084\u88dc\u52a9\u91d1\u307e\u3067\u4e2d\u5c0f\u4f01\u696d\u5411\u3051\u306b\u3084\u3055\u3057\u304f\u307e\u3068\u3081\u307e\u3057\u305f\u3002","protected":false},"author":11,"featured_media":25552,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[51],"class_list":["post-25556","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-microsoft","tag-google-work-space"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-content\/uploads\/2026\/06\/rendou_1.png","_links":{"self":[{"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/posts\/25556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/comments?post=25556"}],"version-history":[{"count":1,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/posts\/25556\/revisions"}],"predecessor-version":[{"id":25557,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/posts\/25556\/revisions\/25557"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/media\/25552"}],"wp:attachment":[{"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/media?parent=25556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/categories?post=25556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ardent.jp\/rentoffice-consultation-center\/wp-json\/wp\/v2\/tags?post=25556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}