{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","VLOOKUP Function","XLOOKUP Function","INDEX and MATCH","Power Query","Table1","Copy-Paste Feature","Excel VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Dataset","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset"]
[]
[null,"Product Name","Cost Price",null,"Product Name","Profit"]
[null,"Keyboard",79,null,"Keyboard",3]
[null,"Mouse",11,null,"Mouse",2]
[null,"Hard disk",132,null,"Hard disk",40]
[null,"Router",68,null,"Router",13]
[null,"Surge Protector",27,null,"Surge Protector",4]
[null,"Graphics Card",229,null,"Graphics Card",50]

{"sheet":"VLOOKUP Function","index":1,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,12,1,16],[1,1,1,6]]}
[]
[null,"Use of VLOOKUP Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Cost Price",null,"Product Name","Profit",{"$f":"VLOOKUP(E4,$B$4:$C$10,2,\nFALSE)","v":"Cost Price"},null,null,null,null,null,"Product Name","Cost Price",null,"Product Name","Profit"]
[null,"Keyboard",79,null,"Keyboard",3,{"$f":"VLOOKUP(E5,$B$4:$C$10,2,\nFALSE)","v":79},null,null,null,null,null,"Keyboard",79,null,"Keyboard",3]
[null,"Mouse",11,null,"Mouse",2,11,null,null,null,null,null,"Mouse",11,null,"Mouse",2]
[null,"Hard disk",132,null,"Hard disk",40,132,null,null,null,null,null,"Hard disk",132,null,"Hard disk",40]
[null,"Router",68,null,"Router",13,68,null,null,null,null,null,"Router",68,null,"Router",13]
[null,"Surge Protector",27,null,"Surge Protector",4,27,null,null,null,null,null,"Surge Protector",27,null,"Surge Protector",4]
[null,"Graphics Card",229,null,"Graphics Card",50,229,null,null,null,null,null,"Graphics Card",229,null,"Graphics Card",50]

{"sheet":"XLOOKUP Function","index":2,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,12,1,16],[1,1,1,6]]}
[]
[null,"Use of XLOOKUP Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Cost Price",null,"Product Name","Profit",{"$f":"_xlfn.XLOOKUP(E4,$B$4:$B$10,\n$C$4:$C$10)","v":"Cost Price"},null,null,null,null,null,"Product Name","Cost Price",null,"Product Name","Profit"]
[null,"Keyboard",79,null,"Keyboard",3,{"$f":"_xlfn.XLOOKUP(E5,$B$4:$B$10,\n$C$4:$C$10)","v":79},null,null,null,null,null,"Keyboard",79,null,"Keyboard",3]
[null,"Mouse",11,null,"Mouse",2,11,null,null,null,null,null,"Mouse",11,null,"Mouse",2]
[null,"Hard disk",132,null,"Hard disk",40,132,null,null,null,null,null,"Hard disk",132,null,"Hard disk",40]
[null,"Router",68,null,"Router",13,68,null,null,null,null,null,"Router",68,null,"Router",13]
[null,"Surge Protector",27,null,"Surge Protector",4,27,null,null,null,null,null,"Surge Protector",27,null,"Surge Protector",4]
[null,"Graphics Card",229,null,"Graphics Card",50,229,null,null,null,null,null,"Graphics Card",229,null,"Graphics Card",50]

