{"blog_title":"shikumika\u2019s diary","provider_name":"Hatena Blog","blog_url":"https://shikumika.org/","description":"PowerQuery\u3067\u3001Excel\u306eVLOOKUP\u95a2\u6570\u306e\u300c\u691c\u7d22\u306e\u578b\u3092TRUE\u300d\uff08\u8fd1\u4f3c\u4e00\u81f4\uff09\u306b\u3059\u308b\u65b9\u6cd5\u306e\u5099\u5fd8\u9332\u3002Excel\u3067\u306f\u3001\u300c\u5e74\u9f62\u300d\u3092\u300c\u5e74\u4ee3\u300d\u306b\u5909\u63db\u306a\u3069\u3001\u533a\u9593\u5206\u3051\uff08\u30d3\u30cb\u30f3\u30b0\uff09\u306bVLOOKUP\u95a2\u6570\u306f\u4fbf\u5229\u3067\u3059\u3002 PowerQuery\u3067\u3082\u540c\u69d8\u306e\u51e6\u7406\u3092\u5b9f\u73fe\u3057\u305f\u3044\u5834\u5408\u304c\u3042\u308a\u3001\u305d\u306e\u624b\u9806\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002 \u5185\u5bb9\uff1a \u4e8b\u4f8b\u306e\u524d\u63d0 \u30a2\u30a6\u30c8\u30d7\u30c3\u30c8\u30a4\u30e1\u30fc\u30b8 \u5b9f\u65bd\u624b\u9806 \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5 \u300c\u7a7a\u306e\u30af\u30a8\u30ea\u300d\u306e\u4f5c\u6210 \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u4f5c\u6210 \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u540d\u79f0\u5909\u66f4 \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u547c\u3073\u51fa\u3057 \u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u306e\u8a2d\u5b9a \u30ab\u30b9\u30bf\u30e0\u5217\u3067\u5b9f\u65bd\u3059\u308b\u65b9\u6cd5 \u30ab\u30b9\u30bf\u30e0\u5217\u306e\u8ffd\u52a0 \u4e8b\u4f8b\u306e\u524d\u63d0 Excel\u306eVLOOKUP\u95a2\u6570\u3067\u5b9f\u65bd\u3059\u308b\u6b21\u306e\u4e8b\u4f8b\u3092Powe\u2026","width":"100%","height":"190","author_url":"https://blog.hatena.ne.jp/ycloud/","url":"https://shikumika.org/entry/powerquery-binning","author_name":"ycloud","version":"1.0","title":"\u3010Power Query\u3011VLOOKUP\u306e\u8fd1\u4f3c\u4e00\u81f4\u3068\u540c\u69d8\u51e6\u7406\uff1a\u533a\u9593\u5206\u3051\uff08\u30d3\u30cb\u30f3\u30b0\uff09\u306e\u65b9\u6cd5","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/y/ycloud/20230929/20230929162645.jpg","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshikumika.org%2Fentry%2Fpowerquery-binning\" title=\"\u3010Power Query\u3011VLOOKUP\u306e\u8fd1\u4f3c\u4e00\u81f4\u3068\u540c\u69d8\u51e6\u7406\uff1a\u533a\u9593\u5206\u3051\uff08\u30d3\u30cb\u30f3\u30b0\uff09\u306e\u65b9\u6cd5 - shikumika\u2019s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","categories":["PowerQuery"],"type":"rich","published":"2023-09-30 12:30:00"}