{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["WorksheetFunction","UserFormVLOOKUP","Two_Criteria","Three_Criteria","Birth_Place","VBA","XLOOKUP","Ampersand_Operator"],"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":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Using VBA WorksheetFunction",null,null,null,null,null,"Try Yourself"]
[]
[null,"Name_Department ","ID","Name","Department ","Income",null,"Name_Department ","ID","Name","Department ","Income"]
[null,"Robert_Developer",1220,"Robert","Developer",20000,null,"Robert_Developer",1220,"Robert","Developer",20000]
[null,"John_Writer",1230,"John","Writer",22000,null,"John_Writer",1230,"John","Writer",22000]
[null,"Maddison_IT",1240,"Maddison","IT",25000,null,"Maddison_IT",1240,"Maddison","IT",25000]
[null,"Jill_Marketing",1250,"Jill","Marketing",28000,null,"Jill_Marketing",1250,"Jill","Marketing",28000]
[null,"Jim_Sales",1260,"Jim","Sales",30000,null,"Jim_Sales",1260,"Jim","Sales",30000]
[null,"Catherin_Developer",1270,"Catherin","Developer",35000,null,"Catherin_Developer",1270,"Catherin","Developer",35000]
[null,"Catherin_Writer",1280,"Catherin","Writer",40000,null,"Catherin_Writer",1280,"Catherin","Writer",40000]
[null,"Ian_IT",1290,"Ian","IT",45000,null,"Ian_IT",1290,"Ian","IT",45000]
[null,"Jill_Developer",1300,"Jill","Developer",50000,null,"Jill_Developer",1300,"Jill","Developer",50000]
[null,"Robert_Writer",1310,"Robert","Writer",55000,null,"Robert_Writer",1310,"Robert","Writer",55000]
[null,"John_IT",1320,"John","IT",60000,null,"John_IT",1320,"John","IT",60000]

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

{"sheet":"Two_Criteria","index":2,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,7,5,8],[1,1,1,8],[1,10,1,17],[5,16,5,17]]}
[]
[null,"VLOOKUP for Two Criteria",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"City","Name","Department ","Income",null,"Lookup Value","Criteria1","Criteria2",null,"City","Name","Department ","Income",null,"Lookup Value","Criteria1","Criteria2"]
[null,"Texas","Robert","Developer",20000,null,"Developer","Texas","Robert",null,"Texas","Robert","Developer",20000,null,"Developer","Texas","Robert"]
[null,"Alabama","John","Writer",22000,null,"Income ",{"$f":"VLOOKUP_TwoCriteria(G5,B4:E15,H5,I5,4)","v":20000},null,null,"Alabama","John","Writer",22000,null,"Income "]
[null,"Texas","Maddison","IT",25000,null,null,null,null,null,"Texas","Maddison","IT",25000]
[null,"Alabama","Jill","Marketing",28000,null,null,null,null,null,"Alabama","Jill","Marketing",28000]
[null,"Arizona","Jim","Sales",30000,null,null,null,null,null,"Arizona","Jim","Sales",30000]
[null,"New York","Catherin","Developer",35000,null,null,null,null,null,"New York","Catherin","Developer",35000]
[null,"UK","Catherin","Writer",40000,null,null,null,null,null,"UK","Catherin","Writer",40000]
[null,"New York","Ian","IT",45000,null,null,null,null,null,"New York","Ian","IT",45000]
[null,"Texas","Jill","Developer",50000,null,null,null,null,null,"Texas","Jill","Developer",50000]
[null,"Texas","Robert","Writer",55000,null,null,null,null,null,"Texas","Robert","Writer",55000]
[null,"UK","John","IT",60000,null,null,null,null,null,"UK","John","IT",60000]

{"sheet":"Three_Criteria","index":3,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,8,5,10],[1,1,1,10],[1,12,1,21],[5,19,5,21]]}
[]
[null,"VLOOKUP for Three Criteria",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"City","ID","Name","Department ","Income",null,"Lookup Value","Criteria1","Criteria2","Criteria3",null,"City","ID","Name","Department ","Income",null,"Lookup Value","Criteria1","Criteria2","Criteria3"]
[null,"Texas",1220,"Robert","Developer",20000,null,"Developer","Texas",1220,"Robert",null,"Texas",1220,"Robert","Developer",20000,null,"Developer","Texas",1220,"Robert"]
[null,"Alabama",1230,"John","Writer",22000,null,"Income",{"$f":"VLOOKUP_ThreeCriteria(H5,B4:F15,I5,J5,K5,5)","v":20000},null,null,null,"Alabama",1230,"John","Writer",22000,null,"Income"]
[null,"Texas",1240,"Maddison","IT",25000,null,null,null,null,null,null,"Texas",1240,"Maddison","IT",25000]
[null,"Alabama",1250,"Jill","Marketing",28000,null,null,null,null,null,null,"Alabama",1250,"Jill","Marketing",28000]
[null,"Arizona",1260,"Jim","Sales",30000,null,null,null,null,null,null,"Arizona",1260,"Jim","Sales",30000]
[null,"New York",1270,"Catherin","Developer",35000,null,null,null,null,null,null,"New York",1270,"Catherin","Developer",35000]
[null,"UK",1280,"Catherin","Writer",40000,null,null,null,null,null,null,"UK",1280,"Catherin","Writer",40000]
[null,"New York",1290,"Ian","IT",45000,null,null,null,null,null,null,"New York",1290,"Ian","IT",45000]
[null,"Texas",1300,"Jill","Developer",50000,null,null,null,null,null,null,"Texas",1300,"Jill","Developer",50000]
[null,"Texas",1310,"Robert","Writer",55000,null,null,null,null,null,null,"Texas",1310,"Robert","Writer",55000]
[null,"UK",1320,"John","IT",60000,null,null,null,null,null,null,"UK",1320,"John","IT",60000]

