{"width":"100%","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/y/ycloud/20240409/20240409194512.jpg","version":"1.0","blog_title":"shikumika\u2019s diary","author_url":"https://blog.hatena.ne.jp/ycloud/","type":"rich","categories":["Excel"],"height":"190","blog_url":"https://shikumika.org/","author_name":"ycloud","published":"2024-04-10 12:30:00","url":"https://shikumika.org/entry/excel-vlookup-right","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshikumika.org%2Fentry%2Fexcel-vlookup-right\" title=\"\u3010Excel\u3011VLOOKUP\u95a2\u6570\u3067\u306f\u4e0d\u53ef\u80fd\u306a\u300c\u53f3\u5074\u304b\u3089\u5024\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\u300d - 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","title":"\u3010Excel\u3011VLOOKUP\u95a2\u6570\u3067\u306f\u4e0d\u53ef\u80fd\u306a\u300c\u53f3\u5074\u304b\u3089\u5024\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\u300d","provider_name":"Hatena Blog","description":"Excel\u306eVLOOKUP\u95a2\u6570\u3067\u3001\u53f3\u5074\u304b\u3089\u5de6\u5074\u306e\u5024\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u306f\u4e0d\u53ef\u80fd\u3067\u3059\u304c\u3001VLOOKUP\u95a2\u6570\u306e\u6539\u826f\u7248\u3067\u3042\u308bXLOOKUP\u95a2\u6570\u306a\u3089\u53ef\u80fd\u3067\u3059\u3002 XLOOKUP\u95a2\u6570\u306f\u3001Excel 2016 \u304a\u3088\u3073 Excel 2019 \u3067\u306f\u4f7f\u7528\u3067\u304d\u305a\u3001\u65b0\u3057\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306e Excel\u304b\u3089\u4f7f\u7528\u53ef\u80fd\u3067\u3059\u3002 \u5185\u5bb9\uff1a \u53f3\u5074\u304b\u3089\u5de6\u5074\u306e\u5024\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5 XLOOKUP\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u306e\u88dc\u8db3 \u53f3\u5074\u304b\u3089\u5de6\u5074\u306e\u5024\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5 VLOOKUP\u95a2\u6570\u306f\u3001\u8868\u306e\u5de6\u7aef\u5217\u3092\u691c\u7d22\u3057\u3066\u53f3\u5074\u306e\u5024\u306f\u53d6\u5f97\u53ef\u80fd\u3067\u3059\u304c\u3001\u53f3\u5074\u304b\u3089\u5de6\u5074\u306e\u5024\u306f\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002 \u305d\u306e\u305f\u3081\u3001\u5f93\u6765\u3067\u3042\u308c\u3070INDEX\u95a2\u6570\u3068MATCH\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5\u306a\u3069\u3067\u5bfe\u5fdc\u304c\u5fc5\u8981\u3067\u3057\u305f\u2026"}