{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["WorksheetFunction","Birth_Place","VBA","Sheet4","UserFormVLOOKUP","Sheet2"],"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":"WorksheetFunction","index":0,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Using VBA WorksheetFunction",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Department","Income",null,"Department","Income",null,null,"Name","Department","Income",null,"Department","Income"]
[null,"John","Developer",20000,null,"Writer",30000,null,null,"John","Developer",20000,null,"Writer"]
[null,"Maddison","Marketing ",22000,null,null,null,null,null,"Maddison","Marketing ",22000]
[null,"Stephen","Sales",25000,null,null,null,null,null,"Stephen","Sales",25000]
[null,"Benith","HR",28000,null,null,null,null,null,"Benith","HR",28000]
[null,"Catherin","Writer",30000,null,null,null,null,null,"Catherin","Writer",30000]
[null,"Smith","Software",35000,null,null,null,null,null,"Smith","Software",35000]
[null,"Ian","Distribution",40000,null,null,null,null,null,"Ian","Distribution",40000]
[null,"Ryan","Manager",45000,null,null," ",null,null,"Ryan","Manager",45000,null,null," "]
[null,"Adam","IT",50000,null,null,null,null,null,"Adam","IT",50000]
[null,"Leo","CEO",55000,null,null,null,null,null,"Leo","CEO",55000]

{"sheet":"Birth_Place","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Information of Authors"]
[]
[null,"Author Name","Birth Place"]
[null,"Arthur Conan Doyle","Edinburgh, United Kingdom"]
[null,"Agatha Christie","Torquay, United Kingdom"]
[null,"Kevin McClory","Dún Laoghaire, Ireland"]
[null,"James Patterson","New York, United States"]
[null,"Charles Dickens","Portsmouth, United Kingdom"]
[null,"Ian Fleming","London, England"]
[null,"Stephen King","Maine, United States"]

{"sheet":"VBA","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Using VBA VLookup Function with If Else Statement",null,null,null,null,null,"Try Yourself"]
[]
[null,"Author Name","Birthdate","Famous for","Birth Place",null,null,"Author Name","Birthdate","Famous for","Birth Place"]
[null,"Arthur Conan Doyle","May 22, 1859","Detective Fiction","Edinburgh, United Kingdom",null,null,"Arthur Conan Doyle","May 22, 1859","Detective Fiction","Edinburgh, United Kingdom"]
[null,"Ian Fleming","1908-05-28","Spy fiction","Torquay, United Kingdom",null,null,"Ian Fleming","1908-05-28","Spy fiction","Torquay, United Kingdom"]
[null,"Agatha Christie","September 15, 1890","Murder Mystery","Dún Laoghaire, Ireland",null,null,"Agatha Christie","September 15, 1890","Murder Mystery","Dún Laoghaire, Ireland"]
[null,"Stephen King","1947-09-21","Horror Fiction","New York, United States",null,null,"Stephen King","1947-09-21","Horror Fiction","New York, United States"]
[null,"James Patterson","1947-03-22","Thriller","Portsmouth, United Kingdom",null,null,"James Patterson","1947-03-22","Thriller","Portsmouth, United Kingdom"]
[null,"Kevin McClory","1924-06-08","Spy fiction","London, England",null,null,"Kevin McClory","1924-06-08","Spy fiction","London, England"]
[null,"Charles Dickens","February 7, 1812","Novels","Maine, United States",null,null,"Charles Dickens","February 7, 1812","Novels","Maine, United States"]

{"sheet":"Sheet4","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null," Creating User-Defined Function to Extract Multiple Matches",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Products Sold",null,"Name","Result",null,null,"Name","Products Sold",null,"Name","Result"]
[null,"John","Watch",null,"John",{"$f":"Multiple_Match(E5,$B$4:$C$14,2)","v":"Watch, Monitor"},null,null,"John","Watch",null,"John"]
[null,"Maddison","Laptop",null,"Maddison",{"$f":"Multiple_Match(E6,$B$4:$C$14,2)","v":"Laptop, Tablet"},null,null,"Maddison","Laptop",null,"Maddison"]
[null,"John","Monitor",null,"Smith",{"$f":"Multiple_Match(E7,$B$4:$C$14,2)","v":"Camera, Microphone, Dekstop"},null,null,"John","Monitor",null,"Smith"]
[null,"John",null,null,null,null,null,null,"John"]
[null,"Maddison","Tablet",null,null,null,null,null,"Maddison","Tablet"]
[null,"Smith","Camera",null,null,null,null,null,"Smith","Camera"]
[null,"Smith","Microphone",null,null,null,null,null,"Smith","Microphone"]
[null,"Maddison",null,null,null," ",null,null,"Maddison",null,null,null," "]
[null,"Smith","Dekstop",null,null,null,null,null,"Smith","Dekstop"]
[null,"John",null,null,null,null,null,null,"John"]

{"sheet":"UserFormVLOOKUP","index":4,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Creating an UserForm to Lookup Value "]
[]
[null,"Name","ID","Bill Amount","Paid","Balance"]
[null,"Robert",1220,2000,1000,{"$f":"D5-E5","v":1000}]
[null,"John",1230,3000,2500,{"$f":"D6-E6","v":500}]
[null,"Maddison",1240,4000,2000,2000]
[null,"Jill",1250,5000,3999,1001]
[null,"Jim",1260,6000,2909,3091]
[null,"Catherin",1270,7000,6609,391]
[null,"Cinderella",1280,8000,6500,1500]
[null,"Ian",1290,9000,2600,6400]
[null,"Jony",1300,10000,7000,3000]
[null,"Jimmy",1310,11000,4500,6500]
[null,"Lio",1320,12000,11000,1000]

{"sheet":"Sheet2","index":5,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA Index Match Application"]
[]
[null,"ID","Name","Math","Physics","Chemistry"]
[null,1001,"John",55,45,65]
[null,1002,"Mary",60,50,77]
[null,1003,"Tom",65,54,76]