{"url":"https://accelerate.hateblo.jp/entry/20090602/1243953342","width":"100%","provider_name":"Hatena Blog","published":"2009-06-02 23:35:42","author_url":"https://blog.hatena.ne.jp/verdana/","blog_title":"accelerate utilities","description":"vlookup\u95a2\u6570\u306f\u30a8\u30af\u30bb\u30eb\u306e\u30c7\u30fc\u30bf\u96c6\u8a08\u3084\u89e3\u6790\u3001\u4f1a\u8a08\u306a\u3069\u69d8\u3005\u306a\u7528\u9014\u3067\u5229\u7528\u3067\u304d\u308b\u512a\u308c\u305f\u95a2\u6570\u3002 vlookup\u95a2\u6570\u306f\u8868\u306b\u5225\u306e\u8868\u3092\u53c2\u7167\u3057\u3066\u30c7\u30fc\u30bf\u3092\u5f53\u3066\u8fbc\u3081\u308b\u3053\u3068\u304c\u5bb9\u6613\u3002 \u305f\u3068\u3048\u3070\u4e0b\u306e\u3088\u3046\u306a\u8868\u306b\u3001 \u4e0b\u306e\u300c\u5730\u65b9\u300d\u3068\u3044\u3046\u8981\u7d20\u3092\u52a0\u3048\u3066\u8868\u306b\u3057\u305f\u3044\u5834\u5408\u304c\u3042\u308b\u3002 \u3053\u3053\u3067\u7a7a\u767d\u306e\u300c\u5730\u65b9\u300d\u306e\u5217\u306bvlookup\u95a2\u6570\u3067\u7c21\u5358\u306b\u5f53\u3066\u306f\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002 \u3053\u306e\u3088\u3046\u306b\u3001F2\u306e\u30bb\u30eb\u306b\u300c=VLOOKUP(C2,$H$13:$I$17,2,FALSE)\u300d\u3068\u5165\u529b\u3059\u308b\u3053\u3068\u3067OK\u3002 \u7d50\u679c\u300c\u95a2\u6771\u300d\u3068\u5225\u306e\u8868\u3092\u53c2\u7167\u3057\u305f\u5024\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u3002 vlookup\u95a2\u6570\u3067\u306f\u3001 vlookup(\u691c\u7d22\u5024,\u7bc4\u56f2,\u5217\u756a\u53f7,\u691c\u7d22\u306e\u578b) \u3092\u5165\u529b\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u8a2d\u5b9a\u3067\u304d\u308b\u3002 \u2026","categories":["Excel"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Faccelerate.hateblo.jp%2Fentry%2F20090602%2F1243953342\" title=\"vlookup\u95a2\u6570 / \u30a8\u30af\u30bb\u30eb - accelerate utilities\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","height":"190","version":"1.0","provider_url":"https://hatena.blog","blog_url":"https://accelerate.hateblo.jp/","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/v/verdana/20090602/20090602230429.png","author_name":"verdana","title":"vlookup\u95a2\u6570 / \u30a8\u30af\u30bb\u30eb"}