{"sheet":"Birth_Place","index":4,"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":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using If Else Statement "]
[]
[null,"Author Name","Birthdate","Famous for","Birth Place"]
[null,"Arthur Conan Doyle","May 22, 1859","Detective Fiction","Edinburgh, United Kingdom"]
[null,"Ian Fleming","1908-05-28","Spy fiction","Torquay, United Kingdom"]
[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,"James Patterson","1947-03-22","Thriller","Portsmouth, United Kingdom"]
[null,"Kevin McClory","1924-06-08","Spy fiction","London, England"]
[null,"Charles Dickens","February 7, 1812","Novels","Maine, United States"]

{"sheet":"XLOOKUP","index":6,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,15]]}
[]
[null,"Using XLOOKUP Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Department ","Income",null,"Name","Department ","Income",null,"Name","Department ","Income",null,"Name","Department ","Income"]
[null,"Robert","Developer",20000,null,"Robert","Developer",20000,null,"Robert","Developer",20000,null,"Robert","Developer"]
[null,"John","Writer",22000,null,null,null,null,null,"John","Writer",22000]
[null,"Maddison","IT",25000,null,null,null,null,null,"Maddison","IT",25000]
[null,"Jill","Marketing",28000,null,null,null,null,null,"Jill","Marketing",28000]
[null,"Jim","Sales",30000,null,null,null,null,null,"Jim","Sales",30000]
[null,"Catherin","Developer",35000,null,null,null,null,null,"Catherin","Developer",35000]
[null,"Catherin","Writer",40000,null,null,null,null,null,"Catherin","Writer",40000]
[null,"Ian","IT",45000,null,null,null,null,null,"Ian","IT",45000]
[null,"Jony","Developer",50000,null,null,null,null,null,"Jony","Developer",50000]
[null,"Jimmy","Writer",55000,null,null,null,null,null,"Jimmy","Writer",55000]
[null,"Lio","IT",60000,null,null,null,null,null,"Lio","IT",60000]

{"sheet":"Ampersand_Operator","index":7,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,7,5,7],[1,1,1,7],[1,9,1,15],[4,15,5,15]]}
[]
[null,"Employing Ampersand Operator",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Helper Column","Name","Department ","Income",null,"Criteria","Income",null,"Helper Column","Name","Department ","Income",null,"Criteria","Income"]
[null,{"$f":"C5 & D5","v":"RobertDeveloper"},"Robert","Developer",20000,null,"Robert",{"$f":"VLOOKUP(G5&G6,B5:E15,4,0)","v":20000},null,{"$f":"K5 & L5","v":"RobertDeveloper"},"Robert","Developer",20000,null,"Robert"]
[null,{"$f":"C6 & D6","v":"JohnWriter"},"John","Writer",22000,null,"Developer",null,null,{"$f":"K6 & L6","v":"JohnWriter"},"John","Writer",22000,null,"Developer"]
[null,"MaddisonIT","Maddison","IT",25000,null,null,null,null,"MaddisonIT","Maddison","IT",25000]
[null,"JillMarketing","Jill","Marketing",28000,null,null,null,null,"JillMarketing","Jill","Marketing",28000]
[null,"JimSales","Jim","Sales",30000,null,null,null,null,"JimSales","Jim","Sales",30000]
[null,"CatherinDeveloper","Catherin","Developer",35000,null,null,null,null,"CatherinDeveloper","Catherin","Developer",35000]
[null,"CatherinWriter","Catherin","Writer",40000,null,null,null,null,"CatherinWriter","Catherin","Writer",40000]
[null,"IanIT","Ian","IT",45000,null,null,null,null,"IanIT","Ian","IT",45000]
[null,"JillDeveloper","Jill","Developer",50000,null,null,null,null,"JillDeveloper","Jill","Developer",50000]
[null,"RobertWriter","Robert","Writer",55000,null,null,null,null,"RobertWriter","Robert","Writer",55000]
[null,"JohnIT","John","IT",60000,null,null,null,null,"JohnIT","John","IT",60000]