{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["LOOKUP Function Method","VLOOKUP Function Method","INDEX and MATCH","INDEX,SUMPRODUCT And MAX","VBA Method","Book"],"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":"LOOKUP Function Method","index":0,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,17]]}
[]
[null,"Use of LOOKUP Function",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Date","Sales Person","Sales Amt",null,"Last sale: ",{"$f":"LOOKUP(2,1/(D:D<>\"\"),D:D)","v":367},null,null,null,null,null,null,null,null,"Date","Sales Person","Sales Amt"]
[null,"2021-02-11","Ron",300,null,null,null,null,null,null,null,null,null,null,null,"2021-02-11","Ron",300]
[null,"2021-03-11","Sam",342,null,null,null,null,null,null,null,null,null,null,null,"2021-03-11","Sam",342]
[null,"2021-04-11","Bob",123,null,null,null,null,null,null,null,null,null,null,null,"2021-04-11","Bob",123]
[null,"2021-05-11","Dodd",342,null,null,null,null,null,null,null,null,null,null,null,"2021-05-11","Dodd",342]
[null,"2021-07-11","Bill",564,null,null,null,null,null,null,null,null,null,null,null,"2021-07-11","Bill",564]
[null,"2021-08-11","Budd",367,null,null,null,null,null,null,null,null,null,null,null,"2021-08-11","Budd",367]

{"sheet":"VLOOKUP Function Method","index":1,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,17]]}
[]
[null,"Use of VLOOKUP Function",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Date","Sales Person","Sales Amt",null,null,null,null,null,null,null,null,null,null,null,"Date","Sales Person","Sales Amt"]
[null,"2021-02-11","Ron",300,null,"Bob",{"$f":"VLOOKUP(F5,C5:D13,2,FALSE)","v":123},null,null,null,null,null,null,null,null,"2021-02-11","Ron",300]
[null,"2021-03-11","Ron",342,null,null,null,null,null,null,null,null,null,null,null,"2021-03-11","Sam",342]
[null,"2021-04-11","Bob",123,null,null,null,null,null,null,null,null,null,null,null,"2021-04-11","Bob",123]
[null,"2021-05-11","Bill",342,null,null,null,null,null,null,null,null,null,null,null,"2021-05-11","Dodd",342]
[null,"2021-07-11","Sam",564,null,null,null,null,null,null,null,null,null,null,null,"2021-07-11","Bill",564]
[null,"2021-08-11","Bill",367,null,null,null,null,null,null,null,null,null,null,null,"2021-08-11","Budd",367]
[null,"2021-10-11","Bob",674]
[null,"2021-11-11","Bob",563]
[null,"13/11/2021","Budd",563]

{"sheet":"INDEX and MATCH","index":2,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,15,1,17]]}
[]
[null,"Use of INDEX And MATCH Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Date","Sales Person","Sales",null,null,null,null,null,null,null,null,null,null,null,"Date","Sales Person","Sales Amt"]
[null,"2021-02-11","Ron",300,null,"Bill",{"$f":"INDEX(D5:D13,MATCH(F5,C5:C13,1))","v":367},null,null,null,null,null,null,null,null,"2021-02-11","Ron",300]
[null,"2021-03-11","Ron",342,null,null,null,null,null,null,null,null,null,null,null,"2021-03-11","Sam",342]
[null,"2021-04-11","Bob",123,null,null,null,null,null,null,null,null,null,null,null,"2021-04-11","Bob",123]
[null,"2021-05-11","Bill",342,null,null,null,null,null,null,null,null,null,null,null,"2021-05-11","Dodd",342]
[null,"2021-07-11","Bill",564,null,null,null,null,null,null,null,null,null,null,null,"2021-07-11","Bill",564]
[null,"2021-08-11","Bill",367,null,null,null,null,null,null,null,null,null,null,null,"2021-08-11","Budd",367]
[null,"2021-10-11","Bob",674]
[null,"2021-11-11","Bob",563]
[null,"13/11/2021","Budd",563]

{"sheet":"INDEX,SUMPRODUCT And MAX","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,11,1,12],[1,1,1,2]]}
[]
[null,"Use of INDEX, SUMPRODUCT & MAX Functions",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person","Sales Amt",null,null,null,null,null,null,null,null,"Sales Person","Sales Amt"]
[null,"Ron",300,null,null,null,null,null,null,null,null,"Ron",300]
[null,"Sam",342,null,null,null,null,null,null,null,null,"Sam",342]
[null,"Bob",123,null,"Bill",563,null,null,null,null,null,"Bob",123]
[null,"Dodd",342,null,null,null,null,null,null,null,null,"Dodd",342]
[null,"Bill",564,null,null,null,null,null,null,null,null,"Bill",564]
[null,"Budd",367,null,null,null,null,null,null,null,null,"Budd",367]
[null,"Ron",674,null,null,null,null,null,null,null,null,"Ron",674]
[null,"Bob",563,null,null,null,null,null,null,null,null,"Bob",563]
[null,"Bill",563,null,null,null,null,null,null,null,null,"Bill",563]

{"sheet":"VBA Method","index":4,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,15,1,16],[1,1,1,2]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person","Sales Amt",null,null,null,null,null,null,null,null,null,null,null,null,"Sales Person","Sales Amt"]
[null,"Ron",300,null,"Bill",{"$f":"LastItemLookup(E5,B5:C13,2)","v":563},null,null,null,null,null,null,null,null,null,"Ron",300]
[null,"Sam",342,null,null,null,null,null,null,null,null,null,null,null,null,"Sam",342]
[null,"Bob",123,null,null,null,null,null,null,null,null,null,null,null,null,"Bob",123]
[null,"Dodd",342,null,null,null,null,null,null,null,null,null,null,null,null,"Dodd",342]
[null,"Bill",564,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",564]
[null,"Budd",367,null,null,null,null,null,null,null,null,null,null,null,null,"Budd",367]
[null,"Ron",674,null,null,null,null,null,null,null,null,null,null,null,null,"Ron",674]
[null,"Bob",563,null,null,null,null,null,null,null,null,null,null,null,null,"Bob",563]
[null,"Bill",563,null,null,null,null,null,null,null,null,null,null,null,null,"Bill",563]

{"sheet":"Book","index":5,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Ron"]
["Sam"]
["Bob"]
["Dodd"]
["Bill"]
["Budd"]