{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Overview ","VLOOKUP & IFERROR","IF Formul","IF, ISNA & VLOOKUP Functions","IFERROR, VLOOKUP & COLUMN","Data Consolidate","VBA Code","Practice Dataset"],"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":"Dataset","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,6],[1,8,1,9]]}
[]
[null,"Dataset 1",null,null,"Dataset 2",null,null,null,"Dataset 3"]
[]
[null,"Product Name","Price",null,"Sold Product","Price","Number of Selling Product",null,"Product List 1","Product List 2"]
[null,"Shampoo",760,null,"Shampoo",760,16,null,"Shampoo","Face Wash"]
[null,"Conditioner",650,null,"Body lotion",380,6,null,"Conditioner","Shampoo"]
[null,"Body lotion",380,null,"Night Cream",550,8,null,"Body lotion","Baby Oil"]
[null,"Night Cream",550,null,"Baby Powder",280,12,null,"Night Cream","Day Cream"]
[null,"Day Cream",400,null,"Face Wash",399,27,null,"Lipstick","Makeup"]
[null,"Baby Powder",280,null,null,null,null,null,"Baby Powder","Body Soap"]
[null,"Body Soap",460,null,null,null,null,null,"Day Cream","Winter Cream"]
[null,"Face Wash",399,null,null,null,null,null,"Face Wash","Night Cream"]

{"sheet":"Overview ","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,6]]}
[]
[null,"Dataset 1",null,null,"Dataset 2",null,null,null,"Aligned Dataset"]
[]
[null,"Product Name","Price",null,"Sold Product","Price","Sales Quantity",null,"Product Name"]
[null,"Shampoo",760,null,"Shampoo",760,16,null,{"$f":"IFERROR(VLOOKUP(B5,$E:$G,1,0),\"\")","v":"Shampoo"}]
[null,"Conditioner",650,null,"Body lotion",380,6,null,{"$f":"_xlfn.FORMULATEXT(I5)","v":"=IFERROR(VLOOKUP(B5,$E:$G,1,0),\"\")"}]
[null,"Body lotion",380,null,"Night Cream",550,8]
[null,"Night Cream",550,null,"Baby Powder",280,12,null,"Price"]
[null,"Day Cream",400,null,"Face Wash",399,27,null,{"$f":"IFERROR(VLOOKUP(B5,$E:$G,2,0),\"\")","v":760}]
[null,"Baby Powder",280,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I9)","v":"=IFERROR(VLOOKUP(B5,$E:$G,2,0),\"\")"}]
[null,"Body Soap",460]
[null,"Face Wash",399,null,null,null,null,null,"Sales Quantity"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B5,$E:$G,3,0),\"\")","v":16}]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I13)","v":"=IFERROR(VLOOKUP(B5,$E:$G,3,0),\"\")"}]

