{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["T-1","T-2","IF","VLOOKUP","ISERROR,VLOOKUP","IF,ISERROR,VLOOKUP","NOT, ISNUMBER, MATCH"],"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":"T-1","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee ID List- 01"]
[]
[null,"Case ID","Name"]
[null,108,"Harry"]
[null,149,"Ron"]
[null,1,"Hermoine"]
[null,9,"Malfoy"]
[null,12,"Hagrid"]
[null,15,"Albus"]
[null,18,"Hundo"]
[null,20,"Sonny"]
[null,28,"Vito"]
[null,32,"Vitoria"]

{"sheet":"T-2","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee ID List- 02"]
[]
[null,"Case ID","Name"]
[null,108,"Harry"]
[null,149,"Ron"]
[null,1,"Hermoine"]
[null,9,"Malfoy"]
[null,12]
[null,15,"Albus"]
[null,18,"Hundo"]
[null,20,"Sonny"]
[null,28]
[null,32,"Vitoria"]

{"sheet":"IF","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using IF Function"]
[]
[null,"Case ID","Name"]
[null,{"$f":"IF('T-1'!B5 <> 'T-2'!B5, \"T-1:\"&'T-1'!B5&\" vs T-2:\"&'T-2'!B5, \"\")","v":""},{"$f":"IF('T-1'!C5 <> 'T-2'!C5, \"T-1:\"&'T-1'!C5&\" vs T-2:\"&'T-2'!C5, \"\")","v":""}]
[null,{"$f":"IF('T-1'!B6 <> 'T-2'!B6, \"T-1:\"&'T-1'!B6&\" vs T-2:\"&'T-2'!B6, \"\")","v":""},{"$f":"IF('T-1'!C6 <> 'T-2'!C6, \"T-1:\"&'T-1'!C6&\" vs T-2:\"&'T-2'!C6, \"\")","v":""}]
[null,{"$f":"IF('T-1'!B7 <> 'T-2'!B7, \"T-1:\"&'T-1'!B7&\" vs T-2:\"&'T-2'!B7, \"\")","v":""},{"$f":"IF('T-1'!C7 <> 'T-2'!C7, \"T-1:\"&'T-1'!C7&\" vs T-2:\"&'T-2'!C7, \"\")","v":""}]
[null,{"$f":"IF('T-1'!B8 <> 'T-2'!B8, \"T-1:\"&'T-1'!B8&\" vs T-2:\"&'T-2'!B8, \"\")","v":""},{"$f":"IF('T-1'!C8 <> 'T-2'!C8, \"T-1:\"&'T-1'!C8&\" vs T-2:\"&'T-2'!C8, \"\")","v":""}]
[null,{"$f":"IF('T-1'!B9 <> 'T-2'!B9, \"T-1:\"&'T-1'!B9&\" vs T-2:\"&'T-2'!B9, \"\")","v":""},{"$f":"IF('T-1'!C9 <> 'T-2'!C9, \"T-1:\"&'T-1'!C9&\" vs T-2:\"&'T-2'!C9, \"\")","v":"T-1:Hagrid vs T-2:"}]
[null,{"$f":"IF('T-1'!B10 <> 'T-2'!B10, \"T-1:\"&'T-1'!B10&\" vs T-2:\"&'T-2'!B10, \"\")","v":""},{"$f":"IF('T-1'!C10 <> 'T-2'!C10, \"T-1:\"&'T-1'!C10&\" vs T-2:\"&'T-2'!C10, \"\")","v":""}]
[null,{"$f":"IF('T-1'!B11 <> 'T-2'!B11, \"T-1:\"&'T-1'!B11&\" vs T-2:\"&'T-2'!B11, \"\")","v":""},{"$f":"IF('T-1'!C11 <> 'T-2'!C11, \"T-1:\"&'T-1'!C11&\" vs T-2:\"&'T-2'!C11, \"\")","v":""}]
[null,{"$f":"IF('T-1'!B12 <> 'T-2'!B12, \"T-1:\"&'T-1'!B12&\" vs T-2:\"&'T-2'!B12, \"\")","v":""},{"$f":"IF('T-1'!C12 <> 'T-2'!C12, \"T-1:\"&'T-1'!C12&\" vs T-2:\"&'T-2'!C12, \"\")","v":""}]
[null,{"$f":"IF('T-1'!B13 <> 'T-2'!B13, \"T-1:\"&'T-1'!B13&\" vs T-2:\"&'T-2'!B13, \"\")","v":""},{"$f":"IF('T-1'!C13 <> 'T-2'!C13, \"T-1:\"&'T-1'!C13&\" vs T-2:\"&'T-2'!C13, \"\")","v":"T-1:Vito vs T-2:"}]
[null,{"$f":"IF('T-1'!B14 <> 'T-2'!B14, \"T-1:\"&'T-1'!B14&\" vs T-2:\"&'T-2'!B14, \"\")","v":""},{"$f":"IF('T-1'!C14 <> 'T-2'!C14, \"T-1:\"&'T-1'!C14&\" vs T-2:\"&'T-2'!C14, \"\")","v":""}]

