{"url":"https://ell104.hatenablog.jp/entry/2022/08/02/120601","description":"Excel2021 \u306e XLOOKUP\u95a2\u6570 \u3092\u2026\u8a66\u3057\u3066\u307f\u305f\u3089\u4fbf\u5229\u904e\u304e\u3061\u3083\u3063\u305f\u3041\uff5e!? \u76f4\u611f\u7684\u306b\u7e26\u3067\u3082\u6a2a\u3067\u3082\u691c\u7d22\u3067\u304d\u308b!? Excel2021\u304b\u3089\u642d\u8f09\u3055\u308c\u3066\u3044\u308b\u65b0\u95a2\u6570\u306eXLOOKUP\u95a2\u6570\u3092\u4e00\u5ea6\u8a66\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u4eca\u8fc4\u306f\u3001\u53e4\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306eExcel\u3084\u3063\u305f\u306e\u3067\u3001\u8a66\u3059\u3053\u3068\u3059\u3089\u51fa\u6765\u306a\u304b\u3063\u305f\u3093\u3067\u3059\u306d\u2026 \u3067\u3082\u3001\u4eca\u56de\u3001Office2021\u3092\u5c0e\u5165\u3057\u305f\u306e\u3067\u3001\u5ff5\u9858\u306eXLOOKUP\u95a2\u6570\u3092\u8a66\u3059\u3053\u3068\u304c\u51fa\u6765\u307e\u3057\u305f\u3002 \u57fa\u672c\u7684\u306b\u306f\u3001\u6a2a\u65b9\u5411\u306e\u691c\u7d22\u306eVLOOKUP\u95a2\u6570\u3084\u7e26\u65b9\u5411\u306e\u691c\u7d22\u306eHLOOKUP\u95a2\u6570\u3068\u540c\u3058\u306a\u306e\u3067\u3059\u304c\u3001XLOOKUP\u95a2\u6570\u306e\u5834\u5408\u306f\u3001\u6a2a\u65b9\u5411\u3082\u7e26\u65b9\u5411\u3082\u691c\u7d22\u304c\u53ef\u80fd\u306a\u3093\u3067\u3059\u3088\u3002 =XLOOKUP(\u3010\u691c\u7d22\u5024\u3011,\u3010\u2026","author_name":"ell104","height":"190","blog_title":" ELL\u306e\u8db3\u8de1","categories":["\u65e5\u3005\u306e\u30d1\u30bd\u30b3\u30f3"],"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/e/ell104/20250421/20250421233518.png","blog_url":"https://ell104.hatenablog.jp/","provider_name":"Hatena Blog","published":"2022-08-02 12:06:01","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fell104.hatenablog.jp%2Fentry%2F2022%2F08%2F02%2F120601\" title=\"XLOOKUP\u95a2\u6570\u3063\u3066\u4fbf\u5229\u904e\u304e\u3066VLOOKUP\u30fbHLOOKUP\u95a2\u6570\u306a\u3093\u304b\u4f7f\u308f\u308c\u3078\u3093\u306a\u3041\uff5e\uff01 -  ELL\u306e\u8db3\u8de1\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","author_url":"https://blog.hatena.ne.jp/ell104/","title":"XLOOKUP\u95a2\u6570\u3063\u3066\u4fbf\u5229\u904e\u304e\u3066VLOOKUP\u30fbHLOOKUP\u95a2\u6570\u306a\u3093\u304b\u4f7f\u308f\u308c\u3078\u3093\u306a\u3041\uff5e\uff01","type":"rich","width":"100%"}