{"sheet":"INDEX and MATCH","index":3,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,12,1,16],[1,1,1,6]]}
[]
[null,"Combination of INDEX and MATCH Functions",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Cost Price",null,"Product Name","Profit",{"$f":"INDEX($C$4:$C$10,\nMATCH($E4,$B$4:$B$10,0))","v":"Cost Price"},null,null,null,null,null,"Product Name","Cost Price",null,"Product Name","Profit"]
[null,"Keyboard",79,null,"Keyboard",3,{"$f":"INDEX($C$4:$C$10,\nMATCH($E5,$B$4:$B$10,0))","v":79},null,null,null,null,null,"Keyboard",79,null,"Keyboard",3]
[null,"Mouse",11,null,"Mouse",2,11,null,null,null,null,null,"Mouse",11,null,"Mouse",2]
[null,"Hard disk",132,null,"Hard disk",40,132,null,null,null,null,null,"Hard disk",132,null,"Hard disk",40]
[null,"Router",68,null,"Router",13,68,null,null,null,null,null,"Router",68,null,"Router",13]
[null,"Surge Protector",27,null,"Surge Protector",4,27,null,null,null,null,null,"Surge Protector",27,null,"Surge Protector",4]
[null,"Graphics Card",229,null,"Graphics Card",50,229,null,null,null,null,null,"Graphics Card",229,null,"Graphics Card",50]

{"sheet":"Power Query","index":4,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Power Query"]
[]
[null,"Product Name","Cost Price",null,"Product Name","Profit"]
[null,"Keyboard",79,null,"Keyboard",3]
[null,"Mouse",11,null,"Mouse",2]
[null,"Hard disk",132,null,"Hard disk",40]
[null,"Router",68,null,"Router",13]
[null,"Surge Protector",27,null,"Surge Protector",4]
[null,"Graphics Card",229,null,"Graphics Card",50]
[]
[null,"Product Name","Profit","Cost Price"]
[null,"Keyboard",3,79]
[null,"Mouse",2,11]
[null,"Hard disk",40,132]
[null,"Router",13,68]
[null,"Surge Protector",4,27]
[null,"Graphics Card",50,229]

{"sheet":"Table1","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Product Name","Cost Price"]
["Keyboard",79]
["Mouse",11]
["Hard disk",132]
["Router",68]
["Surge Protector",27]
["Graphics Card",229]

{"sheet":"Copy-Paste Feature","index":6,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,12,1,16],[1,1,1,6]]}
[]
[null,"Use of Copy-Paste Feature",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Cost Price",null,"Product Name","Profit","Cost Price",null,null,null,null,null,"Product Name","Cost Price",null,"Product Name","Profit"]
[null,"Keyboard",79,null,"Keyboard",3,79,null,null,null,null,null,"Keyboard",79,null,"Keyboard",3]
[null,"Mouse",11,null,"Mouse",2,11,null,null,null,null,null,"Mouse",11,null,"Mouse",2]
[null,"Hard disk",132,null,"Hard disk",40,132,null,null,null,null,null,"Hard disk",132,null,"Hard disk",40]
[null,"Router",68,null,"Router",13,68,null,null,null,null,null,"Router",68,null,"Router",13]
[null,"Surge Protector",27,null,"Surge Protector",4,27,null,null,null,null,null,"Surge Protector",27,null,"Surge Protector",4]
[null,"Graphics Card",229,null,"Graphics Card",50,229,null,null,null,null,null,"Graphics Card",229,null,"Graphics Card",50]

{"sheet":"Excel VBA","index":7,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,12,1,16],[1,1,1,6]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Cost Price",null,"Product Name","Profit","Cost Price",null,null,null,null,null,"Product Name","Cost Price",null,"Product Name","Profit"]
[null,"Keyboard",79,null,"Keyboard",3,79,null,null,null,null,null,"Keyboard",79,null,"Keyboard",3]
[null,"Mouse",11,null,"Mouse",2,11,null,null,null,null,null,"Mouse",11,null,"Mouse",2]
[null,"Hard disk",132,null,"Hard disk",40,132,null,null,null,null,null,"Hard disk",132,null,"Hard disk",40]
[null,"Router",68,null,"Router",13,68,null,null,null,null,null,"Router",68,null,"Router",13]
[null,"Surge Protector",27,null,"Surge Protector",4,27,null,null,null,null,null,"Surge Protector",27,null,"Surge Protector",4]
[null,"Graphics Card",229,null,"Graphics Card",50,229,null,null,null,null,null,"Graphics Card",229,null,"Graphics Card",50]