{"sheet":"VLOOKUP","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VLOOKUP Function"]
[]
[null,"Case ID","Name","Missing in List-02"]
[null,108,"Harry",{"$f":"VLOOKUP(B5,'T-2'!$B$4:$C$14,2,FALSE)","v":"Harry"}]
[null,149,"Ron",{"$f":"VLOOKUP(B6,'T-2'!$B$4:$C$14,2,FALSE)","v":"Ron"}]
[null,1,"Hermoine",{"$f":"VLOOKUP(B7,'T-2'!$B$4:$C$14,2,FALSE)","v":"Hermoine"}]
[null,9,"Malfoy",{"$f":"VLOOKUP(B8,'T-2'!$B$4:$C$14,2,FALSE)","v":"Malfoy"}]
[null,12,"Hagrid",{"$f":"VLOOKUP(B9,'T-2'!$B$4:$C$14,2,FALSE)","v":0}]
[null,15,"Albus",{"$f":"VLOOKUP(B10,'T-2'!$B$4:$C$14,2,FALSE)","v":"Albus"}]
[null,18,"Hundo",{"$f":"VLOOKUP(B11,'T-2'!$B$4:$C$14,2,FALSE)","v":"Hundo"}]
[null,20,"Sonny",{"$f":"VLOOKUP(B12,'T-2'!$B$4:$C$14,2,FALSE)","v":"Sonny"}]
[null,28,"Vito",{"$f":"VLOOKUP(B13,'T-2'!$B$4:$C$14,2,FALSE)","v":0}]
[null,32,"Vitoria",{"$f":"VLOOKUP(B14,'T-2'!$B$4:$C$14,2,FALSE)","v":"Vitoria"}]

{"sheet":"ISERROR,VLOOKUP","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilizing ISERROR & VLOOKUP Functions"]
[]
[null,"Case ID","Name","Missing in List-02"]
[null,108,"Harry",{"$f":"ISERROR(VLOOKUP(C5,'T-2'!$C$4:$C$14,1,FALSE))","v":false}]
[null,149,"Ron",{"$f":"ISERROR(VLOOKUP(C6,'T-2'!$C$4:$C$14,1,FALSE))","v":false}]
[null,1,"Hermoine",{"$f":"ISERROR(VLOOKUP(C7,'T-2'!$C$4:$C$14,1,FALSE))","v":false}]
[null,9,"Malfoy",{"$f":"ISERROR(VLOOKUP(C8,'T-2'!$C$4:$C$14,1,FALSE))","v":false}]
[null,12,"Hagrid",{"$f":"ISERROR(VLOOKUP(C9,'T-2'!$C$4:$C$14,1,FALSE))","v":true}]
[null,15,"Albus",{"$f":"ISERROR(VLOOKUP(C10,'T-2'!$C$4:$C$14,1,FALSE))","v":false}]
[null,18,"Hundo",{"$f":"ISERROR(VLOOKUP(C11,'T-2'!$C$4:$C$14,1,FALSE))","v":false}]
[null,20,"Sonny",{"$f":"ISERROR(VLOOKUP(C12,'T-2'!$C$4:$C$14,1,FALSE))","v":false}]
[null,28,"Vito",{"$f":"ISERROR(VLOOKUP(C13,'T-2'!$C$4:$C$14,1,FALSE))","v":true}]
[null,32,"Vitoria",{"$f":"ISERROR(VLOOKUP(C14,'T-2'!$C$4:$C$14,1,FALSE))","v":false}]

