{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INDEX-MATCH","اسم الصنف وسعره وكوده"],"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-MATCH","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,1,18,6]]}
[]
[null,"LIST1",null,"بدون تكرار"]
[null,"Ahmed",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D2, $B$3:$B$15), 0)),\"\")","v":"Ahmed"}]
[null,"Mohamed",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D3, $B$3:$B$15), 0)),\"\")","v":"Mohamed"}]
[null,"Omar",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D4, $B$3:$B$15), 0)),\"\")","v":"Omar"}]
[null,"Ahmed",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D5, $B$3:$B$15), 0)),\"\")","v":"Samir"}]
[null,"Samir",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D6, $B$3:$B$15), 0)),\"\")","v":"Fouad"}]
[null,"Omar",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D7, $B$3:$B$15), 0)),\"\")","v":"Nehad"}]
[null,"Fouad",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D8, $B$3:$B$15), 0)),\"\")","v":"Ali"}]
[null,"Nehad",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D9, $B$3:$B$15), 0)),\"\")","v":""}]
[null,"Fouad",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D10, $B$3:$B$15), 0)),\"\")","v":""}]
[null,"Samir",null,{"$f":"IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D11, $B$3:$B$15), 0)),\"\")","v":""}]
[null,"Mohamed"]
[null,"Ali"]
[null,"Ali"]
[]
[null,"=IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D2, $B$3:$B$15), 0)),\"\")"]

{"sheet":"اسم الصنف وسعره وكوده","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,8,0,10],[5,5,7,6]]}
["م","كود الصنف","اسم الصنف","سعر الصنف",null,null,null,null,"جلب اسم الصنف والسعر من الكود -بالمعادلات"]
[1,132650,"مروحة بوكس فريش",200,null,null,null,null,"كود الصنف","اسم الصنف","سعر الصنف"]
[2,6952305,"مروحة استاند 18 بوصة",380,null,null,null,null,132650,{"$f":"IFERROR(VLOOKUP(I3,$B$2:$C$8,2,0),\"\")","v":"مروحة بوكس فريش"},{"$f":"IFERROR(VLOOKUP(I3,$B$2:$D$8,3,0),\"\")","v":200}]
[3,1326520,"ثلاجة كريازى 14 قدم",3500,null,null,null,null,132650,{"$f":"IFERROR(VLOOKUP(I4,$B$2:$C$8,2,0),\"\")","v":"مروحة بوكس فريش"},{"$f":"IFERROR(VLOOKUP(I4,$B$2:$D$8,3,0),\"\")","v":200}]
[4,6598231,"غسالة أطباق زانوسى",2800,null,null,null,null,1326520,"ثلاجة كريازى 14 قدم",3500]
[5,852640,"فرن كهربائى",1800,null,"بمجرد اختيار الكود من القائمة\nيظهر اسم الصنف وسعره",null,null,null,"",""]
[6,953281,"مروحة سقف ناشيونال",250,null,null,null,null,null,"",""]
[7,652871,"بوتاجاز كريازى 60x90",3800,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]