{"blog_title":"shikumika\u2019s diary","width":"100%","author_url":"https://blog.hatena.ne.jp/ycloud/","published":"2025-01-10 12:30:00","height":"190","categories":["Excel"],"type":"rich","version":"1.0","author_name":"ycloud","title":"\u3010Excel\u3011XLOOKUP\u3067\u691c\u7d22\u5024\u306e\u3044\u305a\u308c\u304b\u306b\u201d\u4e00\u81f4\u201d\u3059\u308b\u6700\u521d\u306e\u7d50\u679c\u3092\u62bd\u51fa\u3059\u308b\u65b9\u6cd5","blog_url":"https://shikumika.org/","description":"Microsoft365\u306eExcel\u306b\u3042\u308bXLOOKUP\u95a2\u6570\u3067\u3001\u691c\u7d22\u5024\u306e\uff3b\u4e00\u81f4\u30e2\u30fc\u30c9\uff3d\u306b\u300c\u6b63\u898f\u8868\u73fe\u306b\u4e00\u81f4\u3059\u308b\u300d\u3068\u3044\u3046\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3057\u305f\u3002 \u3010Excel\u3011XLOOKUP\u3067\u691c\u7d22\u5024\u306e\u3044\u305a\u308c\u304b\u3092\u542b\u3080\u6700\u521d\u306e\u7d50\u679c\u3092\u62bd\u51fa\u3059\u308b\u65b9\u6cd5\u3067\u306f\u3001\u300c\u3044\u305a\u308c\u304b\u3092\u542b\u3080\u300d\u3068\u3044\u3046\u6761\u4ef6\u306e\u8a2d\u5b9a\u4f8b\u3067\u3057\u305f\u3002 \u4eca\u56de\u306f\u3001XLOOKUP\u3067\u300c\u3044\u305a\u308c\u304b\u3068\u5b8c\u5168\u306b\u4e00\u81f4\u3059\u308b\u300d\u306e\u65b9\u6cd5\u3067\u3059\u3002 \u5185\u5bb9\uff1a \u4e8b\u4f8b\u306e\u524d\u63d0 XLOOKUP\u3067\u300c\u3044\u305a\u308c\u304b\u3068\u5b8c\u5168\u306b\u4e00\u81f4\u3059\u308b\u300d\u306e\u6570\u5f0f TEXTJOIN\u95a2\u6570\u3092\u3042\u308f\u305b\u305f\u6d3b\u7528\u4f8b \u52d5\u4f5c\u78ba\u8a8d\u306eExcel\u306f\u300cMicrosoft\u00ae Excel\u00ae for Microsoft 365 MSO\u300d\uff08\u30d0\u30fc\u30b8\u30e7\u30f32411\uff09\u3067\u3059\u3002 \u4e8b\u4f8b\u306e\u524d\u63d0 \u8aac\u660e\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshikumika.org%2Fentry%2Fexcel-xlookup-regex-match\" title=\"\u3010Excel\u3011XLOOKUP\u3067\u691c\u7d22\u5024\u306e\u3044\u305a\u308c\u304b\u306b\u201d\u4e00\u81f4\u201d\u3059\u308b\u6700\u521d\u306e\u7d50\u679c\u3092\u62bd\u51fa\u3059\u308b\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>","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/y/ycloud/20250108/20250108135304.jpg","url":"https://shikumika.org/entry/excel-xlookup-regex-match","provider_url":"https://hatena.blog","provider_name":"Hatena Blog"}