{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Drop Down","Lookup Table","XLOOKUP ","VLOOKUP","INDEX+MATCH","LOOKUP"],"not_rendered":{"external_links":2},"read":"whole","date_system":"1900"}

{"sheet":"Drop Down","index":0,"n_rows":11,"n_cols":4,"rows_kept":11}
["Student ID","Course Code","Course Name ","Credits"]
["S001","CSE101","Introduction to Coding"]
["S002","ENG150","Academic Writing"]
["S003","MAT110","Calculus I"]
["S004","BUS202","Financial Accounting"]
["S005","CSE205","Data Structure"]
["S006","BIO220","Genetics"]
["S007","ENG210","Literature in Context"]
["S008","MAT220","Linear Algebra"]
["S009","BIO105","Cell Biology"]
["S010","BUS101","Principles of Marketing"]

{"sheet":"Lookup Table","index":1,"n_rows":11,"n_cols":4,"rows_kept":11}
["Course Code","Course Name ","Department","Credits"]
["BIO105","Cell Biology","Biology",3]
["BIO220","Genetics","Biology",4]
["BUS101","Principles of Marketing","Business",3]
["BUS202","Financial Accounting","Business",4]
["CSE101","Introduction to Coding","Computer Science",3]
["CSE205","Data Structure","Computer Science",4]
["ENG150","Academic Writing","English",2]
["ENG210","Literature in Context","English",3]
["MAT110","Calculus I","Mathematics",3]
["MAT220","Linear Algebra","Mathematics",3]

{"sheet":"XLOOKUP ","index":2,"n_rows":11,"n_cols":4,"rows_kept":11}
["Student ID","Course Code","Course Name ","Credits"]
["S001","CSE101",{"$f":"_xlfn.XLOOKUP(B2, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Introduction to Coding"},{"$f":"_xlfn.XLOOKUP(B2,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":3}]
["S002","ENG150",{"$f":"_xlfn.XLOOKUP(B3, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Academic Writing"},{"$f":"_xlfn.XLOOKUP(B3,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":2}]
["S003","MAT110",{"$f":"_xlfn.XLOOKUP(B4, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Calculus I"},{"$f":"_xlfn.XLOOKUP(B4,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":3}]
["S004","BUS202",{"$f":"_xlfn.XLOOKUP(B5, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Financial Accounting"},{"$f":"_xlfn.XLOOKUP(B5,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":4}]
["S005","CSE205",{"$f":"_xlfn.XLOOKUP(B6, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Data Structure"},{"$f":"_xlfn.XLOOKUP(B6,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":4}]
["S006","BIO220",{"$f":"_xlfn.XLOOKUP(B7, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Genetics"},{"$f":"_xlfn.XLOOKUP(B7,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":4}]
["S007","ENG210",{"$f":"_xlfn.XLOOKUP(B8, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Literature in Context"},{"$f":"_xlfn.XLOOKUP(B8,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":3}]
["S008","MAT220",{"$f":"_xlfn.XLOOKUP(B9, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Linear Algebra"},{"$f":"_xlfn.XLOOKUP(B9,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":3}]
["S009","BIO105",{"$f":"_xlfn.XLOOKUP(B10, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Cell Biology"},{"$f":"_xlfn.XLOOKUP(B10,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":3}]
["S010","BUS101",{"$f":"_xlfn.XLOOKUP(B11, '[1]Lookup '!$A$2:$A$11, '[1]Lookup '!$B$2:$B$11)","v":"Principles of Marketing"},{"$f":"_xlfn.XLOOKUP(B11,'[1]Lookup '!$A$2:$A$11,'[1]Lookup '!$D$2:$D$11)","v":3}]

{"sheet":"VLOOKUP","index":3,"n_rows":11,"n_cols":4,"rows_kept":11}
["Student ID","Course Code","Course Name ","Credits"]
["S001","CSE101",{"$f":"VLOOKUP(B2, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Introduction to Coding"}]
["S002","ENG150",{"$f":"VLOOKUP(B3, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Academic Writing"}]
["S003","MAT110",{"$f":"VLOOKUP(B4, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Calculus I"}]
["S004","BUS202",{"$f":"VLOOKUP(B5, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Financial Accounting"}]
["S005","CSE205",{"$f":"VLOOKUP(B6, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Data Structure"}]
["S006","BIO220",{"$f":"VLOOKUP(B7, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Genetics"}]
["S007","ENG210",{"$f":"VLOOKUP(B8, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Literature in Context"}]
["S008","MAT220",{"$f":"VLOOKUP(B9, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Linear Algebra"}]
["S009","BIO105",{"$f":"VLOOKUP(B10, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Cell Biology"}]
["S010","BUS101",{"$f":"VLOOKUP(B11, '[1]Lookup '!$A$2:$D$11, 2, FALSE)","v":"Principles of Marketing"}]

{"sheet":"INDEX+MATCH","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
["Student ID","Course Code","Course Name ","Credits"]
["S001","CSE101",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B2,'[1]Lookup '!$A$2:$A$11, 0))","v":"Introduction to Coding"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B2, '[1]Lookup '!$A$2:$A$11, 0))","v":3}]
["S002","ENG150",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B3,'[1]Lookup '!$A$2:$A$11, 0))","v":"Academic Writing"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B3, '[1]Lookup '!$A$2:$A$11, 0))","v":2}]
["S003","MAT110",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B4,'[1]Lookup '!$A$2:$A$11, 0))","v":"Calculus I"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B4, '[1]Lookup '!$A$2:$A$11, 0))","v":3}]
["S004","BUS202",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B5,'[1]Lookup '!$A$2:$A$11, 0))","v":"Financial Accounting"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B5, '[1]Lookup '!$A$2:$A$11, 0))","v":4}]
["S005","CSE205",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B6,'[1]Lookup '!$A$2:$A$11, 0))","v":"Data Structure"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B6, '[1]Lookup '!$A$2:$A$11, 0))","v":4}]
["S006","BIO220",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B7,'[1]Lookup '!$A$2:$A$11, 0))","v":"Genetics"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B7, '[1]Lookup '!$A$2:$A$11, 0))","v":4}]
["S007","ENG210",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B8,'[1]Lookup '!$A$2:$A$11, 0))","v":"Literature in Context"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B8, '[1]Lookup '!$A$2:$A$11, 0))","v":3}]
["S008","MAT220",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B9,'[1]Lookup '!$A$2:$A$11, 0))","v":"Linear Algebra"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B9, '[1]Lookup '!$A$2:$A$11, 0))","v":3}]
["S009","BIO105",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B10,'[1]Lookup '!$A$2:$A$11, 0))","v":"Cell Biology"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B10, '[1]Lookup '!$A$2:$A$11, 0))","v":3}]
["S010","BUS101",{"$f":"INDEX('[1]Lookup '!$B$2:$B$11, MATCH(B11,'[1]Lookup '!$A$2:$A$11, 0))","v":"Principles of Marketing"},{"$f":"INDEX('[1]Lookup '!$D$2:$D$11, MATCH(B11, '[1]Lookup '!$A$2:$A$11, 0))","v":3}]

