{"id":72145,"date":"2025-09-02T07:10:58","date_gmt":"2025-09-02T07:10:58","guid":{"rendered":"https:\/\/onlineexammaker.com\/kb\/?p=72145"},"modified":"2025-10-05T13:56:22","modified_gmt":"2025-10-05T13:56:22","slug":"15-vlookup-quiz-questions-and-answers-ar","status":"publish","type":"post","link":"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/","title":{"rendered":"15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629"},"content":{"rendered":"<p>Vlookup \u0647\u064a \u0648\u0638\u064a\u0641\u0629 \u0634\u0627\u0626\u0639\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u060c \u0645\u062b\u0644 Microsoft Excel \u0648 Google Sheets \u060c \u062a\u0633\u062a\u062e\u062f\u0645 \u0644\u0644\u0628\u062d\u062b \u0639\u0646 \u0642\u064a\u0645\u0629 \u0645\u062d\u062f\u062f\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u0648\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0630\u0627\u062a \u0627\u0644\u0635\u0644\u0629 \u0645\u0646 \u062c\u0632\u0621 \u0622\u062e\u0631 \u0645\u0646 \u0627\u0644\u062c\u062f\u0648\u0644. \u064a\u0631\u0645\u0632 \u0645\u0635\u0637\u0644\u062d &#8220;Vlookup&#8221; \u0625\u0644\u0649 &#8220;\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u0639\u0645\u0648\u062f\u064a&#8221; \u060c \u0645\u0645\u0627 \u064a\u0634\u064a\u0631 \u0625\u0644\u0649 \u0623\u0646 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u062a\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u0642\u064a\u0645 \u0631\u0623\u0633\u064a\u0627\u064b \u0641\u064a \u0639\u0645\u0648\u062f.<\/p>\n<h3>\u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0645\u0642\u0627\u0644\u0629<\/h3>\n<ul class=\"article_list\">\n<li><a href=\"#1\">\u0627\u0644\u062c\u0632\u0621 1: \u0625\u0646\u0634\u0627\u0621 \u0627\u062e\u062a\u0628\u0627\u0631 Vlookup \u0641\u064a \u062f\u0642\u0627\u0626\u0642 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 AI \u0645\u0639 OnlineExamMaker<\/a><\/li>\n<li><a href=\"#2\">\u0627\u0644\u062c\u0632\u0621 2: 15 Vookeup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629<\/a><\/li>\n<li><a href=\"#3\">\u0627\u0644\u062c\u0632\u0621 3: \u0645\u0648\u0644\u062f \u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a &#8211; \u0642\u0645 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0628\u0625\u0646\u0634\u0627\u0621 \u0623\u0633\u0626\u0644\u0629 \u0644\u062a\u0642\u064a\u064a\u0645\u0643 \u0627\u0644\u062a\u0627\u0644\u064a<\/a><\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2023\/08\/vlookup-quiz.webp\" alt=\"\"\/><\/p>\n<h3 id=\"1\">\u0627\u0644\u062c\u0632\u0621 1: \u0625\u0646\u0634\u0627\u0621 \u0627\u062e\u062a\u0628\u0627\u0631 Vlookup \u0641\u064a \u062f\u0642\u0627\u0626\u0642 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 AI \u0645\u0639 OnlineExamMaker<\/h3>\n<p>\u0639\u0646\u062f\u0645\u0627 \u064a\u062a\u0639\u0644\u0642 \u0627\u0644\u0623\u0645\u0631 \u0628\u0633\u0647\u0648\u0644\u0629 \u0625\u0646\u0634\u0627\u0621 \u062a\u0642\u064a\u064a\u0645 \u0645\u0647\u0627\u0631\u0627\u062a Vlookup \u060c \u0641\u0625\u0646 OnlineExamMaker \u0647\u0648 \u0623\u062d\u062f \u0623\u0641\u0636\u0644 \u0627\u0644\u0628\u0631\u0627\u0645\u062c \u0644\u0635\u0646\u0639 \u0627\u0644\u0645\u0633\u0627\u0628\u0642\u0629 \u0627\u0644\u062a\u064a \u062a\u0639\u0645\u0644 \u0628\u0627\u0644\u0646\u064a\u0627\u0628\u0629 \u0639\u0646 \u0645\u0624\u0633\u0633\u0627\u062a\u0643 \u0623\u0648 \u0623\u0639\u0645\u0627\u0644\u0643. \u0645\u0646 \u062e\u0644\u0627\u0644 \u0645\u0648\u0644\u062f \u0623\u0633\u0626\u0644\u0629 AI \u0627\u0644\u062e\u0627\u0635 \u0628\u0647 \u060c \u0641\u0642\u0637 \u0642\u0645 \u0628\u062a\u062d\u0645\u064a\u0644 \u0645\u0633\u062a\u0646\u062f \u0623\u0648 \u0625\u062f\u062e\u0627\u0644 \u0643\u0644\u0645\u0627\u062a \u0631\u0626\u064a\u0633\u064a\u0629 \u062d\u0648\u0644 \u0645\u0648\u0636\u0648\u0639 \u0627\u0644\u062a\u0642\u064a\u064a\u0645 \u0627\u0644\u062e\u0627\u0635 \u0628\u0643 \u060c \u064a\u0645\u0643\u0646\u0643 \u0625\u0646\u0634\u0627\u0621 \u0623\u0633\u0626\u0644\u0629 \u0645\u0633\u0627\u0628\u0642\u0629 \u0639\u0627\u0644\u064a\u0629 \u0627\u0644\u062c\u0648\u062f\u0629 \u062d\u0648\u0644 \u0623\u064a \u0645\u0648\u0636\u0648\u0639 \u0648\u0645\u0633\u062a\u0648\u0649 \u0635\u0639\u0648\u0628\u0629 \u0648\u062a\u0646\u0633\u064a\u0642.<\/p>\n<p><strong> \u0646\u0638\u0631\u0629 \u0639\u0627\u0645\u0629 \u0639\u0644\u0649 \u0645\u064a\u0632\u0627\u062a\u0647\u0627 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629 \u0627\u0644\u0645\u062a\u0639\u0644\u0642\u0629 \u0628\u0627\u0644\u062a\u0642\u064a\u064a\u0645: <\/strong><br \/>\n\u25cf \u0645\u0648\u0644\u062f \u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a \u0644\u0645\u0633\u0627\u0639\u062f\u062a\u0643 \u0641\u064a \u062a\u0648\u0641\u064a\u0631 \u0627\u0644\u0648\u0642\u062a \u0641\u064a \u0625\u0646\u0634\u0627\u0621 \u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0627\u062e\u062a\u0628\u0627\u0631 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627.<br \/>\n\u25cf \u0634\u0627\u0631\u0643 \u0627\u0645\u062a\u062d\u0627\u0646\u0643 \u0639\u0628\u0631 \u0627\u0644\u0625\u0646\u062a\u0631\u0646\u062a \u0645\u0639 \u0627\u0644\u062c\u0645\u0627\u0647\u064a\u0631 \u0639\u0644\u0649 \u0627\u0644\u0645\u0646\u0635\u0627\u062a \u0627\u0644\u0627\u062c\u062a\u0645\u0627\u0639\u064a\u0629 \u0645\u062b\u0644 Facebook \u0648 Twitter \u0648 Reddit \u0648\u0627\u0644\u0645\u0632\u064a\u062f.<br \/>\n\u25cf \u064a\u0633\u062c\u0644 \u0639\u0644\u0649 \u0627\u0644\u0641\u0648\u0631 \u0623\u0633\u0626\u0644\u0629 \u0645\u0648\u0636\u0648\u0639\u064a\u0629 \u0648\u0627\u0644\u0625\u062c\u0627\u0628\u0627\u062a \u0627\u0644\u0630\u0627\u062a\u064a\u0629 \u060c \u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062a\u0633\u062c\u064a\u0644 \u0627\u0644\u0645\u0633\u062a\u0646\u062f \u0625\u0644\u0649 Rubric \u0644\u0644\u062a\u0646\u0627\u0633\u0642.<br \/>\n\u25cf \u0628\u0628\u0633\u0627\u0637\u0629 \u0646\u0633\u062e \u0648\u0625\u062f\u0631\u0627\u062c \u0628\u0636\u0639\u0629 \u0623\u0633\u0637\u0631 \u0645\u0646 \u0627\u0644\u0631\u0645\u0648\u0632 \u0627\u0644\u0645\u062f\u0645\u062c\u0629 \u0644\u0639\u0631\u0636 \u0627\u0644\u0627\u0645\u062a\u062d\u0627\u0646\u0627\u062a \u0639\u0628\u0631 \u0627\u0644\u0625\u0646\u062a\u0631\u0646\u062a \u0639\u0644\u0649 \u0645\u0648\u0642\u0639 \u0627\u0644\u0648\u064a\u0628 \u0627\u0644\u062e\u0627\u0635 \u0628\u0643 \u0623\u0648 \u0645\u062f\u0648\u0646\u0629 WordPress.<\/p>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/zlqho9igH2Y\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">\u0625\u0646\u0634\u0627\u0621 \u0627\u0644\u0623\u0633\u0626\u0644\u0629 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html?refer=download_questions\" target=\"_blank\" rel=\"noopener\">\u0645\u0648\u0644\u062f \u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a<\/a><\/div>\n<div class=\"p-style-b\">\u0625\u0646\u0634\u0627\u0621 \u0623\u0633\u0626\u0644\u0629 \u0644\u0623\u064a \u0645\u0648\u0636\u0648\u0639<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> \u0625\u0646\u0634\u0627\u0621 \u0627\u062e\u062a\u0628\u0627\u0631<\/a><\/div>\n<div class=\"p-style-b\">\u0645\u062c\u0627\u0646\u064a 100% \u0625\u0644\u0649 \u0627\u0644\u0623\u0628\u062f<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3 id=\"2\">\u0627\u0644\u062c\u0632\u0621 2: 15 Vookeup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629<\/h3>\n<p><button id=\"copyquestionsBtn\" type=\"button\" onclick=\"myFunction()\">\u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0646\u0633\u062e<\/button>\u00a0\u00a0or\u00a0\u00a0<button id=\"genquestionsBtn\" class=\"genbtnstyle\" type=\"button\" onclick=\"myFunction1()\">\u062a\u0648\u0644\u064a\u062f \u0627\u0644\u0623\u0633\u0626\u0644\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a<\/button><\/p>\n<div id=\"copy_questions\">\n<p>\u0633\u0624\u0627\u0644 1: \u0645\u0627 \u0647\u0648 VLOOKUP \u0641\u064a Excel\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u0648\u0638\u064a\u0641\u0629 \u0644\u0644\u0628\u062d\u062b \u0627\u0644\u0623\u0641\u0642\u064a<br \/>\n\u0628) \u0648\u0638\u064a\u0641\u0629 \u0644\u0644\u0628\u062d\u062b \u0627\u0644\u0639\u0645\u0648\u062f\u064a<br \/>\n\u062c) \u0648\u0638\u064a\u0641\u0629 \u0644\u0644\u062a\u0631\u062a\u064a\u0628<br \/>\n\u062f) \u0648\u0638\u064a\u0641\u0629 \u0644\u0644\u062a\u0635\u0641\u064a\u0629<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0628) \u0648\u0638\u064a\u0641\u0629 \u0644\u0644\u0628\u062d\u062b \u0627\u0644\u0639\u0645\u0648\u062f\u064a<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: VLOOKUP \u0647\u064a \u0648\u0638\u064a\u0641\u0629 \u0641\u064a Excel \u062a\u0633\u062a\u062e\u062f\u0645 \u0644\u0644\u0628\u062d\u062b \u0639\u0646 \u0642\u064a\u0645\u0629 \u0641\u064a \u0639\u0645\u0648\u062f \u0648\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0642\u064a\u0645\u0629 \u0645\u0646 \u0639\u0645\u0648\u062f \u0622\u062e\u0631 \u0641\u064a \u0646\u0641\u0633 \u0627\u0644\u0635\u0641.  <\/p>\n<p>\u0633\u0624\u0627\u0644 2: \u0645\u0627 \u0647\u064a \u0628\u0646\u064a\u0629 VLOOKUP \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<br \/>\n\u0628) VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)<br \/>\n\u062c) VLOOKUP(col_index_num, lookup_value, table_array, range_lookup)<br \/>\n\u062f) VLOOKUP(range_lookup, table_array, lookup_value, col_index_num)<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0623) VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0628\u0646\u064a\u0629 VLOOKUP \u062a\u062a\u0643\u0648\u0646 \u0645\u0646 \u0623\u0631\u0628\u0639\u0629 \u062d\u062c\u062c \u0631\u0626\u064a\u0633\u064a\u0629\u060c \u062d\u064a\u062b \u064a\u0628\u062f\u0623 \u0627\u0644\u0628\u062d\u062b \u0628\u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0645\u0631\u0627\u062f \u0627\u0644\u0628\u062d\u062b \u0639\u0646\u0647\u0627.  <\/p>\n<p>\u0633\u0624\u0627\u0644 3: \u0645\u0627 \u0647\u0648 \u062f\u0648\u0631 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 \u0641\u064a VLOOKUP\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u062a\u062d\u062f\u064a\u062f \u0639\u0645\u0648\u062f \u0627\u0644\u0627\u0633\u062a\u0631\u062f\u0627\u062f<br \/>\n\u0628) \u062a\u062d\u062f\u064a\u062f \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u062a\u064a \u064a\u062a\u0645 \u0627\u0644\u0628\u062d\u062b \u0639\u0646\u0647\u0627<br \/>\n\u062c) \u062a\u062d\u062f\u064a\u062f \u0646\u0637\u0627\u0642 \u0627\u0644\u062c\u062f\u0648\u0644<br \/>\n\u062f) \u062a\u062d\u062f\u064a\u062f \u0646\u0648\u0639 \u0627\u0644\u0628\u062d\u062b<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0628) \u062a\u062d\u062f\u064a\u062f \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u062a\u064a \u064a\u062a\u0645 \u0627\u0644\u0628\u062d\u062b \u0639\u0646\u0647\u0627<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 (lookup_value) \u0647\u064a \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u062a\u064a \u064a\u062a\u0645 \u0627\u0644\u0628\u062d\u062b \u0639\u0646\u0647\u0627 \u0641\u064a \u0639\u0645\u0648\u062f \u0627\u0644\u062c\u062f\u0648\u0644 \u0627\u0644\u0623\u0648\u0644.  <\/p>\n<p>\u0633\u0624\u0627\u0644 4: \u0645\u0627 \u0647\u0648 \u062a\u0623\u062b\u064a\u0631 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0631\u0627\u0628\u0639\u0629 \u0641\u064a VLOOKUP\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u062a\u062d\u062f\u064a\u062f \u0639\u0645\u0648\u062f \u0627\u0644\u062c\u062f\u0648\u0644<br \/>\n\u0628) \u062a\u062d\u062f\u064a\u062f \u0645\u0627 \u0625\u0630\u0627 \u0643\u0627\u0646 \u0627\u0644\u0628\u062d\u062b \u062f\u0642\u064a\u0642\u064b\u0627 \u0623\u0645 \u062a\u0642\u0631\u064a\u0628\u064a\u064b\u0627<br \/>\n\u062c) \u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0642\u064a\u0645\u0629 \u0645\u0628\u0627\u0634\u0631\u0629<br \/>\n\u062f) \u0641\u0631\u0632 \u0627\u0644\u062c\u062f\u0648\u0644<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0628) \u062a\u062d\u062f\u064a\u062f \u0645\u0627 \u0625\u0630\u0627 \u0643\u0627\u0646 \u0627\u0644\u0628\u062d\u062b \u062f\u0642\u064a\u0642\u064b\u0627 \u0623\u0645 \u062a\u0642\u0631\u064a\u0628\u064a\u064b\u0627<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0631\u0627\u0628\u0639\u0629 (range_lookup) \u062a\u062d\u062f\u062f \u0646\u0648\u0639 \u0627\u0644\u0628\u062d\u062b\u060c \u062d\u064a\u062b \u064a\u0645\u0643\u0646 \u0623\u0646 \u062a\u0643\u0648\u0646 TRUE \u0644\u0644\u0628\u062d\u062b \u0627\u0644\u062a\u0642\u0631\u064a\u0628\u064a \u0623\u0648 FALSE \u0644\u0644\u0628\u062d\u062b \u0627\u0644\u062f\u0642\u064a\u0642.  <\/p>\n<p>\u0633\u0624\u0627\u0644 5: \u0645\u062a\u0649 \u064a\u0639\u064a\u062f VLOOKUP \u0642\u064a\u0645\u0629 \u062a\u0642\u0631\u064a\u0628\u064a\u0629\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u0639\u0646\u062f\u0645\u0627 \u062a\u0643\u0648\u0646 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0631\u0627\u0628\u0639\u0629 FALSE<br \/>\n\u0628) \u0639\u0646\u062f\u0645\u0627 \u062a\u0643\u0648\u0646 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0631\u0627\u0628\u0639\u0629 TRUE<br \/>\n\u062c) \u062f\u0627\u0626\u0645\u064b\u0627<br \/>\n\u062f) \u0623\u0628\u062f\u064b\u0627<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0628) \u0639\u0646\u062f\u0645\u0627 \u062a\u0643\u0648\u0646 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0631\u0627\u0628\u0639\u0629 TRUE<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0639\u0646\u062f \u0648\u0636\u0639 TRUE \u0641\u064a \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0631\u0627\u0628\u0639\u0629\u060c \u064a\u0642\u0648\u0645 VLOOKUP \u0628\u0627\u0644\u0628\u062d\u062b \u0639\u0646 \u0623\u0642\u0631\u0628 \u0642\u064a\u0645\u0629 \u0623\u0643\u0628\u0631 \u0645\u0646 \u0623\u0648 \u062a\u0633\u0627\u0648\u064a \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0645\u0637\u0644\u0648\u0628\u0629.  <\/p>\n<p>\u0633\u0624\u0627\u0644 6: \u0645\u0627 \u0627\u0644\u062e\u0637\u0623 \u0627\u0644\u0634\u0627\u0626\u0639 \u0625\u0630\u0627 \u0644\u0645 \u064a\u062a\u0645 \u0627\u0644\u0639\u062b\u0648\u0631 \u0639\u0644\u0649 \u0627\u0644\u0642\u064a\u0645\u0629 \u0641\u064a VLOOKUP\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) #N\/A<br \/>\n\u0628) #VALUE!<br \/>\n\u062c) #REF!<br \/>\n\u062f) #DIV\/0!<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0623) #N\/A<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0625\u0630\u0627 \u0644\u0645 \u064a\u062c\u062f VLOOKUP \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0645\u0637\u0644\u0648\u0628\u0629\u060c \u062e\u0627\u0635\u0629 \u0641\u064a \u062d\u0627\u0644\u0629 \u0627\u0644\u0628\u062d\u062b \u0627\u0644\u062f\u0642\u064a\u0642\u060c \u064a\u0639\u064a\u062f \u062e\u0637\u0623 #N\/A.  <\/p>\n<p>\u0633\u0624\u0627\u0644 7: \u0645\u0627 \u0647\u0648 \u0634\u0631\u0637 \u0646\u0637\u0627\u0642 \u0627\u0644\u062c\u062f\u0648\u0644 \u0641\u064a VLOOKUP\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u064a\u062c\u0628 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0623\u0641\u0642\u064a\u064b\u0627 \u0641\u0642\u0637<br \/>\n\u0628) \u064a\u062c\u0628 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0639\u0645\u0648\u062f\u064a\u064b\u0627 \u0645\u0639 \u0627\u0644\u0642\u064a\u0645\u0629 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0623\u0648\u0644<br \/>\n\u062c) \u064a\u0645\u0643\u0646 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0639\u0634\u0648\u0627\u0626\u064a\u064b\u0627<br \/>\n\u062f) \u064a\u062c\u0628 \u0623\u0646 \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0623\u0631\u0642\u0627\u0645 \u0641\u0642\u0637<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0628) \u064a\u062c\u0628 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0639\u0645\u0648\u062f\u064a\u064b\u0627 \u0645\u0639 \u0627\u0644\u0642\u064a\u0645\u0629 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0623\u0648\u0644<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0646\u0637\u0627\u0642 \u0627\u0644\u062c\u062f\u0648\u0644 (table_array) \u064a\u062c\u0628 \u0623\u0646 \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0645\u0637\u0644\u0648\u0628\u0629 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0623\u0648\u0644 \u0644\u064a\u062a\u0645 \u0627\u0644\u0628\u062d\u062b \u0628\u0634\u0643\u0644 \u0635\u062d\u064a\u062d.  <\/p>\n<p>\u0633\u0624\u0627\u0644 8: \u0643\u064a\u0641 \u064a\u0645\u0643\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VLOOKUP \u0644\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0642\u064a\u0645\u0629 \u0645\u0646 \u0639\u0645\u0648\u062f \u062b\u0627\u0646\u064a\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u062b\u0627\u0644\u062b\u0629 \u0644\u062a\u062d\u062f\u064a\u062f \u0631\u0642\u0645 \u0627\u0644\u0639\u0645\u0648\u062f<br \/>\n\u0628) \u0628\u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0623\u0648\u0644\u0649<br \/>\n\u062c) \u0628\u0625\u0636\u0627\u0641\u0629 \u0639\u0645\u0648\u062f \u0625\u0636\u0627\u0641\u064a<br \/>\n\u062f) \u063a\u064a\u0631 \u0630\u0644\u0643<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0623) \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u062b\u0627\u0644\u062b\u0629 \u0644\u062a\u062d\u062f\u064a\u062f \u0631\u0642\u0645 \u0627\u0644\u0639\u0645\u0648\u062f<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u062b\u0627\u0644\u062b\u0629 (col_index_num) \u062a\u0634\u064a\u0631 \u0625\u0644\u0649 \u0631\u0642\u0645 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0630\u064a \u064a\u062a\u0645 \u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0642\u064a\u0645\u0629 \u0645\u0646\u0647 \u0646\u0633\u0628\u0629 \u0625\u0644\u0649 \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0623\u0648\u0644.  <\/p>\n<p>\u0633\u0624\u0627\u0644 9: \u0647\u0644 VLOOKUP \u062d\u0633\u0627\u0633 \u0644\u0644\u062d\u0631\u0648\u0641 \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u0648\u0627\u0644\u0635\u063a\u064a\u0631\u0629\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u0646\u0639\u0645\u060c \u062f\u0627\u0626\u0645\u064b\u0627<br \/>\n\u0628) \u0644\u0627\u060c \u063a\u064a\u0631 \u062d\u0633\u0627\u0633<br \/>\n\u062c) \u064a\u0639\u062a\u0645\u062f \u0639\u0644\u0649 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0631\u0627\u0628\u0639\u0629<br \/>\n\u062f) \u0641\u0642\u0637 \u0641\u064a \u0627\u0644\u0628\u062d\u062b \u0627\u0644\u062a\u0642\u0631\u064a\u0628\u064a<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0628) \u0644\u0627\u060c \u063a\u064a\u0631 \u062d\u0633\u0627\u0633<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: VLOOKUP \u063a\u064a\u0631 \u062d\u0633\u0627\u0633 \u0644\u0644\u062d\u0631\u0648\u0641 \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u0648\u0627\u0644\u0635\u063a\u064a\u0631\u0629\u060c \u062d\u064a\u062b \u064a\u0639\u0627\u0645\u0644 &#8220;Apple&#8221; \u0648&#8221;apple&#8221; \u0643\u0642\u064a\u0645\u0629 \u0648\u0627\u062d\u062f\u0629.  <\/p>\n<p>\u0633\u0624\u0627\u0644 10: \u0643\u064a\u0641 \u064a\u062a\u0639\u0627\u0645\u0644 VLOOKUP \u0645\u0639 \u0627\u0644\u0623\u0631\u0642\u0627\u0645\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u064a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u062a\u062d\u0648\u064a\u0644\u0647\u0627 \u0625\u0644\u0649 \u0646\u0635\u0648\u0635<br \/>\n\u0628) \u064a\u062a\u0639\u0627\u0645\u0644 \u0645\u0639\u0647\u0627 \u0643\u0623\u064a \u0642\u064a\u0645\u0629 \u0623\u062e\u0631\u0649<br \/>\n\u062c) \u064a\u0631\u0641\u0636\u0647\u0627 \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u063a\u064a\u0631 \u0645\u0631\u062a\u0628\u0629<br \/>\n\u062f) \u064a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0635\u064a\u0627\u063a\u0629 \u062e\u0627\u0635\u0629<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0628) \u064a\u062a\u0639\u0627\u0645\u0644 \u0645\u0639\u0647\u0627 \u0643\u0623\u064a \u0642\u064a\u0645\u0629 \u0623\u062e\u0631\u0649<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: VLOOKUP \u064a\u0645\u0643\u0646\u0647 \u0627\u0644\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u0623\u0631\u0642\u0627\u0645 \u0645\u0628\u0627\u0634\u0631\u0629 \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0623\u0648\u0644.  <\/p>\n<p>\u0633\u0624\u0627\u0644 11: \u0647\u0644 \u064a\u0645\u0643\u0646 \u062a\u0639\u0634\u064a\u0631 VLOOKUP \u062f\u0627\u062e\u0644 \u0648\u0638\u064a\u0641\u0629 \u0623\u062e\u0631\u0649\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u0644\u0627\u060c \u063a\u064a\u0631 \u0645\u0645\u0643\u0646<br \/>\n\u0628) \u0646\u0639\u0645\u060c \u0645\u062b\u0644 \u0641\u064a IF<br \/>\n\u062c) \u0641\u0642\u0637 \u0641\u064a SUM<br \/>\n\u062f) \u0641\u0642\u0637 \u0641\u064a COUNT<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0628) \u0646\u0639\u0645\u060c \u0645\u062b\u0644 \u0641\u064a IF<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: VLOOKUP \u064a\u0645\u0643\u0646 \u062a\u0639\u0634\u064a\u0631\u0647\u0627 \u062f\u0627\u062e\u0644 \u0648\u0638\u0627\u0626\u0641 \u0623\u062e\u0631\u0649 \u0645\u062b\u0644 IF \u0644\u0625\u062c\u0631\u0627\u0621 \u0639\u0645\u0644\u064a\u0627\u062a \u0634\u0631\u0637\u064a\u0629.  <\/p>\n<p>\u0633\u0624\u0627\u0644 12: \u0645\u0627 \u0647\u0648 \u0627\u0644\u062e\u0637\u0623 \u0627\u0644\u0634\u0627\u0626\u0639 \u0641\u064a VLOOKUP \u0639\u0646\u062f \u062a\u062d\u062f\u064a\u062f \u0631\u0642\u0645 \u0627\u0644\u0639\u0645\u0648\u062f\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0631\u0642\u0645 \u0623\u0643\u0628\u0631 \u0645\u0646 \u0639\u062f\u062f \u0627\u0644\u0623\u0639\u0645\u062f\u0629<br \/>\n\u0628) \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0623\u062d\u0631\u0641 \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0623\u0631\u0642\u0627\u0645<br \/>\n\u062c) \u0639\u062f\u0645 \u062a\u0631\u062a\u064a\u0628 \u0627\u0644\u062c\u062f\u0648\u0644<br \/>\n\u062f) \u0643\u0644 \u0627\u0644\u062e\u064a\u0627\u0631\u0627\u062a<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0623) \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0631\u0642\u0645 \u0623\u0643\u0628\u0631 \u0645\u0646 \u0639\u062f\u062f \u0627\u0644\u0623\u0639\u0645\u062f\u0629<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0625\u0630\u0627 \u0643\u0627\u0646 \u0631\u0642\u0645 \u0627\u0644\u0639\u0645\u0648\u062f (col_index_num) \u0623\u0643\u0628\u0631 \u0645\u0646 \u0639\u062f\u062f \u0627\u0644\u0623\u0639\u0645\u062f\u0629 \u0641\u064a \u0627\u0644\u062c\u062f\u0648\u0644\u060c \u064a\u0638\u0647\u0631 \u062e\u0637\u0623 #REF!.  <\/p>\n<p>\u0633\u0624\u0627\u0644 13: \u0645\u0627 \u0627\u0644\u0641\u0631\u0642 \u0627\u0644\u0631\u0626\u064a\u0633\u064a \u0628\u064a\u0646 VLOOKUP \u0648 HLOOKUP\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) VLOOKUP \u064a\u0628\u062d\u062b \u0639\u0645\u0648\u062f\u064a\u064b\u0627 \u0648 HLOOKUP \u0623\u0641\u0642\u064a\u064b\u0627<br \/>\n\u0628) \u0644\u0627 \u0641\u0631\u0642<br \/>\n\u062c) VLOOKUP \u0623\u0633\u0631\u0639<br \/>\n\u062f) HLOOKUP \u064a\u0633\u062a\u062e\u062f\u0645 \u0644\u0644\u0623\u0631\u0642\u0627\u0645 \u0641\u0642\u0637<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0623) VLOOKUP \u064a\u0628\u062d\u062b \u0639\u0645\u0648\u062f\u064a\u064b\u0627 \u0648 HLOOKUP \u0623\u0641\u0642\u064a\u064b\u0627<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: VLOOKUP \u064a\u0628\u062d\u062b \u0641\u064a \u0627\u0644\u0635\u0641\u0648\u0641 \u0639\u0645\u0648\u062f\u064a\u064b\u0627\u060c \u0628\u064a\u0646\u0645\u0627 HLOOKUP \u064a\u0628\u062d\u062b \u0641\u064a \u0627\u0644\u0623\u0639\u0645\u062f\u0629 \u0623\u0641\u0642\u064a\u064b\u0627.  <\/p>\n<p>\u0633\u0624\u0627\u0644 14: \u0643\u064a\u0641 \u064a\u0645\u0643\u0646 \u062a\u062d\u062f\u064a\u062b \u0646\u0637\u0627\u0642 \u0627\u0644\u062c\u062f\u0648\u0644 \u0641\u064a VLOOKUP\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) \u0628\u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u062b\u0627\u0646\u064a\u0629 \u064a\u062f\u0648\u064a\u064b\u0627<br \/>\n\u0628) \u0644\u0627 \u064a\u0645\u0643\u0646 \u062a\u062d\u062f\u064a\u062b\u0647<br \/>\n\u062c) \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 INDIRECT<br \/>\n\u062f) \u0641\u0642\u0637 \u0641\u064a Excel \u0627\u0644\u062c\u062f\u064a\u062f<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0623) \u0628\u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u062b\u0627\u0646\u064a\u0629 \u064a\u062f\u0648\u064a\u064b\u0627<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u064a\u0645\u0643\u0646 \u062a\u062d\u062f\u064a\u062b \u0646\u0637\u0627\u0642 \u0627\u0644\u062c\u062f\u0648\u0644 (table_array) \u0639\u0646 \u0637\u0631\u064a\u0642 \u062a\u0639\u062f\u064a\u0644 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u062b\u0627\u0646\u064a\u0629 \u0641\u064a \u0627\u0644\u0635\u064a\u063a\u0629.  <\/p>\n<p>\u0633\u0624\u0627\u0644 15: \u0641\u064a \u0645\u062b\u0627\u0644 \u0639\u0645\u0644\u064a\u060c \u0625\u0630\u0627 \u0643\u0627\u0646 \u0644\u062f\u064a\u0643 \u062c\u062f\u0648\u0644 \u0628\u0623\u0633\u0645\u0627\u0621 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f A \u0648\u0631\u0633\u0648\u0645 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f B\u060c \u0643\u064a\u0641 \u062a\u0633\u062a\u062e\u062f\u0645 VLOOKUP \u0644\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0631\u0633\u0645 \u0627\u0633\u0645 \u0645\u0639\u064a\u0646\u061f<br \/>\n\u062e\u064a\u0627\u0631\u0627\u062a:<br \/>\n\u0623) VLOOKUP(\u0627\u0633\u0645, A:B, 2, FALSE)<br \/>\n\u0628) VLOOKUP(\u0631\u0633\u0645, A:B, 1, TRUE)<br \/>\n\u062c) VLOOKUP(B:A, 2, \u0627\u0633\u0645, FALSE)<br \/>\n\u062f) VLOOKUP(2, A:B, \u0627\u0633\u0645, TRUE)<br \/>\n\u0627\u0644\u0625\u062c\u0627\u0628\u0629: \u0623) VLOOKUP(\u0627\u0633\u0645, A:B, 2, FALSE)<br \/>\n\u0627\u0644\u062a\u0641\u0633\u064a\u0631: \u0647\u0630\u0627 \u064a\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u0627\u0633\u0645 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f A \u0648\u064a\u0633\u062a\u0631\u062f\u062f \u0627\u0644\u0631\u0633\u0645 \u0645\u0646 \u0627\u0644\u0639\u0645\u0648\u062f B \u0645\u0639 \u0628\u062d\u062b \u062f\u0642\u064a\u0642.<\/p>\n<\/div>\n<p><button id=\"copyquestionsBtn\" type=\"button\" onclick=\"myFunction()\">\u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0646\u0633\u062e<\/button>\u00a0\u00a0or\u00a0\u00a0<button id=\"genquestionsBtn\" class=\"genbtnstyle\" type=\"button\" onclick=\"myFunction1()\">\u062a\u0648\u0644\u064a\u062f \u0627\u0644\u0623\u0633\u0626\u0644\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a<\/button><\/p>\n<h3 id=\"3\">\u0627\u0644\u062c\u0632\u0621 3: \u0645\u0648\u0644\u062f \u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a &#8211; \u0642\u0645 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0628\u0625\u0646\u0634\u0627\u0621 \u0623\u0633\u0626\u0644\u0629 \u0644\u062a\u0642\u064a\u064a\u0645\u0643 \u0627\u0644\u062a\u0627\u0644\u064a<\/h3>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/zlqho9igH2Y\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">\u0625\u0646\u0634\u0627\u0621 \u0627\u0644\u0623\u0633\u0626\u0644\u0629 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html?refer=download_questions\" target=\"_blank\" rel=\"noopener\">\u0645\u0648\u0644\u062f \u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a<\/a><\/div>\n<div class=\"p-style-b\">\u0625\u0646\u0634\u0627\u0621 \u0623\u0633\u0626\u0644\u0629 \u0644\u0623\u064a \u0645\u0648\u0636\u0648\u0639<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\"> \u0625\u0646\u0634\u0627\u0621 \u0627\u062e\u062a\u0628\u0627\u0631<\/a><\/div>\n<div class=\"p-style-b\">\u0645\u062c\u0627\u0646\u064a 100% \u0625\u0644\u0649 \u0627\u0644\u0623\u0628\u062f<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><script src=\"https:\/\/unpkg.com\/@popperjs\/core@2\"><\/script><br \/>\n<script src=\"https:\/\/unpkg.com\/tippy.js@6\"><\/script><\/p>\n<p><script type=\"text\/javascript\">\nfunction myFunction() {\nvar copyText = document.getElementById(\"copy_questions\");console.log(copyText.innerText);navigator.clipboard.writeText(copyText.innerText);\n}\nfunction myFunction1() {\n\u00a0  \u00a0 \u00a0 window.open(\"https:\/\/onlineexammaker.com\/features\/ai-question-generator.html\");\n\u00a0 }\nvar copy1, copy2;\n        tippy('#copyquestionsBtn', {\n        'content': \"Copy questions to clipboard\",\n       trigger: 'mouseenter',\n       'onCreate':function(instance){\n              copy1 = instance;\n       },\n       'onTrigger': function(instance, event) {\n              copy2.hide();\n       }\n       });\n       tippy('#copyquestionsBtn', {\n       'content': \"Copied successfully\",\n       trigger: 'click',\n       'onCreate':function(instance){\n              copy2 = instance;\n       },\n       'onTrigger': function(instance, event) {\n              copy1.hide();\n       }\n       });\ntippy('#genquestionsBtn', {\n        'content': \"Generate questions using AI for free\",\n         trigger: 'mouseenter'\n       });\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vlookup \u0647\u064a \u0648\u0638\u064a\u0641\u0629 \u0634\u0627\u0626\u0639\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u060c \u0645\u062b\u0644 Microsoft Excel \u0648 Google Sheets \u060c \u062a\u0633\u062a\u062e\u062f\u0645 \u0644\u0644\u0628\u062d\u062b \u0639\u0646 \u0642\u064a\u0645\u0629 \u0645\u062d\u062f\u062f\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u0648\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0630\u0627\u062a \u0627\u0644\u0635\u0644\u0629 \u0645\u0646 \u062c\u0632\u0621 \u0622\u062e\u0631 \u0645\u0646 \u0627\u0644\u062c\u062f\u0648\u0644. \u064a\u0631\u0645\u0632 \u0645\u0635\u0637\u0644\u062d &#8220;Vlookup&#8221; \u0625\u0644\u0649 &#8220;\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u0639\u0645\u0648\u062f\u064a&#8221; \u060c \u0645\u0645\u0627 \u064a\u0634\u064a\u0631 \u0625\u0644\u0649 \u0623\u0646 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u062a\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u0642\u064a\u0645 \u0631\u0623\u0633\u064a\u0627\u064b \u0641\u064a \u0639\u0645\u0648\u062f. \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0645\u0642\u0627\u0644\u0629 \u0627\u0644\u062c\u0632\u0621 1: [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":16625,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5185],"tags":[],"class_list":["post-72145","post","type-post","status-publish","format-standard","hentry","category-questions-answers-ar"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629 - OnlineExamMaker Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629 - OnlineExamMaker Blog\" \/>\n<meta property=\"og:description\" content=\"Vlookup \u0647\u064a \u0648\u0638\u064a\u0641\u0629 \u0634\u0627\u0626\u0639\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u060c \u0645\u062b\u0644 Microsoft Excel \u0648 Google Sheets \u060c \u062a\u0633\u062a\u062e\u062f\u0645 \u0644\u0644\u0628\u062d\u062b \u0639\u0646 \u0642\u064a\u0645\u0629 \u0645\u062d\u062f\u062f\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u0648\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0630\u0627\u062a \u0627\u0644\u0635\u0644\u0629 \u0645\u0646 \u062c\u0632\u0621 \u0622\u062e\u0631 \u0645\u0646 \u0627\u0644\u062c\u062f\u0648\u0644. \u064a\u0631\u0645\u0632 \u0645\u0635\u0637\u0644\u062d &#8220;Vlookup&#8221; \u0625\u0644\u0649 &#8220;\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u0639\u0645\u0648\u062f\u064a&#8221; \u060c \u0645\u0645\u0627 \u064a\u0634\u064a\u0631 \u0625\u0644\u0649 \u0623\u0646 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u062a\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u0642\u064a\u0645 \u0631\u0623\u0633\u064a\u0627\u064b \u0641\u064a \u0639\u0645\u0648\u062f. \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0645\u0642\u0627\u0644\u0629 \u0627\u0644\u062c\u0632\u0621 1: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/\" \/>\n<meta property=\"og:site_name\" content=\"OnlineExamMaker Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-02T07:10:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-05T13:56:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2023\/08\/vlookup-quiz.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"810\" \/>\n\t<meta property=\"og:image:height\" content=\"365\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Rebecca\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rebecca\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/\",\"name\":\"15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629 - OnlineExamMaker Blog\",\"isPartOf\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\"},\"datePublished\":\"2025-09-02T07:10:58+00:00\",\"dateModified\":\"2025-10-05T13:56:22+00:00\",\"author\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineexammaker.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/\",\"name\":\"OnlineExamMaker Blog\",\"description\":\"OnlineExamMaker\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2\",\"name\":\"Rebecca\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g\",\"caption\":\"Rebecca\"},\"url\":\"https:\/\/onlineexammaker.com\/kb\/author\/rebeccaoem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629 - OnlineExamMaker Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/","og_locale":"en_US","og_type":"article","og_title":"15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629 - OnlineExamMaker Blog","og_description":"Vlookup \u0647\u064a \u0648\u0638\u064a\u0641\u0629 \u0634\u0627\u0626\u0639\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u060c \u0645\u062b\u0644 Microsoft Excel \u0648 Google Sheets \u060c \u062a\u0633\u062a\u062e\u062f\u0645 \u0644\u0644\u0628\u062d\u062b \u0639\u0646 \u0642\u064a\u0645\u0629 \u0645\u062d\u062f\u062f\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u0648\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0630\u0627\u062a \u0627\u0644\u0635\u0644\u0629 \u0645\u0646 \u062c\u0632\u0621 \u0622\u062e\u0631 \u0645\u0646 \u0627\u0644\u062c\u062f\u0648\u0644. \u064a\u0631\u0645\u0632 \u0645\u0635\u0637\u0644\u062d &#8220;Vlookup&#8221; \u0625\u0644\u0649 &#8220;\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u0639\u0645\u0648\u062f\u064a&#8221; \u060c \u0645\u0645\u0627 \u064a\u0634\u064a\u0631 \u0625\u0644\u0649 \u0623\u0646 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u062a\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u0642\u064a\u0645 \u0631\u0623\u0633\u064a\u0627\u064b \u0641\u064a \u0639\u0645\u0648\u062f. \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0645\u0642\u0627\u0644\u0629 \u0627\u0644\u062c\u0632\u0621 1: [&hellip;]","og_url":"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/","og_site_name":"OnlineExamMaker Blog","article_published_time":"2025-09-02T07:10:58+00:00","article_modified_time":"2025-10-05T13:56:22+00:00","og_image":[{"width":810,"height":365,"url":"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2023\/08\/vlookup-quiz.webp","type":"image\/webp"}],"author":"Rebecca","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rebecca","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/","url":"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/","name":"15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629 - OnlineExamMaker Blog","isPartOf":{"@id":"https:\/\/onlineexammaker.com\/kb\/#website"},"datePublished":"2025-09-02T07:10:58+00:00","dateModified":"2025-10-05T13:56:22+00:00","author":{"@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2"},"breadcrumb":{"@id":"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineexammaker.com\/kb\/ar\/15-vlookup-quiz-questions-and-answers-ar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineexammaker.com\/kb\/"},{"@type":"ListItem","position":2,"name":"15 Vookup \u0645\u0633\u0627\u0628\u0642\u0629 \u0623\u0633\u0626\u0644\u0629 \u0648\u0623\u062c\u0648\u0628\u0629"}]},{"@type":"WebSite","@id":"https:\/\/onlineexammaker.com\/kb\/#website","url":"https:\/\/onlineexammaker.com\/kb\/","name":"OnlineExamMaker Blog","description":"OnlineExamMaker","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/8447ed5937ab8046fa68476e432b32b2","name":"Rebecca","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5f03edf06dd3745ea73e610a6d830a63?s=96&r=g","caption":"Rebecca"},"url":"https:\/\/onlineexammaker.com\/kb\/author\/rebeccaoem\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/72145"}],"collection":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/comments?post=72145"}],"version-history":[{"count":1,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/72145\/revisions"}],"predecessor-version":[{"id":72146,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/72145\/revisions\/72146"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media\/16625"}],"wp:attachment":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media?parent=72145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/categories?post=72145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/tags?post=72145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}