{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["الرئيسية","النتيجة"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"الرئيسية","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["م","التاريخ","الاسم","الوقت","النتيجة"]
[1,"2019-08-22","محمد 1","19:00:00",3]
[2,"2019-08-22","محمد 2","20:50:00",5]
[3,"2019-08-23","محمد 3","19:00:00"]
[4,"2019-08-23","محمد 4","19:10:00",0]
[5,"2019-08-23","محمد 5","20:50:00",4]
[6,"2019-08-24","محمد 6","18:50:00",2]
[7,"2019-08-24","محمد 7","19:05:00",7]
[8,"2019-08-24","محمد 8","20:50:00",10]
[9,"2019-08-29","محمد 9","18:45:00",3]
[10,"2019-08-29","محمد 10","20:20:00"]
[11,"2019-08-30","محمد 11","18:55:00",0]
[12,"2019-08-30","محمد 12","20:40:00",0]
[13,"2019-08-30","محمد 13","20:40:00",2]
[14,"2019-08-31","محمد 14","18:40:00",3]
[15,"2019-08-31","محمد 15","19:05:00",4]
[16,"2019-09-24","محمد 16","19:05:00",0]
[17,"2019-09-13","محمد 17","18:50:00"]
[18,"2019-09-13","محمد 18","18:50:00",3]
[19,"2019-09-13","محمد 19","20:35:00",9]
[20,"2019-09-14","محمد 20","18:40:00",6]

{"sheet":"النتيجة","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,8,19,17],[24,6,27,6]]}
["م","التاريخ","الاسم","الوقت","النتيجة",null,"النتيجة"]
[1,{"$f":"VLOOKUP(A2,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-22"},{"$f":"VLOOKUP(A2,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 1"},{"$f":"VLOOKUP(A2,الرئيسية!$A$2:$E$21,4,0)","v":"19:00:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A2,الرئيسية!$A$2:$E$21,5,0))","v":3},null,3]
[2,{"$f":"VLOOKUP(A3,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-22"},{"$f":"VLOOKUP(A3,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 2"},{"$f":"VLOOKUP(A3,الرئيسية!$A$2:$E$21,4,0)","v":"20:50:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A3,الرئيسية!$A$2:$E$21,5,0))","v":5},null,5]
[3,{"$f":"VLOOKUP(A4,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-23"},{"$f":"VLOOKUP(A4,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 3"},{"$f":"VLOOKUP(A4,الرئيسية!$A$2:$E$21,4,0)","v":"19:00:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A4,الرئيسية!$A$2:$E$21,5,0))","v":""}]
[4,{"$f":"VLOOKUP(A5,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-23"},{"$f":"VLOOKUP(A5,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 4"},{"$f":"VLOOKUP(A5,الرئيسية!$A$2:$E$21,4,0)","v":"19:10:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A5,الرئيسية!$A$2:$E$21,5,0))","v":0},null,0,null,"السادة أعضاء و خبراء المنتدى المحترمين\nالسلام عليكم و رحمة الله و بركاته\nواجهتني مشكلة في الدالة VLOOKUP \nحيث انها تجلب لي الخلية الفارغة من شيت الرئيسية الى شيت النتيجة بالقيمة 0 صفر كما هو واضح بالخلايا E4 و E11 و E19\nوهذي النتائج غير دقيقة كما تعرفون ارغب من حضراتكم مساعدتي في حل هذه المشكلة اما عن طرق الدالة VLOOKUP\n او اضافة اي دالة اخرى تفي بالغرض والنتيجة المطلوبة كما في العمود الاصفر G\nيعني اذا وجد خلية فارغة في شيت الرئيسية يتركها فارغة في شيت النتيجة مع ملاحظة ان الصفر قيمة محسوبة اذا وجد القيمة 0 يبقى 0 \n"]
[5,{"$f":"VLOOKUP(A6,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-23"},{"$f":"VLOOKUP(A6,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 5"},{"$f":"VLOOKUP(A6,الرئيسية!$A$2:$E$21,4,0)","v":"20:50:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A6,الرئيسية!$A$2:$E$21,5,0))","v":4},null,4]
[6,{"$f":"VLOOKUP(A7,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-24"},{"$f":"VLOOKUP(A7,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 6"},{"$f":"VLOOKUP(A7,الرئيسية!$A$2:$E$21,4,0)","v":"18:50:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A7,الرئيسية!$A$2:$E$21,5,0))","v":2},null,2]
[7,{"$f":"VLOOKUP(A8,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-24"},{"$f":"VLOOKUP(A8,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 7"},{"$f":"VLOOKUP(A8,الرئيسية!$A$2:$E$21,4,0)","v":"19:05:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A8,الرئيسية!$A$2:$E$21,5,0))","v":7},null,7]
[8,{"$f":"VLOOKUP(A9,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-24"},{"$f":"VLOOKUP(A9,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 8"},{"$f":"VLOOKUP(A9,الرئيسية!$A$2:$E$21,4,0)","v":"20:50:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A9,الرئيسية!$A$2:$E$21,5,0))","v":10},null,10]
[9,{"$f":"VLOOKUP(A10,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-29"},{"$f":"VLOOKUP(A10,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 9"},{"$f":"VLOOKUP(A10,الرئيسية!$A$2:$E$21,4,0)","v":"18:45:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A10,الرئيسية!$A$2:$E$21,5,0))","v":3},null,3]
[10,{"$f":"VLOOKUP(A11,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-29"},{"$f":"VLOOKUP(A11,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 10"},{"$f":"VLOOKUP(A11,الرئيسية!$A$2:$E$21,4,0)","v":"20:20:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A11,الرئيسية!$A$2:$E$21,5,0))","v":""}]
[11,{"$f":"VLOOKUP(A12,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-30"},{"$f":"VLOOKUP(A12,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 11"},{"$f":"VLOOKUP(A12,الرئيسية!$A$2:$E$21,4,0)","v":"18:55:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A12,الرئيسية!$A$2:$E$21,5,0))","v":0},null,0]
[12,{"$f":"VLOOKUP(A13,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-30"},{"$f":"VLOOKUP(A13,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 12"},{"$f":"VLOOKUP(A13,الرئيسية!$A$2:$E$21,4,0)","v":"20:40:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A13,الرئيسية!$A$2:$E$21,5,0))","v":0},null,0]
[13,{"$f":"VLOOKUP(A14,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-30"},{"$f":"VLOOKUP(A14,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 13"},{"$f":"VLOOKUP(A14,الرئيسية!$A$2:$E$21,4,0)","v":"20:40:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A14,الرئيسية!$A$2:$E$21,5,0))","v":2},null,2]
[14,{"$f":"VLOOKUP(A15,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-31"},{"$f":"VLOOKUP(A15,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 14"},{"$f":"VLOOKUP(A15,الرئيسية!$A$2:$E$21,4,0)","v":"18:40:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A15,الرئيسية!$A$2:$E$21,5,0))","v":3},null,3]
[15,{"$f":"VLOOKUP(A16,الرئيسية!$A$2:$E$21,2,0)","v":"2019-08-31"},{"$f":"VLOOKUP(A16,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 15"},{"$f":"VLOOKUP(A16,الرئيسية!$A$2:$E$21,4,0)","v":"19:05:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A16,الرئيسية!$A$2:$E$21,5,0))","v":4},null,4]
[16,{"$f":"VLOOKUP(A17,الرئيسية!$A$2:$E$21,2,0)","v":"2019-09-24"},{"$f":"VLOOKUP(A17,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 16"},{"$f":"VLOOKUP(A17,الرئيسية!$A$2:$E$21,4,0)","v":"19:05:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A17,الرئيسية!$A$2:$E$21,5,0))","v":0},null,0]
[17,{"$f":"VLOOKUP(A18,الرئيسية!$A$2:$E$21,2,0)","v":"2019-09-13"},{"$f":"VLOOKUP(A18,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 17"},{"$f":"VLOOKUP(A18,الرئيسية!$A$2:$E$21,4,0)","v":"18:50:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A18,الرئيسية!$A$2:$E$21,5,0))","v":""},null,5]
[18,{"$f":"VLOOKUP(A19,الرئيسية!$A$2:$E$21,2,0)","v":"2019-09-13"},{"$f":"VLOOKUP(A19,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 18"},{"$f":"VLOOKUP(A19,الرئيسية!$A$2:$E$21,4,0)","v":"18:50:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A19,الرئيسية!$A$2:$E$21,5,0))","v":3}]
[19,{"$f":"VLOOKUP(A20,الرئيسية!$A$2:$E$21,2,0)","v":"2019-09-13"},{"$f":"VLOOKUP(A20,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 19"},{"$f":"VLOOKUP(A20,الرئيسية!$A$2:$E$21,4,0)","v":"20:35:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A20,الرئيسية!$A$2:$E$21,5,0))","v":9},null,9]
[20,{"$f":"VLOOKUP(A21,الرئيسية!$A$2:$E$21,2,0)","v":"2019-09-14"},{"$f":"VLOOKUP(A21,الرئيسية!$A$2:$E$21,3,0)","v":"محمد 20"},{"$f":"VLOOKUP(A21,الرئيسية!$A$2:$E$21,4,0)","v":"18:40:00"},{"$f":"IF(Table2[[#This Row],[النتيجة]]=\"\",\"\",VLOOKUP(A21,الرئيسية!$A$2:$E$21,5,0))","v":6},null,6]
[]
[]
[]
[null,null,null,null,null,null,"النتائج المتوقعة والمطلوبة كما في العمود أعلاه"]