{"id":5070,"date":"2022-06-29T22:30:10","date_gmt":"2022-06-29T18:00:10","guid":{"rendered":"https:\/\/officebaz.ir\/ex\/?p=5070"},"modified":"2024-05-07T19:50:39","modified_gmt":"2024-05-07T16:20:39","slug":"vlookup-%d8%a8%d8%a7-2-%d8%b4%d8%b1%d8%b7","status":"publish","type":"post","link":"https:\/\/officebaz.ir\/ex\/vlookup-%d8%a8%d8%a7-2-%d8%b4%d8%b1%d8%b7\/","title":{"rendered":"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637 \u062f\u0631 \u0627\u06a9\u0633\u0644"},"content":{"rendered":"<p>VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637 \u0648 \u0631\u0648\u0634\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627\u06cc\u06af\u0627\u0646 \u0628\u0647 \u0622\u0646\u0647\u0627 \u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u06cc\u0645 \u0634\u0645\u0627 \u0631\u0627 \u06a9\u0645\u06a9 \u0645\u06cc\u06a9\u0646\u062f \u062a\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0647\u062a\u0631\u06cc \u0627\u0632 \u0627\u06a9\u0633\u0644 \u062f\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0634\u0627\u0628\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u060c \u0627\u0644\u0628\u062a\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 3 \u0631\u0648\u0634 \u0645\u062e\u062a\u0644\u0641 \u0645\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645 \u06a9\u0647 \u0647\u0631 \u0633\u0647 \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 \u0645\u06cc \u06a9\u0646\u062f \u062c\u0633\u062a\u062c\u0648 \u0631\u0627 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0628\u0627 \u062f\u0648 \u0634\u0631\u0637 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f.<\/p>\n\n\n<h2 class=\"wp-block-heading\" id=\"-2--931579ba-6014-4228-8394-45bd1ac35ee9\">\u0631\u0648\u0634\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637<\/h2>\n\n\n<p>\u0628\u0631\u0627\u06cc \u0631\u0633\u06cc\u062f\u0646 \u0628\u0647 \u0647\u062f\u0641 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0627 2 \u0634\u0631\u0637 \u0631\u0648\u0634\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u060c \u06cc\u06a9 \u0631\u0648\u0634 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0645\u06cc \u0628\u0627\u0634\u062f \u0648 \u0631\u0648\u0634 \u062f\u06cc\u06af\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 INDEX \u0645\u06cc \u0628\u0627\u0634\u062f \u0648 \u0631\u0648\u0634 \u0622\u062e\u0631 \u0647\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 INDIRECT \u0648 \u0645\u062d\u062f\u0648\u062f\u0647 \u0646\u0627\u0645\u0647\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0645\u06cc \u0628\u0627\u0634\u062f.<\/p>\n<p>&nbsp;<\/p>\n\n\n<h4 class=\"wp-block-heading\" id=\"-vlookup-f263e99c-1e73-4399-845a-2585908b9068\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 <a href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-vlookup\/\" data-type=\"post\" data-id=\"3149\">VLOOKUP<\/a><\/h4>\n\n\n<p>\u0627\u0644\u0628\u062a\u0647 \u062f\u0631 <a href=\"https:\/\/exceljet.net\/formula\/vlookup-with-multiple-criteria\" target=\"_blank\" rel=\"noopener\">\u0627\u06cc\u0646 \u0631\u0648\u0634<\/a> \u0628\u0627\u06cc\u062f \u0627\u0632 \u062a\u0627\u0628\u0639 MATCH \u0647\u0645 \u06a9\u0645\u06a9 \u0628\u06af\u06cc\u0631\u06cc\u0645 \u062a\u0627 \u0634\u0645\u0627\u0631\u0647 \u0633\u062a\u0648\u0646 \u0631\u0627 \u062f\u0627\u06cc\u0646\u0627\u0645\u06cc\u06a9 \u0648 \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 \u0645\u0642\u062f\u0627\u0631 \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u062f\u0647 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u06cc\u0645 .<\/p>\n<p>\u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0645\u062d\u062f\u0648\u062f\u0647 \u062f\u0627\u062f\u0647 \u0645\u0627 \u0634\u0628\u06cc\u0647 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f .<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"344\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/5858-1024x344.png\" alt=\"VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637\" class=\"wp-image-5071\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/5858-1024x344.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/5858-300x101.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/5858-768x258.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/5858-1536x516.png 1536w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/5858-600x201.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/5858.png 1751w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637<\/figcaption><\/figure>\n\n\n<p>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u062a\u0635\u0648\u06cc\u0631 \u0628\u0627\u0644\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0631\u0648\u0634 \u0627\u0648\u0644 \u06a9\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 VLOOKUP \u0627\u0633\u062a \u0634\u0631\u0637 \u0627\u0648\u0644 \u062f\u0631 \u0633\u0644\u0648\u0644 C9 \u0648 \u0634\u0631\u0637 \u062f\u0648\u0645 \u062f\u0631 D8 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 . \u0628\u0631\u0627\u06cc \u062d\u0635\u0648\u0644 \u0646\u062a\u06cc\u062c\u0647 \u06a9\u0627\u0641\u06cc\u0633\u062a \u062f\u0631 \u0633\u0644\u0648\u0644 D9 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0646\u0648\u06cc\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;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=VLOOKUP(C9,A1:M6,MATCH(D8,A1:M1,0),FALSE)<\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"-vlookup-f263e99c-1e73-4399-845a-2585908b9068\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 INDEX \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 MATCH<\/h4>\n\n\n<p>\u0628\u0631\u0627\u06cc VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637 \u0631\u0648\u0634 \u062f\u06cc\u06af\u0631\u06cc \u0647\u0645 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0647\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 INDEX \u0628\u0647 \u06a9\u0645\u06a9 \u062a\u0627\u0628\u0639 MATCH \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0646\u06cc\u0632 \u0627\u06af\u0631 \u062a\u0635\u0648\u06cc\u0631 \u0628\u0627\u0644\u0627 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u0645 \u0628\u0627\u06cc\u062f \u062f\u0631 H9 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0646\u0648\u06cc\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;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=INDEX(B2:M6,MATCH(G9,A2:A6,0),MATCH(H8,B1:M1,0))<\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"-vlookup-f263e99c-1e73-4399-845a-2585908b9068\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 INDIRECT \u0648 \u0645\u062d\u062f\u0648\u062f\u0647 \u0646\u0627\u0645\u0647\u0627<\/h4>\n\n\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 \u06a9\u0645\u06cc \u0645\u062a\u0641\u0627\u0648\u062a \u0628\u0648\u062f\u0647 \u0648 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u062f\u0627\u062e\u0644\u06cc \u0627\u06a9\u0633\u0644 \u06a9\u0647 \u0647\u0645\u0627\u0646 \u0646\u0627\u0645\u06af\u0630\u0627\u0631\u06cc \u0645\u062d\u062f\u0648\u062f\u0647 \u0647\u0627 \u0645\u06cc \u0628\u0627\u0634\u062f \u0628\u0647\u0631\u0647 \u0628\u06af\u06cc\u0631\u06cc\u0645 \u0648 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631 \u0627\u06af\u0631 \u0647\u0645\u0627\u0646 \u062a\u0635\u0648\u06cc\u0631 \u0628\u0627\u0644\u0627 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u0645 \u060c \u0628\u0627\u06cc\u062f \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u0645 .<\/p>\n<ol>\n<li>\u0645\u062d\u062f\u0648\u062f\u0647 A1:M6 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc\u06a9\u0646\u06cc\u0645 .<\/li>\n<li>\u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628\u06cc Alt + Ctrl + F3 \u0631\u0627 \u0645\u06cc \u0632\u0646\u06cc\u0645 .<\/li>\n<li>\u062f\u0631 \u067e\u0646\u062c\u0631\u0647 \u0628\u0627\u0632 \u0634\u062f\u0647 \u062f\u0642\u062a \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062a\u06cc\u06a9\u0647\u0627 \u0645\u0634\u0627\u0628\u0647 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u0632\u062f\u0647 \u0634\u062f\u0647 \u0628\u0627\u0634\u062f.<\/li>\n<li>\u062d\u0627\u0644\u0627 \u0628\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u0647\u0627 \u0645\u062d\u062f\u0648\u062f\u0647 \u0646\u0627\u0645\u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0628\u062d\u062b \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li>\u062f\u0631 \u0633\u0644\u0648\u0644 L9 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0645\u06cc \u0646\u0648\u06cc\u0633\u06cc\u0645.<\/li>\n<\/ol>\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;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=INDIRECT(SUBSTITUTE(K9,&quot; &quot;,&quot;_&quot;)) INDIRECT(SUBSTITUTE(L8,&quot; &quot;,&quot;_&quot;))<\/pre><\/div>\n\n\n<p>\u0627\u0644\u0628\u062a\u0647 \u062f\u0642\u062a \u0628\u0641\u0631\u0645\u0627\u0626\u06cc\u062f \u06a9\u0647 \u0622\u062f\u0631\u0633\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0628\u0627\u0644\u0627 \u062f\u0631 \u062e\u0635\u0648\u0635 VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0648 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 \u062a\u0635\u0648\u06cc\u0631\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0646\u0645\u0648\u0646\u0647 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a . \u0644\u0630\u0627 \u0634\u0645\u0627 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u062f\u062a\u0627\u0646 \u0628\u0627\u06cc\u062f \u0622\u062f\u0631\u0633\u0647\u0627 \u0631\u0627 \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 \u0646\u06cc\u0627\u0632 \u062e\u0648\u062f\u062a\u0627\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.<\/p>\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;5070&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;12&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;3.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;3.2\\\/5 - (12 \u0627\u0645\u062a\u06cc\u0627\u0632)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637 \u062f\u0631 \u0627\u06a9\u0633\u0644&quot;,&quot;width&quot;:&quot;87.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: 87.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            3.2\/5 - (12 \u0627\u0645\u062a\u06cc\u0627\u0632)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637 \u0648 \u0631\u0648\u0634\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627\u06cc\u06af\u0627\u0646 \u0628\u0647 \u0622\u0646\u0647\u0627 \u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u06cc\u0645 \u0634\u0645\u0627 \u0631\u0627 \u06a9\u0645\u06a9 \u0645\u06cc\u06a9\u0646\u062f \u062a\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0647\u062a\u0631\u06cc \u0627\u0632 \u0627\u06a9\u0633\u0644 \u062f\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0634\u0627\u0628\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u060c \u0627\u0644\u0628\u062a\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 3 \u0631\u0648\u0634 \u0645\u062e\u062a\u0644\u0641 \u0645\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645 \u06a9\u0647 \u0647\u0631 \u0633\u0647 \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5072,"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":[88],"tags":[130,116,70],"class_list":["post-5070","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-88","tag-match","tag-vlookup","tag-70"],"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\/2022\/06\/TwoCriteria-300x169.png","uagb_featured_image_src":{"full":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria.png",1280,720,false],"thumbnail":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria-150x150.png",150,150,true],"medium":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria-300x169.png",300,169,true],"medium_large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria-768x432.png",768,432,true],"large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria-1024x576.png",800,450,true],"1536x1536":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria.png",1280,720,false],"2048x2048":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria.png",1280,720,false],"gform-image-choice-sm":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria.png",300,169,false],"gform-image-choice-md":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria.png",400,225,false],"gform-image-choice-lg":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2022\/06\/TwoCriteria.png",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":2,"uagb_excerpt":"VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637 \u0648 \u0631\u0648\u0634\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627\u06cc\u06af\u0627\u0646 \u0628\u0647 \u0622\u0646\u0647\u0627 \u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u06cc\u0645 \u0634\u0645\u0627 \u0631\u0627 \u06a9\u0645\u06a9 \u0645\u06cc\u06a9\u0646\u062f \u062a\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0647\u062a\u0631\u06cc \u0627\u0632 \u0627\u06a9\u0633\u0644 \u062f\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0634\u0627\u0628\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u060c \u0627\u0644\u0628\u062a\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 3 \u0631\u0648\u0634 \u0645\u062e\u062a\u0644\u0641 \u0645\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645 \u06a9\u0647 \u0647\u0631 \u0633\u0647 \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9&hellip;","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%da%a9%d8%b3%d9%84\/\" class=\"advgb-post-tax-term\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644<\/span>"]},"tags":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%da%a9%d8%b3%d9%84\/\" class=\"advgb-post-tax-term\">MATCH<\/a>","<a href=\"https:\/\/officebaz.ir\/ex\/category\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%da%a9%d8%b3%d9%84\/\" class=\"advgb-post-tax-term\">VLOOKUP<\/a>","<a href=\"https:\/\/officebaz.ir\/ex\/category\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%da%a9%d8%b3%d9%84\/\" class=\"advgb-post-tax-term\">\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u06a9\u0633\u0644<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">MATCH<\/span>","<span class=\"advgb-post-tax-term\">VLOOKUP<\/span>","<span class=\"advgb-post-tax-term\">\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u06a9\u0633\u0644<\/span>"]}},"comment_count":"2","relative_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 4 \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 8 \u062a\u06cc\u0631 1401","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 8 \u062a\u06cc\u0631 1401 10:30 \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":"VLOOKUP \u0628\u0627 2 \u0634\u0631\u0637","series_order":"","_links":{"self":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/5070","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=5070"}],"version-history":[{"count":0,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/5070\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media\/5072"}],"wp:attachment":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media?parent=5070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/categories?post=5070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/tags?post=5070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}