{"id":2594,"date":"2024-09-08T18:06:28","date_gmt":"2024-09-08T11:06:28","guid":{"rendered":"https:\/\/teched.support\/?p=2594"},"modified":"2026-11-03T14:36:51","modified_gmt":"2026-11-03T14:36:51","slug":"vlookup-function","status":"publish","type":"post","link":"https:\/\/teched.digital\/kh\/vlookup-function\/","title":{"rendered":"\u1780\u17b6\u179a\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u1798\u17bb\u1781\u1784\u17b6\u179a VLOOKUP \u179a\u1794\u179f\u17cb Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u1782\u17c4\u179b\u1794\u17c6\u178e\u1784\u17d6 \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1796\u17b8\u178f\u17b6\u179a\u17b6\u1784\u178f\u1798\u17d2\u179b\u17c3\u1787\u17b6\u1780\u17cb\u179b\u17b6\u1780\u17cb<br>\u178f\u1798\u17d2\u179b\u17c3\u179a\u1780\u1783\u17be\u1789\u17d6 \u1787\u17b6\u178f\u1798\u17d2\u179b\u17c3\u178f\u17c2\u1798\u17b6\u1793\u1780\u17d2\u1793\u17bb\u1784\u178f\u17b6\u179a\u17b6\u1784 \u17a0\u17be\u1799\u1780\u17c6\u178e\u178f\u17cb\u178a\u17c4\u1799\u1787\u17bd\u179a\u1788<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u1791\u1798\u17d2\u179a\u1784\u17cb\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f \/ Syntax <\/p>\n\n\n\n<div class=\"language-excel\">\n  <code class=\"language-xls\"><span class=\"token operator\">=<\/span><a class=\"token function\" href=\"\/microsoft-office\/excel\/xlookup-function\/\">VLOOKUP<\/a><span class=\"token punctuation\">(<\/span>lookup_value<span class=\"token punctuation\">,<\/span>table_array<span class=\"token punctuation\">,<\/span>column_index_num<span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">[<\/span>range_lookup<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/code><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>lookup_value &#8211; \u1787\u17b6\u178f\u1798\u17d2\u179b\u17c3\u178a\u17c2\u179b\u17a2\u17d2\u1793\u1780\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u178a\u17be\u1798\u17d2\u1794\u17b8\u1780\u17c6\u178e\u178f\u17cb\u178f\u1798\u17d2\u179b\u17c3\u178a\u17c2\u179b\u1799\u17be\u1784\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780 \u17a0\u17be\u1799\u179c\u17b6\u179f\u17d2\u1790\u17b7\u178f\u1780\u17d2\u1793\u17bb\u1784\u17d4\u1787\u17bd\u179a\u1788\u1791\u17b8\u17e1 \u1793\u17c3\u178f\u1798\u17d2\u179b\u17c3\u178a\u17c2\u179b\u1794\u17b6\u1793\u1787\u17d2\u179a\u17be\u179f\u179a\u17be\u179f (\u178f\u17b6\u179a\u17b6\u1784\u178f\u1798\u17d2\u179b\u17c3)\u17d4<\/li>\n\n\n\n<li>table_array &#8211; \u1787\u17b6\u178f\u17b6\u179a\u17b6\u1784\u178f\u1798\u17d2\u179b\u17c3\u17d4<\/li>\n\n\n\n<li>column_index_num &#8211; \u1787\u17b6\u178f\u1798\u17d2\u179b\u17c3\u1787\u17bd\u179a\u1788\u178a\u17c2\u179b\u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780\u178f\u1798\u17d2\u179b\u17c3\u178a\u17c2\u179b\u1799\u17be\u1784\u1785\u1784\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u17d4<\/li>\n\n\n\n<li>rang_lookup &#8211; [\u1798\u17b7\u1793\u178a\u17b6\u1780\u17cb\u1780\u17cf\u1794\u17b6\u1793] True \u1798\u17b6\u1793\u1793\u17d0\u1799\u1790\u17b6\u200b \u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b\u200b\u200b (\u179b\u17c6\u1793\u17b6\u17c6\u178a\u17be\u1798)\u17d4\u200b False \u1798\u17b6\u1793\u1793\u17d0\u1799\u1790\u17b6 \u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u17c2\u178f\u1798\u17d2\u179b\u17c3\u178f\u17d2\u179a\u17bc\u179c\u1785\u17c6\u178f\u17c2\u1794\u17c9\u17bb\u178e\u17d2\u178e\u17c4\u17c7\u17d4<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide is-style-wide--1\"\/>\n\n\n\n<h2 id=\"h-\u179a\u1794-\u1794\u1794-\u179a-\u1794-\u179a-\u179f\" class=\"wp-block-heading\"><strong>\u179a\u1794\u17c0\u1794\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">VLOOKUP \u1782\u17ba\u1787\u17b6\u1798\u17bb\u1781\u1784\u17b6\u179a\u1796\u17c1\u1789\u1793\u17b7\u1799\u1798\u1794\u17c6\u1795\u17bb\u178f\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 Excel \u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u1780\u17b6\u179a\u179a\u1780\u1798\u17be\u179b\u1798\u17bc\u179b\u178a\u17d2\u178b\u17b6\u1793\u17d4 \u1793\u17c1\u17c7\u1782\u17ba\u178a\u17c4\u1799\u179f\u17b6\u179a\u178f\u17c2 VLOOKUP \u1798\u17b6\u1793\u1797\u17b6\u1796\u1784\u17b6\u1799\u179f\u17d2\u179a\u17bd\u179b\u1780\u17d2\u1793\u17bb\u1784\u1780\u17b6\u179a\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb \u1793\u17b7\u1784\u1798\u17b6\u1793\u1794\u17d2\u179a\u1799\u17c4\u1787\u1793\u17cd\u17d6 \u179c\u17b6\u179f\u17d2\u1780\u17c1\u1793\u178f\u17b6\u179a\u17b6\u1784 \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3 \u1793\u17b7\u1784\u1794\u1784\u17d2\u17a0\u17b6\u1789\u179b\u1791\u17d2\u1792\u1795\u179b\u1780\u17d2\u1793\u17bb\u1784\u1787\u17bd\u179a\u178a\u17c2\u179b\u178f\u17d2\u179a\u17bc\u179c\u1782\u17d2\u1793\u17b6\u17d4 \u178a\u17c4\u1799\u179f\u17b6\u179a\u178f\u17c2\u1794\u1789\u17d2\u17a0\u17b6\u1794\u17c2\u1794\u1793\u17c1\u17c7\u179b\u17c1\u1785\u17a1\u17be\u1784\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u17a7\u179f\u17d2\u179f\u17b6\u17a0\u1780\u1798\u17d2\u1798\u179f\u17d2\u1791\u17be\u179a\u178f\u17c2\u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb VLOOKUP \u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u17a2\u17b6\u1787\u17b8\u179c\u1780\u1798\u17d2\u1798\u1782\u17d2\u179a\u1794\u17cb\u1794\u17d2\u179a\u1797\u17c1\u1791\u17d4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u17a2\u178f\u17d2\u1790\u1794\u1791\u1793\u17c1\u17c7\u1796\u17b7\u1796\u178e\u17cc\u1793\u17b6\u17a2\u17c6\u1796\u17b8\u179a\u1794\u17c0\u1794\u1794\u17d2\u179a\u17be VLOOKUP \u1787\u17b6\u1797\u17b6\u179f\u17b6\u179f\u17b6\u1798\u1789\u17d2\u1789\u17d4 \u179c\u17b6\u178f\u17d2\u179a\u17bc\u179c\u1780\u17b6\u179a\u179c\u17b7\u1792\u17b8\u179f\u17b6\u179f\u17d2\u179a\u17d2\u178f\u1798\u17bd\u1799\u1787\u17c6\u17a0\u17b6\u1793\u1798\u17d2\u178f\u1784\u1798\u17bd\u1799\u17d7 \u178a\u17c4\u1799\u178a\u17c6\u1794\u17bc\u1784\u1796\u1793\u17d2\u1799\u179b\u17cb\u1796\u17b8\u179a\u1794\u17c0\u1794\u178a\u17c2\u179b VLOOKUP \u178a\u17c6\u178e\u17be\u179a\u1780\u17b6\u179a \u17a0\u17be\u1799\u1794\u1793\u17d2\u1791\u17b6\u1794\u17cb\u1798\u1780\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1796\u17b8\u179a\u1794\u17c0\u1794\u178a\u17c2\u179b VLOOKUP \u17a2\u17b6\u1785\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1794\u17d2\u179a\u17be\u178a\u17be\u1798\u17d2\u1794\u17b8\u178a\u17c4\u17c7\u179f\u17d2\u179a\u17b6\u1799\u1794\u1789\u17d2\u17a0\u17b6\u1795\u17d2\u179f\u17c1\u1784\u17d7\u17d4 <\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-fill\"><a class=\"wp-block-button__link has-base-2-color has-text-color has-background has-link-color wp-element-button\" href=\"\/wp-includes\/resources\/teched_vlookup_function.xlsx\" style=\"background-color:#00943d\" target=\"_blank\" rel=\"noreferrer noopener\">\u1791\u17b6\u1789\u1799\u1780\u200b Worksheet<\/a><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u1785\u17c6\u178e\u17b6\u17c6\u17d6 VLOOKUP \u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b \u178f\u17b6\u1798\u179b\u17c6\u1793\u17b6\u17c6\u178a\u17be\u1798\u17d4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">V \u1798\u1780\u1796\u17b8\u1796\u17b6\u1780\u17d2\u1799\u1796\u17c1\u1789 Vertical (\u1798\u17b6\u1793\u1793\u17d0\u1799\u1790\u17b6\u1794\u1789\u17d2\u1788)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u178a\u17bc\u1785\u1793\u17c1\u17c7\u17a0\u17be\u1799\u1791\u17be\u1794 \u1793\u17c5\u1796\u17c1\u179b\u1793\u17b7\u1799\u17b6\u1799\u178a\u179b\u17cb VLOOKUP \u1782\u17c1\u179f\u17c6\u178a\u17c5\u178a\u179b\u17cb\u1780\u17b6\u179a\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u178f\u17b6\u1798\u1787\u17bd\u179a\u1788\u17d4<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"\u1788\u17d2\u179c\u17c2\u1784\u1799\u179b\u17cb\u1796\u17b8\u1798\u17bb\u1781\u1784\u17b6\u179a Vlookup \u179b\u17be Excel \u1797\u17b6\u1782\u1791\u17b8\u17e1\/\u17e2\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/eW4b6hHgIBk?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\">\u1797\u17b6\u1782\u1791\u17b8\u17e1<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>VLOOKUP \u1782\u17ba\u1787\u17b6\u1798\u17bb\u1781\u1784\u17b6\u179a\u1796\u17c1\u1789\u1793\u17b7\u1799\u1798\u1794\u17c6\u1795\u17bb\u178f\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 Excel \u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u1780\u17b6\u179a\u179a\u1780\u1798\u17be\u179b\u1798\u17bc\u179b\u178a\u17d2\u178b\u17b6\u1793\u17d4 \u1793\u17c1\u17c7\u1782\u17ba\u178a\u17c4\u1799\u179f\u17b6\u179a\u178f\u17c2 VLOOKUP \u1798\u17b6\u1793\u1797\u17b6\u1796\u1784\u17b6\u1799\u179f\u17d2\u179a\u17bd\u179b\u1780\u17d2\u1793\u17bb\u1784\u1780\u17b6\u179a\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb \u1793\u17b7\u1784\u1798\u17b6\u1793\u1794\u17d2\u179a\u1799\u17c4\u1787\u1793\u17cd\u17d6 \u179c\u17b6\u179f\u17d2\u1780\u17c1\u1793\u178f\u17b6\u179a\u17b6\u1784 \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3 \u1793\u17b7\u1784\u1794\u1784\u17d2\u17a0\u17b6\u1789\u179b\u1791\u17d2\u1792\u1795\u179b\u1780\u17d2\u1793\u17bb\u1784\u1787\u17bd\u179a\u178a\u17c2\u179b\u178f\u17d2\u179a\u17bc\u179c\u1782\u17d2\u1793\u17b6\u17d4 \u178a\u17c4\u1799\u179f\u17b6\u179a\u178f\u17c2\u1794\u1789\u17d2\u17a0\u17b6\u1794\u17c2\u1794\u1793\u17c1\u17c7\u179b\u17c1\u1785\u17a1\u17be\u1784\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u17a7\u179f\u17d2\u179f\u17b6\u17a0\u1780\u1798\u17d2\u1798\u179f\u17d2\u1791\u17be\u179a\u178f\u17c2\u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb VLOOKUP \u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u17a2\u17b6\u1787\u17b8\u179c\u1780\u1798\u17d2\u1798\u1782\u17d2\u179a\u1794\u17cb\u1794\u17d2\u179a\u1797\u17c1\u1791\u17d4<\/p>\n","protected":false},"author":1,"featured_media":3749,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-2594","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/posts\/2594","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/comments?post=2594"}],"version-history":[{"count":1,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/posts\/2594\/revisions"}],"predecessor-version":[{"id":4404,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/posts\/2594\/revisions\/4404"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/media\/3749"}],"wp:attachment":[{"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/media?parent=2594"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/categories?post=2594"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/tags?post=2594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}