{"sheet":"IF,ISERROR,VLOOKUP","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining IF, ISERROR & VLOOKUP Functions"]
[]
[null,"Case ID","Name","Missing in List-02"]
[null,108,"Harry",{"$f":"IF(ISERROR(VLOOKUP(C5,'T-2'!$C$4:$C$14,1,FALSE)),C5,\"\")","v":""}]
[null,149,"Ron",{"$f":"IF(ISERROR(VLOOKUP(C6,'T-2'!$C$4:$C$14,1,FALSE)),C6,\"\")","v":""}]
[null,1,"Hermoine",{"$f":"IF(ISERROR(VLOOKUP(C7,'T-2'!$C$4:$C$14,1,FALSE)),C7,\"\")","v":""}]
[null,9,"Malfoy",{"$f":"IF(ISERROR(VLOOKUP(C8,'T-2'!$C$4:$C$14,1,FALSE)),C8,\"\")","v":""}]
[null,12,"Hagrid",{"$f":"IF(ISERROR(VLOOKUP(C9,'T-2'!$C$4:$C$14,1,FALSE)),C9,\"\")","v":"Hagrid"}]
[null,15,"Albus",{"$f":"IF(ISERROR(VLOOKUP(C10,'T-2'!$C$4:$C$14,1,FALSE)),C10,\"\")","v":""}]
[null,18,"Hundo",{"$f":"IF(ISERROR(VLOOKUP(C11,'T-2'!$C$4:$C$14,1,FALSE)),C11,\"\")","v":""}]
[null,20,"Sonny",{"$f":"IF(ISERROR(VLOOKUP(C12,'T-2'!$C$4:$C$14,1,FALSE)),C12,\"\")","v":""}]
[null,28,"Vito",{"$f":"IF(ISERROR(VLOOKUP(C13,'T-2'!$C$4:$C$14,1,FALSE)),C13,\"\")","v":"Vito"}]
[null,32,"Vitoria",{"$f":"IF(ISERROR(VLOOKUP(C14,'T-2'!$C$4:$C$14,1,FALSE)),C14,\"\")","v":""}]

{"sheet":"NOT, ISNUMBER, MATCH","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using NOT, ISNUMBER & MATCH Functions"]
[]
[null,"Case ID","Name","Missing in List-02"]
[null,108,"Harry",{"$f":"NOT(ISNUMBER(MATCH(C5,'T-2'!$C$4:$C$14,0)))","v":false}]
[null,149,"Ron",{"$f":"NOT(ISNUMBER(MATCH(C6,'T-2'!$C$4:$C$14,0)))","v":false}]
[null,1,"Hermoine",{"$f":"NOT(ISNUMBER(MATCH(C7,'T-2'!$C$4:$C$14,0)))","v":false}]
[null,9,"Malfoy",{"$f":"NOT(ISNUMBER(MATCH(C8,'T-2'!$C$4:$C$14,0)))","v":false}]
[null,12,"Hagrid",{"$f":"NOT(ISNUMBER(MATCH(C9,'T-2'!$C$4:$C$14,0)))","v":true}]
[null,15,"Albus",{"$f":"NOT(ISNUMBER(MATCH(C10,'T-2'!$C$4:$C$14,0)))","v":false}]
[null,18,"Hundo",{"$f":"NOT(ISNUMBER(MATCH(C11,'T-2'!$C$4:$C$14,0)))","v":false}]
[null,20,"Sonny",{"$f":"NOT(ISNUMBER(MATCH(C12,'T-2'!$C$4:$C$14,0)))","v":false}]
[null,28,"Vito",{"$f":"NOT(ISNUMBER(MATCH(C13,'T-2'!$C$4:$C$14,0)))","v":true}]
[null,32,"Vitoria",{"$f":"NOT(ISNUMBER(MATCH(C14,'T-2'!$C$4:$C$14,0)))","v":false}]