{"sheet":"LOOKUP","index":5,"n_rows":11,"n_cols":4,"rows_kept":11}
["Student ID","Course Code","Course Name ","Credits"]
["S001","CSE101",{"$f":"LOOKUP(B2, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Introduction to Coding"},{"$f":"LOOKUP(B2, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":3}]
["S002","ENG150",{"$f":"LOOKUP(B3, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Academic Writing"},{"$f":"LOOKUP(B3, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":2}]
["S003","MAT110",{"$f":"LOOKUP(B4, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Calculus I"},{"$f":"LOOKUP(B4, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":3}]
["S004","BUS202",{"$f":"LOOKUP(B5, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Financial Accounting"},{"$f":"LOOKUP(B5, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":4}]
["S005","CSE205",{"$f":"LOOKUP(B6, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Data Structure"},{"$f":"LOOKUP(B6, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":4}]
["S006","BIO220",{"$f":"LOOKUP(B7, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Genetics"},{"$f":"LOOKUP(B7, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":4}]
["S007","ENG210",{"$f":"LOOKUP(B8, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Literature in Context"},{"$f":"LOOKUP(B8, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":3}]
["S008","MAT220",{"$f":"LOOKUP(B9, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Linear Algebra"},{"$f":"LOOKUP(B9, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":3}]
["S009","BIO105",{"$f":"LOOKUP(B10, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Cell Biology"},{"$f":"LOOKUP(B10, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":3}]
["S010","BUS101",{"$f":"LOOKUP(B11, 'Lookup Table'!$A$2:$A$11, 'Lookup Table'!$B$2:$B$11)","v":"Principles of Marketing"},{"$f":"LOOKUP(B11, '[2]Lookup Table'!$A$2:$A$11, '[2]Lookup Table'!$D$2:$D$11)","v":3}]