{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Overview","Dataset","INDIRECT & ADDRESS Functions","INDEX Function(Wrong)","INDEX Function (Right)","INDIRECT with Text Ref","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":"Overview","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Overview of Referencing Cell by Row and Column Number"]
[]
[null,"Employee ID","Name","Salary","Department"]
[null,101,"Jacob",926,"Sales"]
[null,102,"Fleming",841,"Operations"]
[null,103,"Johnson",507,"Marketing"]
[null,104,"David",778,"Sales"]
[null,105,"Anderson",589,"Marketing"]
[null,106,"Peter",510,"Sales"]
[null,107,"Anthony",837,"Marketing"]
[null,108,"Aron",744,"Operations"]
[null,109,"Eric",513,"Sales"]
[null,110,"Steve",546,"Operations"]
[]
[null,"Case","Row No.","Column No.","Output"]
[null,"Using INDIRECT and ADDRESS Functions",8,3,{"$f":"INDIRECT(ADDRESS(C17,D17))","v":"David"},{"$f":"_xlfn.FORMULATEXT(E17)","v":"=INDIRECT(ADDRESS(C17,D17))"}]
[null,"Using INDEX Function",5,2,{"$f":"INDEX(Employee_Info,C18,D18)","v":"David"},{"$f":"_xlfn.FORMULATEXT(E18)","v":"=INDEX(Employee_Info,C18,D18)"}]
[null,"Using INDIRECT Function with Text Reference",7,3,{"$f":"INDIRECT(\"R\" & 7 & \"C\" & 3,FALSE)","v":"Johnson"},{"$f":"_xlfn.FORMULATEXT(E19)","v":"=INDIRECT(\"R\" & 7 & \"C\" & 3,FALSE)"}]

{"sheet":"Dataset","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Referencing Cell by Row and Column Number"]
[]
[null,"Employee ID","Name","Salary","Department"]
[null,101,"Jacob",926,"Sales"]
[null,102,"Fleming",841,"Operations"]
[null,103,"Johnson",507,"Marketing"]
[null,104,"David",778,"Sales"]
[null,105,"Anderson",589,"Marketing"]
[null,106,"Peter",510,"Sales"]
[null,107,"Anthony",837,"Marketing"]
[null,108,"Aron",744,"Operations"]
[null,109,"Eric",513,"Sales"]
[null,110,"Steve",546,"Operations"]

{"sheet":"INDIRECT & ADDRESS Functions","index":2,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Using INDIRECT and ADDRESS Functions",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee ID","Name","Salary","Department",null,null,null,null,null,null,null,"Employee ID","Name","Salary","Department"]
[null,101,"Jacob",926,"Sales",null,null,null,null,null,null,null,101,"Jacob",926,"Sales"]
[null,102,"Fleming",841,"Operations",null,null,null,null,null,null,null,102,"Fleming",841,"Operations"]
[null,103,"Johnson",507,"Marketing",null,null,null,null,null,null,null,103,"Johnson",507,"Marketing"]
[null,104,"David",778,"Sales",null,null,null,null,null,null,null,104,"David",778,"Sales"]
[null,105,"Anderson",589,"Marketing",null,null,null,null,null,null,null,105,"Anderson",589,"Marketing"]
[null,106,"Peter",510,"Sales",null,null,null,null,null,null,null,106,"Peter",510,"Sales"]
[null,107,"Anthony",837,"Marketing",null,null,null,null,null,null,null,107,"Anthony",837,"Marketing"]
[null,108,"Aron",744,"Operations",null,null,null,null,null,null,null,108,"Aron",744,"Operations"]
[null,109,"Eric",513,"Sales",null,null,null,null,null,null,null,109,"Eric",513,"Sales"]
[null,110,"Steve",546,"Operations",null,null,null,null,null,null,null,110,"Steve",546,"Operations"]
[]
[null,"Row No.","Column No.","Output",null,null,null,null,null,null,null,null,"Row No.","Column No.","Output"]
[null,8,3,{"$f":"INDIRECT(ADDRESS(B17,C17))","v":"David"}]

{"sheet":"INDEX Function(Wrong)","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4],[18,1,19,5]]}
[]
[null,"Using INDEX Function"]
[]
[null,"Employee ID","Name","Salary","Department"]
[null,101,"Jacob",926,"Sales"]
[null,102,"Fleming",841,"Operations"]
[null,103,"Johnson",507,"Marketing"]
[null,104,"David",778,"Sales"]
[null,105,"Anderson",589,"Marketing"]
[null,106,"Peter",510,"Sales"]
[null,107,"Anthony",837,"Marketing"]
[null,108,"Aron",744,"Operations"]
[null,109,"Eric",513,"Sales"]
[null,110,"Steve",546,"Operations"]
[]
[null,"Actual Row No.","Actual Column No.","Output","Comment"]
[null,8,3,{"$f":"INDEX(Employee_Info,B17,C17)","v":837},"Wrong Value"]
[null,null,null,{"$f":"_xlfn.FORMULATEXT(D17)","v":"=INDEX(Employee_Info,B17,C17)"}]
[null,">> Giving wrong value because the formula is seraching for row and column no. with respect to given range not for actual row and column no."]

{"sheet":"INDEX Function (Right)","index":4,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4],[18,1,18,4],[22,1,23,4],[7,5,8,6],[1,12,1,15]]}
[]
[null,"Using INDEX Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[null,null,"Column No. 2 based on Named Range"]
[null,"Employee ID","Name","Salary","Department",null,null,null,null,null,null,null,"Employee ID","Name","Salary","Department"]
[null,101,"Jacob",926,"Sales",null,null,null,null,null,null,null,101,"Jacob",926,"Sales"]
[null,102,"Fleming",841,"Operations",null,null,null,null,null,null,null,102,"Fleming",841,"Operations"]
[null,103,"Johnson",507,"Marketing",null,null,null,null,null,null,null,103,"Johnson",507,"Marketing"]
[null,104,"David",778,"Sales","Row No. 5 based on Named Range",null,null,null,null,null,null,104,"David",778,"Sales"]
[null,105,"Anderson",589,"Marketing",null,null,null,null,null,null,null,105,"Anderson",589,"Marketing"]
[null,106,"Peter",510,"Sales",null,null,null,null,null,null,null,106,"Peter",510,"Sales"]
[null,107,"Anthony",837,"Marketing",null,null,null,null,null,null,null,107,"Anthony",837,"Marketing"]
[null,108,"Aron",744,"Operations",null,null,null,null,null,null,null,108,"Aron",744,"Operations"]
[null,109,"Eric",513,"Sales",null,null,null,null,null,null,null,109,"Eric",513,"Sales"]
[null,110,"Steve",546,"Operations",null,null,null,null,null,null,null,110,"Steve",546,"Operations"]
[]
[null,"Actual Row No.","Actual Column No.","Output","Comment",null,null,null,null,null,null,null,"Row No.","Column No.","Output"]
[null,8,3,{"$f":"INDEX(Employee_Info,B17,C17)","v":837},"Wrong Value"]
[null,null,null,{"$f":"_xlfn.FORMULATEXT(D17)","v":"=INDEX(Employee_Info,B17,C17)"}]
[null," Based on Named Range "]
[null,"Row No.","Column No.","Output","Comment"]
[null,5,2,{"$f":"INDEX(Employee_Info,B21,C21)","v":"David"},"Correct Value"]
[null,null,null,{"$f":"_xlfn.FORMULATEXT(D21)","v":"=INDEX(Employee_Info,B21,C21)"}]
[null,">> Giving right value after putting row and column no. into formula with respect to given range"]

{"sheet":"INDIRECT with Text Ref","index":5,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Using Text Reference Within the INDIRECT Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee ID","Name","Salary","Department",null,null,null,null,null,null,null,"Employee ID","Name","Salary","Department"]
[null,101,"Jacob",926,"Sales",null,null,null,null,null,null,null,101,"Jacob",926,"Sales"]
[null,102,"Fleming",841,"Operations",null,null,null,null,null,null,null,102,"Fleming",841,"Operations"]
[null,103,"Johnson",507,"Marketing",null,null,null,null,null,null,null,103,"Johnson",507,"Marketing"]
[null,104,"David",778,"Sales",null,null,null,null,null,null,null,104,"David",778,"Sales"]
[null,105,"Anderson",589,"Marketing",null,null,null,null,null,null,null,105,"Anderson",589,"Marketing"]
[null,106,"Peter",510,"Sales",null,null,null,null,null,null,null,106,"Peter",510,"Sales"]
[null,107,"Anthony",837,"Marketing",null,null,null,null,null,null,null,107,"Anthony",837,"Marketing"]
[null,108,"Aron",744,"Operations",null,null,null,null,null,null,null,108,"Aron",744,"Operations"]
[null,109,"Eric",513,"Sales",null,null,null,null,null,null,null,109,"Eric",513,"Sales"]
[null,110,"Steve",546,"Operations",null,null,null,null,null,null,null,110,"Steve",546,"Operations"]
[]
[null,"Row No.","Column No.","Output",null,null,null,null,null,null,null,null,"Row No.","Column No.","Output"]
[null,7,3,{"$f":"INDIRECT(\"R\" & 7 & \"C\" & 3,FALSE)","v":"Johnson"}]
[null,">> Manually inputing row & column no. into formula."]
[null,">> FALSE for R1C1 style"]

{"sheet":"VBA","index":6,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Applying User Defined Function Using VBA",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee ID","Name","Salary","Department",null,null,null,null,null,null,null,"Employee ID","Name","Salary","Department"]
[null,101,"Jacob",926,"Sales",null,null,null,null,null,null,null,101,"Jacob",926,"Sales"]
[null,102,"Fleming",841,"Operations",null,null,null,null,null,null,null,102,"Fleming",841,"Operations"]
[null,103,"Johnson",507,"Marketing",null,null,null,null,null,null,null,103,"Johnson",507,"Marketing"]
[null,104,"David",778,"Sales",null,null,null,null,null,null,null,104,"David",778,"Sales"]
[null,105,"Anderson",589,"Marketing",null,null,null,null,null,null,null,105,"Anderson",589,"Marketing"]
[null,106,"Peter",510,"Sales",null,null,null,null,null,null,null,106,"Peter",510,"Sales"]
[null,107,"Anthony",837,"Marketing",null,null,null,null,null,null,null,107,"Anthony",837,"Marketing"]
[null,108,"Aron",744,"Operations",null,null,null,null,null,null,null,108,"Aron",744,"Operations"]
[null,109,"Eric",513,"Sales",null,null,null,null,null,null,null,109,"Eric",513,"Sales"]
[null,110,"Steve",546,"Operations",null,null,null,null,null,null,null,110,"Steve",546,"Operations"]
[]
[null,"Row No.","Column No.","Output",null,null,null,null,null,null,null,null,"Row No.","Column No.","Output"]
[null,7,3,{"$f":"CellReference(B17,C17)","v":"Johnson"}]