{"sheet":"VLOOKUP & IFERROR","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,6],[1,8,1,10]]}
[]
[null,"Dataset 1",null,null,"Dataset 2",null,null,null,"Aligned Dataset"]
[]
[null,"Product Name","Price",null,"Sold Product","Price","Number of Selling Product",null,"Product Name","Price","Number of Selling Product"]
[null,"Shampoo",760,null,"Shampoo",760,16,null,{"$f":"IFERROR(VLOOKUP(B5,$E:$G,1,0),\"\")","v":"Shampoo"},{"$f":"IFERROR(VLOOKUP(B5,$E:$G,2,0),\"\")","v":760},{"$f":"IFERROR(VLOOKUP(B5,$E:$G,3,0),\"\")","v":16}]
[null,"Conditioner",650,null,"Body lotion",380,6,null,{"$f":"IFERROR(VLOOKUP(B6,$E:$G,1,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,$E:$G,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,$E:$G,3,0),\"\")","v":""}]
[null,"Body lotion",380,null,"Night Cream",550,8,null,"Body lotion",380,6]
[null,"Night Cream",550,null,"Baby Powder",280,12,null,"Night Cream",550,8]
[null,"Day Cream",400,null,"Face Wash",399,27,null,"","",""]
[null,"Baby Powder",280,null,null,null,null,null,"Baby Powder",280,{"$f":"IFERROR(VLOOKUP(B10,$E:$G,3,0),\"\")","v":12}]
[null,"Body Soap",460,null,null,null,null,null,"","",""]
[null,"Face Wash",399,null,null,null,null,null,"Face Wash",399,27]

{"sheet":"IF Formul","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Combined Functions"]
[]
[null,"Product List 1","Product List 2",null,"Aligned Dataset"]
[null,"Shampoo","Face Wash",null,{"$f":"IF(ISNA(MATCH(B5,$C$5:$C$12,0)),\"\",INDEX($C$5:$C$12,MATCH(B5,$C$5:$C$12,0)))","v":"Shampoo"}]
[null,"Conditioner","Shampoo",null,{"$f":"IF(ISNA(MATCH(B6,$C$5:$C$12,0)),\"\",INDEX($C$5:$C$12,MATCH(B6,$C$5:$C$12,0)))","v":""}]
[null,"Body lotion","Baby Oil",null,""]
[null,"Night Cream","Day Cream",null,"Night Cream"]
[null,"Lipstick","Makeup",null,""]
[null,"Baby Powder","Body Soap",null,""]
[null,"Day Cream","Winter Cream",null,"Day Cream"]
[null,"Face Wash","Night Cream",null,"Face Wash"]

{"sheet":"IF, ISNA & VLOOKUP Functions","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining IF, ISNA & VLOOKUP Functions"]
[]
[null,"Product List 1","Product List 2",null,"Aligned Dataset"]
[null,"Shampoo","Face Wash",null,{"$f":"IF(ISNA(VLOOKUP(B5,$C$5:$C$12,1,0)),\"\",VLOOKUP(B5,$C$5:$C$12,1,0))","v":"Shampoo"}]
[null,"Conditioner","Shampoo",null,{"$f":"IF(ISNA(VLOOKUP(B6,$C$5:$C$12,1,0)),\"\",VLOOKUP(B6,$C$5:$C$12,1,0))","v":""}]
[null,"Body lotion","Baby Oil",null,""]
[null,"Night Cream","Day Cream",null,"Night Cream"]
[null,"Lipstick","Makeup",null,""]
[null,"Baby Powder","Body Soap",null,""]
[null,"Day Cream","Winter Cream",null,"Day Cream"]
[null,"Face Wash","Night Cream",null,"Face Wash"]

{"sheet":"IFERROR, VLOOKUP & COLUMN","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Merging IFERROR, VLOOKUP & COLUMN Functions"]
[]
[null,"Product List 1","Product List 2",null,"Aligned Dataset"]
[null,"Shampoo","Face Wash",null,{"$f":"IFERROR(VLOOKUP(B5,$C$5:$C$12,COLUMN()-COLUMN($E5)+1,0),\"\")","v":"Shampoo"}]
[null,"Conditioner","Shampoo",null,{"$f":"IFERROR(VLOOKUP(B6,$C$5:$C$12,COLUMN()-COLUMN($E6)+1,0),\"\")","v":""}]
[null,"Body lotion","Baby Oil",null,""]
[null,"Night Cream","Day Cream",null,"Night Cream"]
[null,"Lipstick","Makeup",null,""]
[null,"Baby Powder","Body Soap",null,""]
[null,"Day Cream","Winter Cream",null,"Day Cream"]
[null,"Face Wash","Night Cream",null,"Face Wash"]

{"sheet":"Data Consolidate","index":6,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Consolidate Feature"]
[]
[null,"Sold Product","Price",null,"Sold Product","Price"]
[null,"Shampoo",760,null,"Shampoo",960]
[null,"Conditioner",650,null,"Body lotion",630]
[null,"Body lotion",380,null,"Night Cream",580]
[null,"Night Cream",550,null,"Baby Powder",1550]
[null,"Day Cream",400,null,"Face Wash",1400]
[null,"Baby Powder",280]
[null,"Body Soap",460]
[null,"Face Wash",399]
[]
[null," Product Name","Total Sales"]
[null,"Shampoo",1720]
[null,"Conditioner",650]
[null,"Body lotion",1010]
[null,"Night Cream",1130]
[null,"Day Cream",400]
[null,"Baby Powder",1830]
[null,"Body Soap",460]
[null,"Face Wash",1799]

{"sheet":"VBA Code","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Product List 1",null,"Product List 2"]
[null,"Shampoo","Shampoo","Face Wash"]
[null,"Conditioner",null,"Shampoo"]
[null,"Body lotion",null,"Baby Oil"]
[null,"Night Cream","Night Cream","Day Cream"]
[null,"Lipstick",null,"Makeup"]
[null,"Baby Powder",null,"Body Soap"]
[null,"Day Cream","Day Cream","Winter Cream"]
[null,"Face Wash","Face Wash","Night Cream"]

{"sheet":"Practice Dataset","index":8,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do It Yourself"]
[]
[null,"Product Name","Price","Number of Selling Product"]