{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["VBA Lookup Function","Dataset 1","Cell Reference","User Input","Range of Lookup Values","Dataset 2","Grades Based on Marks","Another Worksheet","Another Workbook"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"VBA Lookup Function","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,3,22,5],[19,1,22,1],[19,2,22,2],[1,1,1,5],[3,1,3,5],[4,1,4,5],[18,3,18,5]]}
[]
[null,"VBA Lookup Function in Excel"]
[]
[null,"The VBA Lookup function finds a value from a one-row or a one-column range"]
[null,"WorksheetFunction.Lookup(Arg1,Arg2,[Arg3])"]
[]
[null,"Company","Product","Screen Size (inches)","Weight","Price"]
[null,"HP","250 G6",15.6,"1.86kg",575]
[null,"Acer","Aspire 3",15.6,"2.1kg",400]
[null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",499]
[null,"Dell","Inspiron 3567",15.6,"2.2kg",498.9]
[null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",999]
[null,"Apple","MacBook Pro",13.3,"1.37kg",1339.69]
[null,"Acer","Swift 3",14,"1.6kg",770]
[null,"Asus","Vivobook E200HA",11.6,"0.98kg",191.9]
[null,"Dell","XPS 13",13.3,"1.22kg",979]
[null,"Asus","ZenBook UX430UN",14,"1.3kg",1495]
[]
[null,"Product","Price","Explanation"]
[null,"MacBook Pro",1339.69,"Returns the \"Price\" of the \"Product\" (lookup  value) from the result_vector (Range F8:F17) after comparing the lookup value with the lookup_vector (Range C8:C17)."]

{"sheet":"Dataset 1","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Laptop Prices in Micro Center Store"]
[]
[null,"Company","Product","Screen Size (inches)","Weight","Price"]
[null,"Asus","ZenBook UX430UN",14,"1.3kg",1495]
[null,"Dell","XPS 13",13.3,"1.22kg",979]
[null,"Asus","Vivobook E200HA",11.6,"0.98kg",191.9]
[null,"Acer","Swift 3",14,"1.6kg",770]
[null,"Apple","MacBook Pro",13.3,"1.37kg",1339.69]
[null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",999]
[null,"Dell","Inspiron 3567",15.6,"2.2kg",498.9]
[null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",499]
[null,"Acer","Aspire 3",15.6,"2.1kg",400]
[null,"HP","250 G6",15.6,"1.86kg",575]

{"sheet":"Cell Reference","index":2,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using Cell Reference as Lookup Value",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Company","Product","Screen Size (inches)","Weight","Price",null,null,null,null,"Company","Product","Screen Size (inches)","Weight","Price"]
[null,"HP","250 G6",15.6,"1.86kg",575,null,null,null,null,"HP","250 G6",15.6,"1.86kg",575]
[null,"Acer","Aspire 3",15.6,"2.1kg",400,null,null,null,null,"Acer","Aspire 3",15.6,"2.1kg",400]
[null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",499,null,null,null,null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",499]
[null,"Dell","Inspiron 3567",15.6,"2.2kg",498.9,null,null,null,null,"Dell","Inspiron 3567",15.6,"2.2kg",498.9]
[null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",999,null,null,null,null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",999]
[null,"Apple","MacBook Pro",13.3,"1.37kg",1339.69,null,null,null,null,"Apple","MacBook Pro",13.3,"1.37kg",1339.69]
[null,"Acer","Swift 3",14,"1.6kg",770,null,null,null,null,"Acer","Swift 3",14,"1.6kg",770]
[null,"Asus","Vivobook E200HA",11.6,"0.98kg",191.9,null,null,null,null,"Asus","Vivobook E200HA",11.6,"0.98kg",191.9]
[null,"Dell","XPS 13",13.3,"1.22kg",979,null,null,null,null,"Dell","XPS 13",13.3,"1.22kg",979]
[null,"Asus","ZenBook UX430UN",14,"1.3kg",1495,null,null,null,null,"Asus","ZenBook UX430UN",14,"1.3kg",1495]
[]
[null,"Product","Price",null,null,null,null,null,null,null,"Product","Price"]
[null,"MacBook Pro",1339.69]

{"sheet":"User Input","index":3,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using Cell Reference as Lookup Value",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Company","Product","Screen Size (inches)","Weight","Price",null,null,null,null,null,"Company","Product","Screen Size (inches)","Weight","Price"]
[null,"HP","250 G6",15.6,"1.86kg",575,null,null,null,null,null,"HP","250 G6",15.6,"1.86kg",575]
[null,"Acer","Aspire 3",15.6,"2.1kg",400,null,null,null,null,null,"Acer","Aspire 3",15.6,"2.1kg",400]
[null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",499,null,null,null,null,null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",499]
[null,"Dell","Inspiron 3567",15.6,"2.2kg",498.9,null,null,null,null,null,"Dell","Inspiron 3567",15.6,"2.2kg",498.9]
[null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",999,null,null,null,null,null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",999]
[null,"Apple","MacBook Pro",13.3,"1.37kg",1339.69,null,null,null,null,null,"Apple","MacBook Pro",13.3,"1.37kg",1339.69]
[null,"Acer","Swift 3",14,"1.6kg",770,null,null,null,null,null,"Acer","Swift 3",14,"1.6kg",770]
[null,"Asus","Vivobook E200HA",11.6,"0.98kg",191.9,null,null,null,null,null,"Asus","Vivobook E200HA",11.6,"0.98kg",191.9]
[null,"Dell","XPS 13",13.3,"1.22kg",979,null,null,null,null,null,"Dell","XPS 13",13.3,"1.22kg",979]
[null,"Asus","ZenBook UX430UN",14,"1.3kg",1495,null,null,null,null,null,"Asus","ZenBook UX430UN",14,"1.3kg",1495]
[]
[null,"Price",null,null,null,null,null,null,null,null,null,"Price"]
[null,1339.69]

{"sheet":"Range of Lookup Values","index":4,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Employing a Range of Lookup Values",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Company","Product","Screen Size (inches)","Weight","Price",null,null,null,null,null,"Company","Product","Screen Size (inches)","Weight","Price"]
[null,"HP","250 G6",15.6,"1.86kg",575,null,null,null,null,null,"HP","250 G6",15.6,"1.86kg",575]
[null,"Acer","Aspire 3",15.6,"2.1kg",400,null,null,null,null,null,"Acer","Aspire 3",15.6,"2.1kg",400]
[null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",499,null,null,null,null,null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",499]
[null,"Dell","Inspiron 3567",15.6,"2.2kg",498.9,null,null,null,null,null,"Dell","Inspiron 3567",15.6,"2.2kg",498.9]
[null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",999,null,null,null,null,null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",999]
[null,"Apple","MacBook Pro",13.3,"1.37kg",1339.69,null,null,null,null,null,"Apple","MacBook Pro",13.3,"1.37kg",1339.69]
[null,"Acer","Swift 3",14,"1.6kg",770,null,null,null,null,null,"Acer","Swift 3",14,"1.6kg",770]
[null,"Asus","Vivobook E200HA",11.6,"0.98kg",191.9,null,null,null,null,null,"Asus","Vivobook E200HA",11.6,"0.98kg",191.9]
[null,"Dell","XPS 13",13.3,"1.22kg",979,null,null,null,null,null,"Dell","XPS 13",13.3,"1.22kg",979]
[null,"Asus","ZenBook UX430UN",14,"1.3kg",1495,null,null,null,null,null,"Asus","ZenBook UX430UN",14,"1.3kg",1495]
[]
[null,"Product","Price",null,null,null,null,null,null,null,null,"Product","Price"]
[null,"MacBook Pro",1339.69]
[null,"Inspiron 3567",498.9]
[null,"XPS 13",979]

{"sheet":"Dataset 2","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Grading System of XYZ School"]
[]
[null,"Minimum Marks","Allotted Grade"]
[null,40,"D"]
[null,50,"C"]
[null,60,"B-"]
[null,70,"B"]
[null,80,"A-"]
[null,90,"A"]

{"sheet":"Grades Based on Marks","index":6,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Calculating Grades Based on Obtained Marks",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Minimum Marks","Allotted Grade",null,null,null,null,null,null,"Minimum Marks","Allotted Grade"]
[null,0,"F",null,null,null,null,null,null,0,"F"]
[null,40,"D",null,null,null,null,null,null,40,"D"]
[null,50,"C",null,null,null,null,null,null,50,"C"]
[null,60,"B-",null,null,null,null,null,null,60,"B-"]
[null,70,"B",null,null,null,null,null,null,70,"B"]
[null,80,"A-",null,null,null,null,null,null,80,"A-"]
[null,90,"A",null,null,null,null,null,null,90,"A"]
[]
[null,"Obtained Marks","Achieved Grade",null,null,null,null,null,null,"Obtained Marks","Achieved Grade"]
[null,87,"A-"]

{"sheet":"Another Worksheet","index":7,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Extracting Value from Another Worksheet",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Company","Product","Screen Size (inches)","Weight",null,null,null,null,null,"Company","Product","Screen Size (inches)","Weight"]
[null,"HP","250 G6",15.6,"1.86kg",null,null,null,null,null,"HP","250 G6",15.6,"1.86kg"]
[null,"Acer","Aspire 3",15.6,"2.1kg",null,null,null,null,null,"Acer","Aspire 3",15.6,"2.1kg"]
[null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",null,null,null,null,null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg"]
[null,"Dell","Inspiron 3567",15.6,"2.2kg",null,null,null,null,null,"Dell","Inspiron 3567",15.6,"2.2kg"]
[null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",null,null,null,null,null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg"]
[null,"Apple","MacBook Pro",13.3,"1.37kg",null,null,null,null,null,"Apple","MacBook Pro",13.3,"1.37kg"]
[null,"Acer","Swift 3",14,"1.6kg",null,null,null,null,null,"Acer","Swift 3",14,"1.6kg"]
[null,"Asus","Vivobook E200HA",11.6,"0.98kg",null,null,null,null,null,"Asus","Vivobook E200HA",11.6,"0.98kg"]
[null,"Dell","XPS 13",13.3,"1.22kg",null,null,null,null,null,"Dell","XPS 13",13.3,"1.22kg"]
[null,"Asus","ZenBook UX430UN",14,"1.3kg",null,null,null,null,null,"Asus","ZenBook UX430UN",14,"1.3kg"]
[]
[null,"Product","Price",null,null,null,null,null,null,null,"Product","Price"]
[null,"Inspiron 3567",498.9]

{"sheet":"Another Workbook","index":8,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Extracting Value from Another Workbook",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Company","Product","Screen Size (inches)","Weight",null,null,null,null,null,"Company","Product","Screen Size (inches)","Weight"]
[null,"HP","250 G6",15.6,"1.86kg",null,null,null,null,null,"HP","250 G6",15.6,"1.86kg"]
[null,"Acer","Aspire 3",15.6,"2.1kg",null,null,null,null,null,"Acer","Aspire 3",15.6,"2.1kg"]
[null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg",null,null,null,null,null,"Lenovo","IdeaPad 320-15IKB",15.6,"2.2kg"]
[null,"Dell","Inspiron 3567",15.6,"2.2kg",null,null,null,null,null,"Dell","Inspiron 3567",15.6,"2.2kg"]
[null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg",null,null,null,null,null,"Lenovo","Legion Y520-15IKBN",15.6,"2.5kg"]
[null,"Apple","MacBook Pro",13.3,"1.37kg",null,null,null,null,null,"Apple","MacBook Pro",13.3,"1.37kg"]
[null,"Acer","Swift 3",14,"1.6kg",null,null,null,null,null,"Acer","Swift 3",14,"1.6kg"]
[null,"Asus","Vivobook E200HA",11.6,"0.98kg",null,null,null,null,null,"Asus","Vivobook E200HA",11.6,"0.98kg"]
[null,"Dell","XPS 13",13.3,"1.22kg",null,null,null,null,null,"Dell","XPS 13",13.3,"1.22kg"]
[null,"Asus","ZenBook UX430UN",14,"1.3kg",null,null,null,null,null,"Asus","ZenBook UX430UN",14,"1.3kg"]
[]
[null,"Product","Price",null,null,null,null,null,null,null,"Product","Price"]
[null,"Vivobook E200HA",210]