{"id":525,"date":"2016-02-17T13:01:44","date_gmt":"2016-02-17T04:01:44","guid":{"rendered":"https:\/\/cg-method.com\/entry\/2016\/02\/17\/130144"},"modified":"2022-12-23T16:53:12","modified_gmt":"2022-12-23T07:53:12","slug":"excel-reference-merged-cell","status":"publish","type":"post","link":"https:\/\/cg-method.com\/excel-reference-merged-cell\/","title":{"rendered":"Excel\u2502\u7d50\u5408\u30bb\u30eb\u306b\u306a\u3063\u3066\u3044\u308b\u8868\u304b\u3089\u6570\u5b57\u3092\u53c2\u7167\u3059\u308b\u3084\u308a\u65b9"},"content":{"rendered":"\n
\u672c\u8a18\u4e8b\u3067\u306f\u7d50\u5408\u30bb\u30eb\u306b\u306a\u3063\u3066\u3044\u308b\u8868\u304b\u3089\u6570\u5b57\u3092\u53c2\u7167\u3059\u308b\u3084\u308a\u65b9\u3092\u7d39\u4ecb\u3057\u307e\u3059\uff01<\/p>\n\n\n\n
\u6307\u5b9a\u7bc4\u56f2\u5185\u306e\u300c\u533a\u5206\u300d\u306e\u691c\u7d22\u5024\u304b\u3089\u300c\u756a\u53f7\u300d\u306e\u5024\u3092\u30aa\u30d5\u30bb\u30c3\u30c8\u3057\u305f \u5217<\/strong> \u3068\u300c\u6587\u5b57\u300d\u306e\u691c\u7d22\u5024\u306e \u884c<\/strong> \u304c\u4ea4\u5dee\u3059\u308b\u3042\u308b\u30bb\u30eb\u3092\u53c2\u7167\u3057\u307e\u3059\u3002 \u203bINDEX\u95a2\u6570\u3000\u6307\u5b9a\u3057\u305f\u4f4d\u7f6e\u306b\u3042\u308b\u30bb\u30eb\u306e\u53c2\u7167\u307e\u305f\u306f\u5024\u3092\u6c42\u3081\u308b<\/p>\n\n\n\n \u203bMATCH\u95a2\u6570\u3000\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u7bc4\u56f2\u3092\u691c\u7d22\u3057\u3001\u305d\u306e\u9805\u76ee\u306e\u76f8\u5bfe\u7684\u306a\u4f4d\u7f6e\uff08\u4e0a\/\u5de6\u304b\u3089\u6570\u3048\u3066\u4f55\u756a\u76ee\u304b\uff09\u3092\u8fd4\u3059<\/p>\n\n\n\n IF\u6587\u3067\u6761\u4ef6\u5225\u3067\u6570\u5b57\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\n<\/p>\n\n\n\n=INDEX(B2:D8,MATCH(F4,B2:B8,0)+(G4-1),MATCH("\u6587\u5b57",B2:D2,0))<\/code><\/pre><\/div>\n\n\n\n
IF\u6587\u3067\u7d50\u5408\u30bb\u30eb\u306b\u306a\u3063\u3066\u3044\u308b\u8868\u304b\u3089\u6570\u5b57\u3092\u53c2\u7167\u3059\u308b\u3084\u308a\u65b9<\/h2>\n\n\n\n