{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,1,3],[3,5,3,7],[1,5,2,9],[4,6,4,7]]}
[]
["حركة العملاء عن شهر يناير 2021",null,null,null,null,"اساتذتي الكرام      اريد عمل كشف الحساب باستخدام دالة    xlookup"]
["رقم العملية","اسم العميل","المبلغ","التاريخ"]
[1,"عميل 1",1000,"2021-01-01",null,"كشف حساب عميل"]
[2,"عميل 2",1020,"2021-01-05",null,"العميل المطلوب","عميل 2"]
[3,"عميل 3",1040,"2021-01-08"]
[4,"عميل 4",1060,"2021-01-10",null,"رقم العملية","المبلغ","التاريخ"]
[5,"عميل 1",1080,"2021-01-10",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":2},{"$f":"IF(F8<>\"\",VLOOKUP(F8,A:D,3,0),\"\")","v":1020},{"$f":"IF(F8<>\"\",VLOOKUP(F8,A:D,4,0),\"\")","v":"2021-01-05"}]
[6,"عميل 2",1100,"2021-01-12",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":6},{"$f":"IF(F9<>\"\",VLOOKUP(F9,A:D,3,0),\"\")","v":1100},{"$f":"IF(F9<>\"\",VLOOKUP(F9,A:D,4,0),\"\")","v":"2021-01-12"}]
[7,"عميل 2",1120,"2021-01-14",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":7},1120,"2021-01-14"]
[8,"عميل 3",1140,"2021-01-14",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":14},1260,"2021-01-29"]
[9,"عميل 4",1160,"2021-01-20",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":""},"",""]
[10,"عميل 1",1180,"2021-01-20",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":""},"",""]
[11,"عميل 4",1200,"2021-01-22",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":""},"",""]
[12,"عميل 3",1220,"2021-01-25",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":""},"",""]
[13,"عميل 1",1240,"2021-01-27",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":""},"",""]
[14,"عميل 2",1260,"2021-01-29",null,{"$f":"IFERROR(INDEX(A:A,SMALL(IF($B$4:$B$30=$G$5,ROW($A$4:$A$30),10^10),ROW()-7)),\"\")","v":""},"",""]
[15,"عميل 4",1280,"2021-01-30"]