{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","ورقة2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"ورقة1","index":0,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,3,13,3]]}
["الكمية","الصنف","السعر "]
[2,"ثلاجة 2",{"$f":"IFERROR(VLOOKUP($B2,ورقة2!$B$2:$C$24,2,0)*$A2,0)","v":10000},"المطلوب تفعيل دالة vlookup على كامل ال range الملون بالاصفر  بطريقة الاكواد وان تظهر النتيجة  تلقائيا بدون اضافة زر للماكرو "]
[5,"ثلاجة",{"$f":"IFERROR(VLOOKUP($B3,ورقة2!$B$2:$C$24,2,0)*$A3,0)","v":20000}]
[3,"ثلاجة 3",{"$f":"IFERROR(VLOOKUP($B4,ورقة2!$B$2:$C$24,2,0)*$A4,0)","v":18000}]
[null,null,{"$f":"IFERROR(VLOOKUP($B5,ورقة2!$B$2:$C$24,2,0)*$A5,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B6,ورقة2!$B$2:$C$24,2,0)*$A6,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B7,ورقة2!$B$2:$C$24,2,0)*$A7,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B8,ورقة2!$B$2:$C$24,2,0)*$A8,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B9,ورقة2!$B$2:$C$24,2,0)*$A9,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B10,ورقة2!$B$2:$C$24,2,0)*$A10,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B11,ورقة2!$B$2:$C$24,2,0)*$A11,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B12,ورقة2!$B$2:$C$24,2,0)*$A12,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B13,ورقة2!$B$2:$C$24,2,0)*$A13,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B14,ورقة2!$B$2:$C$24,2,0)*$A14,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B15,ورقة2!$B$2:$C$24,2,0)*$A15,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B16,ورقة2!$B$2:$C$24,2,0)*$A16,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B17,ورقة2!$B$2:$C$24,2,0)*$A17,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B18,ورقة2!$B$2:$C$24,2,0)*$A18,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B19,ورقة2!$B$2:$C$24,2,0)*$A19,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B20,ورقة2!$B$2:$C$24,2,0)*$A20,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B21,ورقة2!$B$2:$C$24,2,0)*$A21,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B22,ورقة2!$B$2:$C$24,2,0)*$A22,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B23,ورقة2!$B$2:$C$24,2,0)*$A23,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B24,ورقة2!$B$2:$C$24,2,0)*$A24,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B25,ورقة2!$B$2:$C$24,2,0)*$A25,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B26,ورقة2!$B$2:$C$24,2,0)*$A26,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B27,ورقة2!$B$2:$C$24,2,0)*$A27,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B28,ورقة2!$B$2:$C$24,2,0)*$A28,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B29,ورقة2!$B$2:$C$24,2,0)*$A29,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B30,ورقة2!$B$2:$C$24,2,0)*$A30,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B31,ورقة2!$B$2:$C$24,2,0)*$A31,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B32,ورقة2!$B$2:$C$24,2,0)*$A32,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B33,ورقة2!$B$2:$C$24,2,0)*$A33,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B34,ورقة2!$B$2:$C$24,2,0)*$A34,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B35,ورقة2!$B$2:$C$24,2,0)*$A35,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B36,ورقة2!$B$2:$C$24,2,0)*$A36,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B37,ورقة2!$B$2:$C$24,2,0)*$A37,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B38,ورقة2!$B$2:$C$24,2,0)*$A38,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B39,ورقة2!$B$2:$C$24,2,0)*$A39,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B40,ورقة2!$B$2:$C$24,2,0)*$A40,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B41,ورقة2!$B$2:$C$24,2,0)*$A41,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B42,ورقة2!$B$2:$C$24,2,0)*$A42,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B43,ورقة2!$B$2:$C$24,2,0)*$A43,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B44,ورقة2!$B$2:$C$24,2,0)*$A44,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B45,ورقة2!$B$2:$C$24,2,0)*$A45,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B46,ورقة2!$B$2:$C$24,2,0)*$A46,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B47,ورقة2!$B$2:$C$24,2,0)*$A47,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B48,ورقة2!$B$2:$C$24,2,0)*$A48,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B49,ورقة2!$B$2:$C$24,2,0)*$A49,0)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP($B50,ورقة2!$B$2:$C$24,2,0)*$A50,0)","v":0}]

{"sheet":"ورقة2","index":1,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"الصنف","السعر "]
[null,"ثلاجة",4000]
[null,"ثلاجة 2",5000]
[null,"ثلاجة 3",6000]