{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Query1","Dataset (Physics)","Dataset (Math)","Consolidate","INDEX-MATCH","VLOOKUP","VBA"],"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":"Query1","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Student ID","Name.1","Marks","Name"]
[11001,"Morgan",74,"Physics"]
[11002,"Dawson",85,"Physics"]
[11003,"George",78,"Physics"]
[11004,"Smith",87,"Physics"]
[11005,"Mike",76,"Physics"]
[11006,"Henry",70,"Physics"]
[11007,"Rafael",71,"Physics"]
[11008,"Golding",80,"Physics"]
[11009,"Lessing",79,"Physics"]
[11010,"Orwell",79,"Physics"]
[11001,"Morgan",76,"Math"]
[11002,"Dawson",87,"Math"]
[11003,"George",80,"Math"]
[11004,"Smith",89,"Math"]
[11005,"Mike",78,"Math"]
[11006,"Henry",72,"Math"]
[11007,"Rafael",73,"Math"]
[11008,"Golding",82,"Math"]
[11009,"Lessing",81,"Math"]
[11010,"Orwell",81,"Math"]
[null,null,null,"Query1!ExternalData_1"]

{"sheet":"Dataset (Physics)","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Table"]
[]
[null,"Student ID","Name","Marks"]
[null,11001,"Morgan",74]
[null,11002,"Dawson",85]
[null,11003,"George",78]
[null,11004,"Smith",87]
[null,11005,"Mike",76]
[null,11006,"Henry",70]
[null,11007,"Rafael",71]
[null,11008,"Golding",80]
[null,11009,"Lessing",79]
[null,11010,"Orwell",79]

{"sheet":"Dataset (Math)","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Table"]
[]
[null,"Student ID","Name","Marks"]
[null,11001,"Morgan",76]
[null,11002,"Dawson",87]
[null,11003,"George",80]
[null,11004,"Smith",89]
[null,11005,"Mike",78]
[null,11006,"Henry",72]
[null,11007,"Rafael",73]
[null,11008,"Golding",82]
[null,11009,"Lessing",81]
[null,11010,"Orwell",81]

{"sheet":"Consolidate","index":3,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of Consolidate Feature",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Student ID","Name","Marks",null,null,null,null,"Student ID","Name","Marks"]
[null,11001,"Morgan",150,null,null,null,null,11001,"Morgan"]
[null,11002,"Dawson",172,null,null,null,null,11002,"Dawson"]
[null,11003,"George",158,null,null,null,null,11003,"George"]
[null,11004,"Smith",176,null,null,null,null,11004,"Smith"]
[null,11005,"Mike",154,null,null,null,null,11005,"Mike"]
[null,11006,"Henry",142,null,null,null,null,11006,"Henry"]
[null,11007,"Rafael",144,null,null,null,null,11007,"Rafael"]
[null,11008,"Golding",162,null,null,null,null,11008,"Golding"]
[null,11009,"Lessing",160,null,null,null,null,11009,"Lessing"]
[null,11010,"Orwell",160,null,null,null,null,11010,"Orwell"]

{"sheet":"INDEX-MATCH","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Combination of INDEX and MATCH Function",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Student ID","Name","Physics","Math",null,null,null,"Student ID","Name","Physics","Math"]
[null,11001,"Morgan",74,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D5,'Dataset (Math)'!$D$5:$D$14,0))","v":76},null,null,null,11001,"Morgan",74]
[null,11002,"Dawson",85,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D6,'Dataset (Math)'!$D$5:$D$14,0))","v":87},null,null,null,11002,"Dawson",85]
[null,11003,"George",78,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D7,'Dataset (Math)'!$D$5:$D$14,0))","v":80},null,null,null,11003,"George",78]
[null,11004,"Smith",87,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D8,'Dataset (Math)'!$D$5:$D$14,0))","v":89},null,null,null,11004,"Smith",87]
[null,11005,"Mike",76,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D9,'Dataset (Math)'!$D$5:$D$14,0))","v":78},null,null,null,11005,"Mike",76]
[null,11006,"Henry",70,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D10,'Dataset (Math)'!$D$5:$D$14,0))","v":72},null,null,null,11006,"Henry",70]
[null,11007,"Rafael",71,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D11,'Dataset (Math)'!$D$5:$D$14,0))","v":73},null,null,null,11007,"Rafael",71]
[null,11008,"Golding",80,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D12,'Dataset (Math)'!$D$5:$D$14,0))","v":82},null,null,null,11008,"Golding",80]
[null,11009,"Lessing",79,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D13,'Dataset (Math)'!$D$5:$D$14,0))","v":81},null,null,null,11009,"Lessing",79]
[null,11010,"Orwell",79,{"$f":"INDEX('Dataset (Math)'!$D$5:$D$14,MATCH('Dataset (Math)'!D14,'Dataset (Math)'!$D$5:$D$14,0))","v":81},null,null,null,11010,"Orwell",79]

{"sheet":"VLOOKUP","index":5,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Use of VLOOKUP Function",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Student ID","Name","Physics","Math",null,null,null,null,"Student ID","Name","Physics","Math"]
[null,11001,"Morgan",74,{"$f":"VLOOKUP(B5,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":76},null,null,null,null,11001,"Morgan",74]
[null,11002,"Dawson",85,{"$f":"VLOOKUP(B6,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":87},null,null,null,null,11002,"Dawson",85]
[null,11003,"George",78,{"$f":"VLOOKUP(B7,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":80},null,null,null,null,11003,"George",78]
[null,11004,"Smith",87,{"$f":"VLOOKUP(B8,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":89},null,null,null,null,11004,"Smith",87]
[null,11005,"Mike",76,{"$f":"VLOOKUP(B9,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":78},null,null,null,null,11005,"Mike",76]
[null,11006,"Henry",70,{"$f":"VLOOKUP(B10,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":72},null,null,null,null,11006,"Henry",70]
[null,11007,"Rafael",71,{"$f":"VLOOKUP(B11,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":73},null,null,null,null,11007,"Rafael",71]
[null,11008,"Golding",80,{"$f":"VLOOKUP(B12,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":82},null,null,null,null,11008,"Golding",80]
[null,11009,"Lessing",79,{"$f":"VLOOKUP(B13,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":81},null,null,null,null,11009,"Lessing",79]
[null,11010,"Orwell",79,{"$f":"VLOOKUP(B14,'Dataset (Math)'!$B$5:$D$14,3,FALSE)","v":81},null,null,null,null,11010,"Orwell",79]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of VBA "]
[]
[null,"Student ID","Name","Physics","Math"]
[null,11001,"Morgan",74,76]
[null,11002,"Dawson",85,87]
[null,11003,"George",78,80]
[null,11004,"Smith",87,89]
[null,11005,"Mike",76,78]
[null,11006,"Henry",70,72]
[null,11007,"Rafael",71,73]
[null,11008,"Golding",80,82]
[null,11009,"Lessing",79,81]
[null,11010,"Orwell",79,81]