{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Two Dimension","UDF","Return Result"],"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"INDEX MATCH Based on Multiple Criteria with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"Two Dimension","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"INDEX MATCH for Two Dimensional Lookup with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks",null,"Name","Edge"]
[null,"John",101,89,null,"Search Column","Exam Marks"]
[null,"Roman",102,56,null,"Result",67]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"UDF","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"INDEX MATCH Based on Multiple Criteria with UDF in VBA"]
[]
[null,"Student Name","Student ID","Exam Marks",null,"Result from UDF"]
[null,"John",101,89,null,{"$f":"MatchByIndex(105, 84)","v":"Finn"}]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"Return Result","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"INDEX MATCH Based on Multiple Criteria from Table with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,57]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]