{"id":3149,"date":"2021-05-28T22:23:25","date_gmt":"2021-05-28T17:53:25","guid":{"rendered":"https:\/\/officebaz.ir\/ex\/?p=3149"},"modified":"2024-05-07T19:50:02","modified_gmt":"2024-05-07T16:20:02","slug":"%d8%aa%d8%a7%d8%a8%d8%b9-vlookup","status":"publish","type":"post","link":"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-vlookup\/","title":{"rendered":"\u062a\u0627\u0628\u0639 VLOOKUP \u0627\u06a9\u0633\u0644"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"\u0646\u06a9\u0627\u062a-\u0648-\u0642\u0648\u0627\u0646\u06cc\u0646-\u062d\u0627\u06a9\u0645-\u0628\u0631-vlookup\">\u0646\u06a9\u0627\u062a \u0648 \u0642\u0648\u0627\u0646\u06cc\u0646 \u062d\u0627\u06a9\u0645 \u0628\u0631 \u062a\u0627\u0628\u0639 VLOOKUP \u0627\u06a9\u0633\u0644<\/h2>\n\n\n<ul>\n<li>\u0627\u06af\u0631 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0645\u06cc \u06af\u0631\u062f\u06cc\u062f \u0645\u062d\u062f\u0648\u062f\u0647 \u0645\u0648\u0631\u062f \u062c\u0633\u062a\u062c\u0648 \u060c \u0633\u062a\u0648\u0646 \u0627\u0648\u0644 \u0628\u0627\u06cc\u062f \u0634\u0627\u0645\u0644 \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0628\u0627\u0634\u062f.<\/li>\n<li>\u062a\u0627\u0628\u0639 <a href=\"https:\/\/exceljet.net\/\" target=\"_blank\" rel=\"noopener\">VLOOKUP<\/a> \u0628\u0647 \u0627\u0648\u0644\u06cc\u0646 \u0646\u062a\u06cc\u062c\u0647 \u0645\u0646\u0637\u0628\u0642 \u06a9\u0647 \u0628\u0631\u0633\u062f \u060c \u0645\u062a\u0648\u0642\u0641 \u0634\u062f\u0647 \u0648 \u062f\u0627\u062f\u0647 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0628\u0631 \u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f<\/li>\n<li>\u062a\u0627\u0628\u0639 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0642\u0628\u0644 \u0627\u0632 \u062e\u0648\u062f \u0631\u0627 \u0644\u0648\u06a9\u0627\u067e \u06a9\u0646\u062f .<\/li>\n<li>\u0627\u06af\u0631 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u0634\u0645\u0627 \u0622\u0632\u0627\u0631 \u062f\u0647\u0646\u062f\u0647 \u0627\u0633\u062a \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f <a href=\"https:\/\/officebaz.ir\/%d8%af%d8%a7%d9%86%d9%84%d9%88%d8%af-%d9%88-%d9%86%d8%b5%d8%a8-%d9%88-%d9%81%d8%b9%d8%a7%d9%84%d8%b3%d8%a7%d8%b2%db%8c-%d8%b5%d8%ad%db%8c%d8%ad-%d8%a2%d9%81%db%8c%d8%b3-2021\/\" target=\"_blank\" rel=\"noopener\" data-schema-attribute=\"\">\u0622\u0641\u06cc\u0633 2021<\/a> \u0646\u0635\u0628 \u06a9\u0631\u062f\u0647 \u0648 \u0627\u0632 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%da%a9%d8%a7%d9%85%d9%84-%d8%aa%d8%a7%d8%a8%d8%b9-xlookup-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-10-%d9%85%d8%ab%d8%a7%d9%84\/\" target=\"_blank\" rel=\"noopener\" data-schema-attribute=\"\">\u062a\u0627\u0628\u0639 XLOOKUP<\/a> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/li>\n<\/ul>\n\n\n<h2 class=\"wp-block-heading\">\u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP<\/h2>\n\n\n<p>\u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0645\u0634\u0627\u0628\u0647 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u0633\u062a\u0648\u0646 \u062f\u0648\u0645 \u0622\u0646 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0648 \u0633\u062a\u0648\u0646 \u0622\u062e\u0631 \u0622\u0646 \u0647\u0645 \u0645\u06cc\u0632\u0627\u0646 \u067e\u0627\u062f\u0627\u0634 \u0647\u0633\u062a \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u060c \u0645\u06cc\u0632\u0627\u0646 \u067e\u0627\u062f\u0627\u0634 \u0645\u0631\u0628\u0648\u0637\u0647 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f .<\/p>\n<p>\u0646\u06a9\u062a\u0647 \u0645\u0647\u0645\u06cc \u06a9\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u062f\u0648\u0645 \u0628\u0627\u06cc\u062f \u0627\u0632 \u062c\u0627\u06cc\u06cc \u0634\u0631\u0648\u0639 \u0634\u0648\u062f \u06a9\u0647 \u062c\u0633\u062a\u062c\u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u062f \u062f\u0631 \u0622\u0646 \u0633\u062a\u0648\u0646 \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f . \u06cc\u0639\u0646\u06cc \u0648\u0642\u062a\u06cc \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0647\u0633\u062a\u06cc\u0645 \u0628\u0627\u06cc\u062f \u0645\u062d\u062f\u0648\u062f\u0647 \u0645\u0648\u0631\u062f \u062c\u0633\u062a\u062c\u0648 \u062f\u0631 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u062f\u0648\u0645 \u0627\u0632 \u0645\u062d\u062f\u0648\u062f\u0647 C2 \u0634\u0631\u0648\u0639 \u0634\u0648\u062f \u0648 \u062a\u0627 \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0627\u062f\u0627\u0645\u0647 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u062f .<\/p>\n<p>\u0646\u06a9\u062a\u0647 \u0645\u0647\u0645 \u062f\u06cc\u06af\u0631 \u0627\u06cc\u0646\u0633\u062a \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0622\u062e\u0631 \u0631\u0627 \u0628\u0627 \u0627\u06cc\u0646\u06a9\u0647 \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u0647\u0633\u062a \u0639\u062f\u062f 0 \u06cc\u0627 FALSE \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u0645 \u062a\u0627 \u062f\u0642\u06cc\u0642\u0627 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0628\u06af\u0631\u062f\u062f.<\/p>\n<p><strong>\u062d\u0627\u0644\u0627 \u0686\u0646\u062f \u062d\u0627\u0644\u062a \u0628\u0647 \u0648\u062c\u0648\u062f \u0645\u06cc \u0622\u06cc\u062f :<\/strong><\/p>\n<ul>\n<li><strong>\u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f :<\/strong> \u0627\u0631\u0648\u0631 #N\/A \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u062f .<\/li>\n<li><strong>\u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0686\u0646\u062f \u0628\u0627\u0631 \u062a\u06a9\u0631\u0627\u0631 \u0634\u062f\u0647 \u0628\u0627\u0634\u062f :<\/strong> \u0627\u0648\u0644\u06cc\u0646 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0631\u0627 \u06a9\u0647 \u067e\u06cc\u062f\u0627 \u0645\u06cc \u06a9\u0646\u062f \u0645\u0644\u0627\u06a9 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0648 \u0628\u0642\u06cc\u0647 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0646\u0645\u06cc \u062f\u0647\u062f.<\/li>\n<li><strong>\u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0628\u0627 \u0646\u0648\u0639 \u062c\u0633\u062a\u062c\u0648 \u0647\u0645\u062e\u0648\u0627\u0646\u06cc \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f :<\/strong> \u0627\u06af\u0631 \u062f\u0631 \u0633\u062a\u0648\u0646 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0639\u062f\u062f\u06cc \u0628\u0627\u0634\u062f \u06a9\u0647 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u062a\u0646\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0628\u0627\u0634\u062f \u0648 \u062f\u0631 \u0632\u0645\u0627\u0646 \u062c\u0633\u062a\u062c\u0648 \u062e\u0627\u0635\u06cc\u062a \u0633\u0644\u0648\u0644 \u0639\u062f\u062f\u06cc \u0648\u0627\u0631\u062f \u0634\u0648\u062f \u060c \u0646\u062a\u06cc\u062c\u0647 \u0628\u0627\u0632\u0647\u0645 #N\/A \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f .<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=VLOOKUP(I2,$C$2:$F$8,4,0)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1276\" height=\"514\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup3-1.png\" alt=\"\u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0627\u06a9\u0633\u0644\" class=\"wp-image-9196\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup3-1.png 1276w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup3-1-300x121.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup3-1-1024x412.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup3-1-768x309.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup3-1-600x242.png 600w\" sizes=\"(max-width: 1276px) 100vw, 1276px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0628\u0627 \u062f\u0648 \u0634\u0631\u0637<\/h2>\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0645\u0634\u0627\u0628\u0647 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u0634\u0627\u0645\u0644 \u06a9\u062f \u0648 \u0633\u0631\u06cc\u0627\u0644 \u0648 \u0628\u0642\u06cc\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0633\u062a \u0648 \u062f\u0631 \u06a9\u062f\u0647\u0627 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u062a\u06a9\u0631\u0627\u0631 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0633\u0631\u06cc\u0627\u0644\u0647\u0627 \u06cc\u0648\u0646\u06cc\u06a9 \u0647\u0633\u062a\u0646\u062f \u060c \u062d\u0627\u0644 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u062f \u0648 \u0633\u0631\u06cc\u0627\u0644 \u060c \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062a\u0646\u0627\u0638\u0631 \u0627\u06cc\u0646 \u062f\u0648 \u0627\u0646\u062a\u062e\u0627\u0628 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f .<\/p>\n<p>\u0627\u0648\u0644\u06cc\u0646 \u0631\u0627\u0647\u06cc \u06a9\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u06a9\u0645\u06a9\u06cc \u0642\u0628\u0644 \u0627\u0632 \u0633\u062a\u0648\u0646 \u06a9\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u0648 \u062f\u0631 \u0622\u0646 \u060c \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0648 \u0633\u0631\u06cc\u0627\u0644 \u0631\u0627 \u0628\u0627 \u0647\u0645 \u062a\u062c\u0645\u06cc\u0639 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-textjoin\/\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 TEXTJON<\/a> \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 .\u00a0<\/p>\n<p>\u0633\u067e\u0633 \u062f\u0631 \u0642\u0633\u0645\u062a \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=VLOOKUP(J2&amp;J3,$B$2:$G$8,6,0)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"390\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup4-1024x390.png\" alt=\"\u062a\u0627\u0628\u0639 VLOOKUP \u0628\u0627 \u062f\u0648 \u0634\u0631\u0637\" class=\"wp-image-9197\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup4-1024x390.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup4-300x114.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup4-768x293.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup4-600x229.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup4.png 1361w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<p>\u062d\u0627\u0644\u0627 \u0627\u06af\u0631 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0627\u06cc\u062c\u0627\u062f \u0633\u062a\u0648\u0646 \u06a9\u0645\u06a9\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u0686\u0647 \u06a9\u0627\u0631\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 \u061f\u00a0\u062f\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u062a\u0631\u06cc\u06a9\u06cc\u0628 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-index-%d8%a7%da%a9%d8%b3%d9%84\/\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 INDEX<\/a> \u0648 \u062a\u0627\u0628\u0639 MATCH \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 \u060c \u0628\u0647 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u06a9\u0647 \u062f\u0631 \u062a\u0627\u0628\u0639 MATCH \u062f\u0648 \u0634\u0631\u0637 \u0628\u0631\u0627\u0628\u0631\u06cc \u06a9\u062f \u0648 \u0633\u0631\u06cc\u0627\u0644 \u0631\u0627 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u0645 \u062a\u0627 \u0634\u0645\u0627\u0631\u0647 \u0631\u062f\u06cc\u0641 \u0635\u062d\u06cc\u062d \u0631\u0627 \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u0645.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=INDEX(C2:G8, MATCH(1, (C2:C8=J2)*(D2:D8=J3), 0),5)<\/pre><\/div>\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u062d\u062a\u0645\u0627 \u0628\u0627 \u062a\u0627\u0628\u0639 VLOOKUP \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 \u0648 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0633\u062a\u0648\u0646 \u06a9\u0645\u06a9\u06cc \u0647\u0645 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 . \u062f\u0631 \u0627\u06cc\u0646\u0635\u0648\u0631\u062a \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u062a\u0648\u0627\u0628\u0639 \u062f\u06cc\u06af\u0631\u00a0 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n<p><strong>\u062a\u0631\u06cc\u06a9\u0628 \u0628\u0627 \u062a\u0627\u0628\u0639 CHOOSE :<\/strong><\/p>\n<p>\u062f\u0631\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0647 \u062c\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0633\u062a\u0648\u0646 \u06a9\u0645\u06a9\u06cc \u0631\u0627 \u0628\u0647 \u062e\u0648\u062f \u0627\u06a9\u0633\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645 \u0628\u0647 \u0635\u0648\u0631\u062a \u0641\u0631\u0645\u0648\u0644 \u062f\u0627\u062e\u0644 \u062a\u0648\u0627\u0628\u0639 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u062f\u0631 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u062f\u0648\u0645 \u0627\u0632 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-choose\/\" target=\"_blank\" rel=\"noopener\" data-wplink-edit=\"true\">\u062a\u0627\u0628\u0639 CHOOSE<\/a> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0648 \u0633\u062a\u0648\u0646 \u0645\u062c\u0632\u0627 \u0634\u0627\u0645\u0644 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u062f \u0648 \u0633\u0631\u06cc\u0627\u0644 \u0648 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u067e\u0627\u062f\u0627\u0634 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u0648 \u0633\u067e\u0633 \u062a\u0627\u0628\u0639 VLOOKUP \u0631\u0627 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=VLOOKUP(H2&amp;H3,CHOOSE({1,2},B3:B8&amp;C3:C8,E3:E8),2,0)<\/pre><\/div>\n\n\n<p><strong>\u062a\u0631\u06cc\u06a9\u0628 \u0628\u0627 \u062a\u0627\u0628\u0639 IF :<\/strong><\/p>\n<p>\u062f\u0631\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0647\u0645 \u0627\u0628\u062a\u062f\u0627 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0645\u06cc \u06af\u0631\u062f\u06cc\u0645 \u0648 \u0633\u067e\u0633 \u062f\u0631 \u0646\u062a\u0627\u06cc\u062c \u0628\u0627 \u06a9\u0645\u06a9 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-if-%d9%88-%d9%86%d8%ad%d9%87-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-%d8%a2%d9%86-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-%d9%85%d8%ab%d8%a7%d9%84%d9%87\/\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 IF<\/a> \u0622\u0646\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0633\u0631\u06cc\u0627\u0644\u0634\u0627\u0646 \u0645\u0633\u0627\u0648\u06cc \u0628\u0627 \u0633\u0631\u06cc\u0627\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0645\u0627 \u0647\u0633\u062a \u0631\u0627 \u0645\u062d\u062f\u0648\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u0628\u0647 \u0646\u062a\u06cc\u062c\u0647 \u062f\u0644\u062e\u0648\u0627\u0647 \u0645\u06cc \u0631\u0633\u06cc\u0645.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=IFERROR(VLOOKUP(H3,IF(H2=B3:B8,C3:E8,&quot;&quot;),3,0),&quot;&quot;)<\/pre><\/div>\n\n\n<p><strong>\u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u062a\u0627\u0628\u0639 LEN :<\/strong><\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0627\u0628\u062a\u062f\u0627 \u06a9\u062f \u0648 \u0633\u0631\u06cc\u0627\u0644 \u0631\u0627 \u0628\u0627 \u0647\u0645 \u0627\u062f\u063a\u0627\u0645 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u0633\u067e\u0633 \u0633\u062a\u0648\u0646 \u06a9\u062f \u0631\u0627 \u0628\u0627 \u0628\u0642\u06cc\u0647 \u0633\u062a\u0648\u0646\u0647\u0627 \u0627\u062f\u063a\u0627\u0645 \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0627\u06cc \u06a9\u0647 \u062d\u0627\u0635\u0644 \u0645\u06cc \u0634\u0648\u062f \u060c \u06a9\u062f \u0631\u0627 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0646\u062a\u06cc\u062c\u0647 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u06a9\u0627\u0641\u06cc\u0633\u062a \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 LEN \u0622\u0646 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\u00a0 \u0648 \u0641\u0642\u0637 \u0645\u0642\u062f\u0627\u0631 \u067e\u0627\u062f\u0627\u0634 \u0628\u0627\u0642\u06cc \u0628\u0645\u0627\u0646\u062f.<\/p>\n<p>\u0627\u0644\u0628\u062a\u0647 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0627\u06cc\u0646\u06a9\u0647 \u0646\u062a\u06cc\u062c\u0647 \u0645\u062a\u0646\u06cc \u0645\u06cc \u0628\u0627\u0634\u062f \u0647\u0645\u0647 \u062c\u0627 \u0635\u0627\u062f\u0642 \u0646\u06cc\u0633\u062a \u0648 \u0628\u0627\u06cc\u062f \u0628\u0627 \u0627\u062d\u062a\u06cc\u0627\u0637 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f \u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0628\u0627 \u062a\u0627\u0628\u0639 NUMBER \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062a\u0628\u062f\u06cc\u0644 \u0628\u0647 \u0639\u062f\u062f \u06a9\u0631\u062f.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=RIGHT(VLOOKUP(K3&amp;K4,D3:D9&amp;E3:H9,4,0),LEN(VLOOKUP(K3&amp;K4,D3:D9&amp;E3:H9,4,0))-LEN(K3))<\/pre><\/div>\n\n\n<p><strong>\u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u062a\u0627\u0628\u0639 INT :<\/strong><\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0627\u0628\u062a\u062f\u0627 \u06a9\u062f \u0648 \u0633\u0631\u06cc\u0627\u0644 \u0631\u0627 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u06cc\u06a9 \u0646\u0642\u0637\u0647 \u0628\u0627 \u0647\u0645 \u0627\u062f\u063a\u0627\u0645 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u0633\u067e\u0633 \u0633\u062a\u0648\u0646 \u06a9\u062f \u0631\u0627 \u0628\u0627 \u0628\u0642\u06cc\u0647 \u0633\u062a\u0648\u0646\u0647\u0627 \u0627\u062f\u063a\u0627\u0645 \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0627\u06cc \u06a9\u0647 \u062d\u0627\u0635\u0644 \u0645\u06cc \u0634\u0648\u062f \u060c \u06a9\u062f \u0631\u0627 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u06cc\u06a9 \u0646\u0642\u0637\u0647 \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u06a9\u0627\u0641\u06cc\u0633\u062a \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 INT \u0645\u0642\u062f\u0627\u0631 \u067e\u0627\u062f\u0627\u0634 \u0628\u0627\u0642\u06cc \u0628\u0645\u0627\u0646\u062f.<\/p>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0647\u0645 \u0632\u0645\u0627\u0646\u06cc \u067e\u0627\u0633\u062e\u06af\u0648 \u0627\u0633\u062a \u06a9\u0647 \u0646\u062a\u06cc\u062c\u0647 \u0645\u0627 \u0639\u062f\u062f\u06cc \u0628\u0627\u0634\u062f \u0648 \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0634\u0648\u062f \u0639\u062f\u062f\u06cc \u0628\u0627\u0634\u062f.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=INT(VLOOKUP(H2&amp;&quot;.&quot;&amp;H3,B3:E8&amp;&quot;.&quot;&amp;C3:C8,4,0))<\/pre><\/div>\n\n\n<p><strong>\u0628\u062f\u0648\u0646 \u062a\u0627\u0628\u0639 VLOOKUP \u0648 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SUM :<\/strong><\/p>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0647\u0645 \u0633\u0627\u062f\u0647 \u0648 \u0628\u0633\u06cc\u0627\u0631 \u062c\u0630\u0627\u0628 \u0627\u0633\u062a \u0648 \u0628\u0627\u0632\u0647\u0645 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0634\u0648\u062f \u060c \u0639\u062f\u062f\u06cc \u0628\u0627\u0634\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUM((E3:E8)*(C3:C8=H3)*(B3:B8=H2))<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u0646\u0645\u0627\u06cc\u0634 \u0646\u062a\u0627\u06cc\u062c \u062a\u06a9\u0631\u0627\u0631\u06cc <\/h2>\n\n\n<p>\u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0642\u0628\u0644\u06cc \u0628\u0647 \u06af\u0648\u0646\u0647 \u0627\u06cc \u0647\u0633\u062a \u06a9\u0647 \u0628\u0631\u062e\u06cc \u0627\u0632 \u06a9\u062f\u0647\u0627 \u0686\u0646\u062f \u0628\u0627\u0631 \u062a\u06a9\u0631\u0627\u0631 \u0634\u062f\u0647 \u0627\u0646\u062f \u0648 \u0628\u0627 VLOOKUP \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u062a\u0645\u0627\u0645 \u06a9\u062f\u0647\u0627\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u06cc\u0645 .<\/p>\n<p>\u0627\u0644\u0628\u062a\u0647 \u06a9\u0647 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u0627 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <strong><a href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-filter-%d8%a8%d8%a7-%d9%85%d8%ab%d8%a7%d9%84%d9%87%d8%a7%db%8c-%d9%85%d8%ae%d8%aa%d9%84%d9%81\/\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 FILTER<\/a><\/strong> \u0645\u06cc \u0628\u0627\u0634\u062f \u0648\u0644\u06cc \u0627\u06af\u0631 \u0622\u0641\u06cc\u0633 2021 \u0646\u062f\u0627\u0634\u062a\u06cc\u062f \u0648 \u0645\u062c\u0628\u0648\u0631 \u0628\u0648\u062f\u06cc\u062f \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0631\u0648\u0634 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f . \u06a9\u0647 \u0628\u0627\u0632\u0647\u0645 \u062a\u0631\u06a9\u06cc\u06cc\u0628\u06cc \u0627\u0632 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-index-%d8%a7%da%a9%d8%b3%d9%84\/\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 INDEX<\/a> \u0648 \u0633\u0627\u06cc\u0631 \u062a\u0648\u0627\u0628\u0639 \u0645\u06cc \u0628\u0627\u0634\u062f.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=IFERROR(INDEX($B$3:$F$8,SMALL(IF($I$2=$B$3:$B$8,ROW($B$3:$B$8)-2,&quot;&quot;),ROW()-1),3),&quot;&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"382\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup5-1024x382.png\" alt=\"\u062a\u0627\u0628\u0639 VLOOKUP \u0648 \u0646\u062a\u0627\u06cc\u062c \u062a\u06a9\u0631\u0627\u0631\u06cc\" class=\"wp-image-9200\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup5-1024x382.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup5-300x112.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup5-768x286.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup5-600x224.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup5.png 1362w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 VLOOKUP \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0633\u062a\u0648\u0646 \u0642\u0628\u0644\u06cc<\/h2>\n\n\n<p>\u06cc\u06a9\u06cc \u0627\u0632 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a\u0647\u0627\u06cc \u0648\u06cc\u0644\u0648\u06a9\u0627\u067e \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0631\u0648 \u0628\u0647 \u062c\u0644\u0648 \u062d\u0631\u06a9\u062a \u0645\u06cc\u06a9\u0646\u062f \u060c \u06cc\u0639\u0646\u06cc \u062f\u0631 \u0633\u062a\u0648\u0646 \u0627\u0648\u0644 \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f \u062f\u0627\u062f\u0647\u0627\u06cc \u0645\u062a\u0646\u0627\u0638\u0631 \u0628\u0639\u062f\u06cc \u0627\u0632 \u0622\u0646 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 \u0634\u0645\u0627\u0631\u0647 \u0633\u062a\u0648\u0646 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f .\u00a0<\/p>\n<p>\u062d\u0627\u0644 \u062f\u0631 \u0645\u062b\u0627\u0644 \u0632\u06cc\u0631 \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u060c \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f \u0686\u06a9\u0627\u0631 \u0628\u0627\u06cc\u062f \u0628\u06a9\u0646\u06cc\u0645 \u061f\u00a0<\/p>\n<p>\u062e\u0628 \u062e\u06cc\u0644\u06cc \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc \u062d\u0644 \u0645\u0633\u0627\u062f\u0644 \u0627\u06cc\u0646 \u0686\u0646\u06cc\u0646\u06cc \u0627\u0632 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%da%a9%d8%a7%d9%85%d9%84-%d8%aa%d8%a7%d8%a8%d8%b9-xlookup-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-10-%d9%85%d8%ab%d8%a7%d9%84\/\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 XLOOKUP<\/a> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 \u0648 \u0627\u06af\u0631 \u062a\u0648\u0627\u0628\u0639 <a href=\"https:\/\/excelpack.ir\/wich-version-of-office-365\/\" target=\"_blank\" rel=\"noopener\">\u0622\u0641\u06cc\u0633 2021<\/a> \u0631\u0627 \u0646\u062f\u0627\u0634\u062a\u06cc\u0645 \u0627\u0632 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-index-%d8%a7%da%a9%d8%b3%d9%84\/\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 INDEX<\/a> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 . \u0648\u0644\u06cc \u0627\u06af\u0631 \u0627\u0635\u0631\u0627\u0631 \u0628\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 VLOOKUP \u062f\u0627\u0634\u062a\u06cc\u062f \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0632 \u0622\u0646 \u0628\u0647\u0631\u0647 \u0628\u0628\u0631\u06cc\u062f.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=VLOOKUP(I2,CHOOSE({1,2},C3:C8,B3:B8),2,0)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"417\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup6-1024x417.png\" alt=\"\u062a\u0627\u0628\u0639 VLOOKUP \u0648 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0642\u0628\u0644\u06cc\" class=\"wp-image-9202\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup6-1024x417.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup6-300x122.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup6-768x313.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup6-600x244.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup6.png 1295w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0627\u0647\u0645\u06cc\u062a \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0622\u062e\u0631 VLOOKUP \u0648 \u0646\u0645\u0627\u06cc\u0634 \u0646\u062a\u06cc\u062c\u0647 \u062a\u0642\u0631\u06cc\u0628\u06cc<\/h2>\n\n\n<p>\u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0645\u0634\u0627\u0628\u0647 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0645\u0642\u062f\u0627\u0631 \u067e\u0627\u062f\u0627\u0634 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0641\u0631\u0648\u0634 \u062a\u0639\u06cc\u06cc\u0646 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0628\u0647 \u0627\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628 \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u0647 \u0627\u06cc \u0627\u0632 \u0641\u0631\u0648\u0634 \u060c \u0645\u06cc\u0632\u0627\u0646 \u067e\u0627\u062f\u0627\u0634 \u062a\u0639\u06cc\u06cc\u0646 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0627\u062d\u062a\u0645\u0627\u0644 \u0627\u06cc\u0646\u06a9\u0647 \u062f\u0642\u06cc\u0642\u0627 \u0645\u0634\u0627\u0628\u0647 \u0645\u06cc\u0632\u0627\u0646 \u0641\u0631\u0648\u0634 \u062f\u0631 \u0644\u06cc\u0633\u062a \u0646\u0628\u0627\u0634\u062f \u060c \u0628\u0633\u06cc\u0627\u0631 \u0632\u06cc\u0627\u062f \u0627\u0633\u062a \u0648 \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062f\u0644\u06cc\u0644 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0622\u062e\u0631 VLOOKUP \u0631\u0627 \u0639\u062f\u062f 1 \u06cc\u0627 TRUE \u0648\u0627\u0631\u062f \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 \u062f\u0642\u06cc\u0642 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u0646\u06a9\u0631\u062f \u060c \u0645\u0642\u062f\u0627\u0631 \u0645\u062a\u0646\u0627\u0638\u0631 \u0628\u0627 \u0627\u0648\u0644\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0628\u0632\u0631\u06af\u062a\u0631 \u0646\u0632\u062f\u06cc\u06a9 \u0628\u0647 \u0645\u0642\u062f\u0627\u0631 \u062c\u0633\u062a\u062c\u0648 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=VLOOKUP(C3,$F$3:$G$7,2,1)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"418\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup7-1024x418.png\" alt=\"\" class=\"wp-image-9205\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup7-1024x418.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup7-300x123.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup7-768x314.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup7-600x245.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/vlookup7.png 1239w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<p>\u0627\u06af\u0631 \u0645\u062b\u0627\u0644 \u0648 \u06cc\u0627 \u0634\u06cc\u0648\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0627\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0645\u06cc \u0634\u0646\u0627\u0633\u06cc\u062f \u062d\u062a\u0645\u0627 \u062f\u0631 \u0642\u0633\u0645\u062a \u0646\u0638\u0631\u0627\u062a \u0639\u0646\u0648\u0627\u0646 \u0628\u0641\u0631\u0645\u0627\u0626\u06cc\u062f \u062a\u0627 \u0645\u0637\u0644\u0628 \u0631\u0627 \u0622\u067e\u062f\u06cc\u062a \u06a9\u0646\u06cc\u0645.<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100\"><a class=\"wp-block-button__link has-light-green-cyan-color has-text-color has-background has-link-color wp-element-button\" href=\"https:\/\/www.dl.officebaz.ir\/free\/PDF\/VLOOKUP.pdf\" style=\"border-radius:10px;background-color:#0c6343\">\u062f\u0627\u0646\u0644\u0648\u062f \u0641\u0627\u06cc\u0644 PDF \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647<\/a><\/div>\n<\/div>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;3149&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;84&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.2&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;4&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.2\\\/5 - (84 \u0627\u0645\u062a\u06cc\u0627\u0632)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\u062a\u0627\u0628\u0639 VLOOKUP \u0627\u06a9\u0633\u0644&quot;,&quot;width&quot;:&quot;115.6&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 115.6px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.2\/5 - (84 \u0627\u0645\u062a\u06cc\u0627\u0632)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0646\u06a9\u0627\u062a \u0648 \u0642\u0648\u0627\u0646\u06cc\u0646 \u062d\u0627\u06a9\u0645 \u0628\u0631 \u062a\u0627\u0628\u0639 VLOOKUP \u0627\u06a9\u0633\u0644 \u0627\u06af\u0631 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0645\u06cc \u06af\u0631\u062f\u06cc\u062f \u0645\u062d\u062f\u0648\u062f\u0647 \u0645\u0648\u0631\u062f \u062c\u0633\u062a\u062c\u0648 \u060c \u0633\u062a\u0648\u0646 \u0627\u0648\u0644 \u0628\u0627\u06cc\u062f \u0634\u0627\u0645\u0644 \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0628\u0627\u0634\u062f. \u062a\u0627\u0628\u0639 VLOOKUP \u0628\u0647 \u0627\u0648\u0644\u06cc\u0646 \u0646\u062a\u06cc\u062c\u0647 \u0645\u0646\u0637\u0628\u0642 \u06a9\u0647 \u0628\u0631\u0633\u062f \u060c \u0645\u062a\u0648\u0642\u0641 \u0634\u062f\u0647 \u0648 \u062f\u0627\u062f\u0647 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0628\u0631 \u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f \u062a\u0627\u0628\u0639 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0642\u0628\u0644 \u0627\u0632 \u062e\u0648\u062f \u0631\u0627 \u0644\u0648\u06a9\u0627\u067e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8527,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":""},"categories":[33],"tags":[116],"class_list":["post-3149","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-function","tag-vlookup"],"acf":[],"author_meta":{"display_name":"\u0646\u0627\u062f\u0631 \u0628\u062d\u0631\u06cc","author_link":"https:\/\/officebaz.ir\/ex\/author\/administrator\/"},"featured_img":"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2-300x169.jpg","uagb_featured_image_src":{"full":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2.jpg",1280,720,false],"thumbnail":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2-150x150.jpg",150,150,true],"medium":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2-300x169.jpg",300,169,true],"medium_large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2-768x432.jpg",768,432,true],"large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2-1024x576.jpg",800,450,true],"1536x1536":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2.jpg",1280,720,false],"2048x2048":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2.jpg",1280,720,false],"gform-image-choice-sm":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2.jpg",300,169,false],"gform-image-choice-md":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2.jpg",400,225,false],"gform-image-choice-lg":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/VLOOKUP2-2.jpg",600,338,false]},"uagb_author_info":{"display_name":"\u0646\u0627\u062f\u0631 \u0628\u062d\u0631\u06cc","author_link":"https:\/\/officebaz.ir\/ex\/author\/administrator\/"},"uagb_comment_info":29,"uagb_excerpt":"\u0646\u06a9\u0627\u062a \u0648 \u0642\u0648\u0627\u0646\u06cc\u0646 \u062d\u0627\u06a9\u0645 \u0628\u0631 \u062a\u0627\u0628\u0639 VLOOKUP \u0627\u06a9\u0633\u0644 \u0627\u06af\u0631 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0645\u06cc \u06af\u0631\u062f\u06cc\u062f \u0645\u062d\u062f\u0648\u062f\u0647 \u0645\u0648\u0631\u062f \u062c\u0633\u062a\u062c\u0648 \u060c \u0633\u062a\u0648\u0646 \u0627\u0648\u0644 \u0628\u0627\u06cc\u062f \u0634\u0627\u0645\u0644 \u06a9\u062f \u06a9\u0627\u0644\u0627 \u0628\u0627\u0634\u062f. \u062a\u0627\u0628\u0639 VLOOKUP \u0628\u0647 \u0627\u0648\u0644\u06cc\u0646 \u0646\u062a\u06cc\u062c\u0647 \u0645\u0646\u0637\u0628\u0642 \u06a9\u0647 \u0628\u0631\u0633\u062f \u060c \u0645\u062a\u0648\u0642\u0641 \u0634\u062f\u0647 \u0648 \u062f\u0627\u062f\u0647 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0628\u0631 \u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f \u062a\u0627\u0628\u0639 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0642\u0628\u0644 \u0627\u0632 \u062e\u0648\u062f \u0631\u0627 \u0644\u0648\u06a9\u0627\u067e&hellip;","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/function\/\" class=\"advgb-post-tax-term\">\u062a\u0648\u0627\u0628\u0639 \u0627\u06a9\u0633\u0644<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">\u062a\u0648\u0627\u0628\u0639 \u0627\u06a9\u0633\u0644<\/span>"]},"tags":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/function\/\" class=\"advgb-post-tax-term\">VLOOKUP<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">VLOOKUP<\/span>"]}},"comment_count":"29","relative_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 5 \u0633\u0627\u0644 \u067e\u06cc\u0634","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 2 \u0633\u0627\u0644 \u067e\u06cc\u0634"},"absolute_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 7 \u062e\u0631\u062f\u0627\u062f 1400","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 18 \u0627\u0631\u062f\u06cc\u0628\u0647\u0634\u062a 1403"},"absolute_dates_time":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 7 \u062e\u0631\u062f\u0627\u062f 1400 10:23 \u0628.\u0638","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 18 \u0627\u0631\u062f\u06cc\u0628\u0647\u0634\u062a 1403 7:50 \u0628.\u0638"},"featured_img_caption":"\u062a\u0627\u0628\u0639 VLOOKUP","series_order":"","_links":{"self":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/3149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/comments?post=3149"}],"version-history":[{"count":0,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/3149\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media\/8527"}],"wp:attachment":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media?parent=3149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/categories?post=3149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/tags?post=3149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}