{"version":"1.0","width":"100%","type":"rich","author_name":"info_lab_room","blog_title":"\u307f\u3061\u304f\u3055\u5de5\u623f\u306e\u3057\u3089\u3079\u3082\u306e\u30ce\u30fc\u30c8","provider_name":"Hatena Blog","title":"\u3010Excel\u4e8b\u52d9\u8077\u8b1b\u5ea7 #13\u3011XLOOKUP\u304c\u306a\u304f\u3066\u3082\u5927\u4e08\u592b\uff01\u300cINDEX\u95a2\u6570\u00d7MATCH\u95a2\u6570\u300d\u3067\u81ea\u7531\u81ea\u5728\u306b\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u3059\u308b\u6280\uff5cVLOOKUP\u306e\u9650\u754c\u3092\u8d85\u3048\u308b","author_url":"https://blog.hatena.ne.jp/info_lab_room/","blog_url":"https://infolab.hatenablog.com/","height":"190","description":"\u300c\u5546\u54c1ID\u304b\u3089\u5546\u54c1\u540d\u3092\u51fa\u3057\u305f\u3044\u306e\u306b\u3001\u8868\u306e\u4e26\u3073\u9806\u304c\u9006\uff08ID\u304c\u53f3\u5074\uff09\u3067VLOOKUP\u304c\u4f7f\u3048\u306a\u3044\u2026\u300d\u300c\u5217\u3092\u633f\u5165\u3057\u305f\u3089VLOOKUP\u306e\u5217\u756a\u53f7\u304c\u30ba\u30ec\u3066\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\uff01\u300d \u53e4\u3044\u30a8\u30af\u30bb\u30eb\u3092\u4f7f\u3063\u3066\u3044\u308b\u4e8b\u52d9\u8077\u306e\u65b9\u306b\u3068\u3063\u3066\u3001VLOOKUP\u306e\u300c\u5de6\u5074\u3057\u304b\u691c\u7d22\u3067\u304d\u306a\u3044\u300d\u3068\u3044\u3046\u5236\u7d04\u306f\u5927\u304d\u306a\u30b9\u30c8\u30ec\u30b9\u3067\u3059\u3002\u3057\u304b\u3057\u3001\u8868\u306e\u5217\u3092\u308f\u3056\u308f\u3056\u4e26\u3079\u66ff\u3048\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002 \u300cINDEX\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff09\u300d\u3068\u300cMATCH\uff08\u30de\u30c3\u30c1\uff09\u300d\u3068\u3044\u30462\u3064\u306e\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308c\u3070\u3001\u8868\u306e\u3069\u3053\u306b\u3042\u308b\u30c7\u30fc\u30bf\u3067\u3082\u81ea\u7531\u81ea\u5728\u306b\u53d6\u308a\u51fa\u305b\u307e\u3059\u3002XLOOKUP\u304c\u4f7f\u3048\u306a\u3044\u74b0\u5883\u3067\u306f\u3001\u3053\u308c\u304c\u6700\u5f37\u306e\u691c\u7d22\u30c6\u30af\u30cb\u30c3\u30af\u3067\u3059\u3002 \u76ee\u6b21 \u3010\u6982\u5ff5\u3011\u300c\u5730\u56f3\u306e\u5ea7\u6a19\u300d\u3067\u8003\u3048\u308b \u3010MATCH\u95a2\u6570\u3011\u300c\u4f55\u884c\u76ee\u2026","published":"2026-02-03 23:38:26","url":"https://infolab.hatenablog.com/entry/2026/02/03/233826","image_url":"https://m.media-amazon.com/images/I/51OQDSshpjL._SL500_.jpg","provider_url":"https://hatena.blog","categories":["Excel"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Finfolab.hatenablog.com%2Fentry%2F2026%2F02%2F03%2F233826\" title=\"\u3010Excel\u4e8b\u52d9\u8077\u8b1b\u5ea7 #13\u3011XLOOKUP\u304c\u306a\u304f\u3066\u3082\u5927\u4e08\u592b\uff01\u300cINDEX\u95a2\u6570\u00d7MATCH\u95a2\u6570\u300d\u3067\u81ea\u7531\u81ea\u5728\u306b\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u3059\u308b\u6280\uff5cVLOOKUP\u306e\u9650\u754c\u3092\u8d85\u3048\u308b - \u307f\u3061\u304f\u3055\u5de5\u623f\u306e\u3057\u3089\u3079\u3082\u306e\u30ce\u30fc\u30c8\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}