{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["VLOOKUP Twice","TEXTJOIN+IF","TEXTJOIN+FILTER","UDF-VBA","Practice Sheet","Practice Sheet (2)","Practice Sheet (3)"],"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":"VLOOKUP Twice","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of VLOOKUP Function"]
[]
[null,"ID","First_Name","Last_Name",null,"Lookup Value","Return Value"]
[null,"EM001","Abigail","Adams",null,"EM003",{"$f":"VLOOKUP(F5,B5:E12,2,FALSE)&\",\"&VLOOKUP(F5,B5:E12,3,FALSE)","v":"Ellen,Wilson"}]
[null,"EM002","Caroline","Scott"]
[null,"EM003","Ellen","Wilson"]
[null,"EM004","Herbert","Hoover"]
[null,"EM005","Ida","McKinley"]
[null,"EM006","Richard","Cheney"]
[null,"EM007","Schuyler","Colfax"]
[null,"EM008","Zachary","Taylor"]

{"sheet":"TEXTJOIN+IF","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of TEXTJOIN & IF Functions"]
[]
[null,"Team","Name",null,"Lookup Value","Return Value"]
[null,"Team 1","Abigail",null,"Team 1",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF(B:B=E5,C:C,\"\"))","v":"Abigail,Caroline,Ellen"}]
[null,"Team 1","Caroline"]
[null,"Team 1","Ellen"]
[null,"Team 2","Herbert"]
[null,"Team 2","Mark"]
[null,"Team 2","Nicole"]
[null,"Team 3","Richard"]
[null,"Team 3","Taylor"]
[null,"Team 3","Wilson"]

{"sheet":"TEXTJOIN+FILTER","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of TEXTJOIN & FILTER Functions"]
[]
[null,"Team","Name",null,"Lookup Value","Return Value"]
[null,"Team 1","Abigail",null,"Team 2",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,_xlfn._xlws.FILTER(C5:C13,B5:B13=E5))","v":"Herbert,Mark,Nicole"}]
[null,"Team 1","Caroline"]
[null,"Team 1","Ellen"]
[null,"Team 2","Herbert"]
[null,"Team 2","Mark"]
[null,"Team 2","Nicole"]
[null,"Team 3","Richard"]
[null,"Team 3","Taylor"]
[null,"Team 3","Wilson"]

{"sheet":"UDF-VBA","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of User Defined Function"]
[]
[null,"Team","Name",null,"Lookup Value","Return Value"]
[null,"Team 1","Abigail",null,"Team 3",{"$f":"VLOOKUPM(E5,B5:C13,2,\",\")","v":{"$error":"#NAME?"}}]
[null,"Team 1","Caroline"]
[null,"Team 1","Ellen"]
[null,"Team 2","Herbert"]
[null,"Team 2","Mark"]
[null,"Team 2","Nicole"]
[null,"Team 3","Richard"]
[null,"Team 3","Taylor"]
[null,"Team 3","Wilson"]

{"sheet":"Practice Sheet","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Practice Here!!"]
[]
[null,"Team","Name",null,"Lookup Value","Return Value"]
[null,"Team 1","Abigail",null,"Team 1"]
[null,"Team 1","Caroline"]
[null,"Team 1","Ellen"]
[null,"Team 2","Herbert"]
[null,"Team 2","Mark"]
[null,"Team 2","Nicole"]
[null,"Team 3","Richard"]
[null,"Team 3","Taylor"]
[null,"Team 3","Wilson"]

{"sheet":"Practice Sheet (2)","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Practice Here!!"]
[]
[null,"Team","Name",null,"Lookup Value","Return Value"]
[null,"Team 1","Abigail",null,"Team 1"]
[null,"Team 1","Caroline"]
[null,"Team 1","Ellen"]
[null,"Team 2","Herbert"]
[null,"Team 2","Mark"]
[null,"Team 2","Nicole"]
[null,"Team 3","Richard"]
[null,"Team 3","Taylor"]
[null,"Team 3","Wilson"]

{"sheet":"Practice Sheet (3)","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Practice Here!!"]
[]
[null,"Team","Name",null,"Lookup Value","Return Value"]
[null,"Team 1","Abigail",null,"Team 1"]
[null,"Team 1","Caroline"]
[null,"Team 1","Ellen"]
[null,"Team 2","Herbert"]
[null,"Team 2","Mark"]
[null,"Team 2","Nicole"]
[null,"Team 3","Richard"]
[null,"Team 3","Taylor"]
[null,"Team 3","Wilson"]