{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CtrlShiftEnter04.5","CtrlShiftEnter04.5 (an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"CtrlShiftEnter04.5","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Ctrl + Shift + Enter: Excel Array Formulas #04.5: Join Array Operation Second Take"]
[]
["Code","L/R?","Qty",null,null,"Qty"]
["2A35-2A36","R",35,null,"Code","L","R"]
["2A35-2A36","L",30,null,"2A35-2A36"]
["2A45-2A46","L",24,null,"2A38-2A39"]
["2A45-2A46","R",18,null,"2A39-2A40"]
["2A46-2A47","R",36,null,"2A44-2A45"]
["2A46-2A47","L",30,null,"2A45-2A46"]
["2A48-2A49","R",24,null,"2A46-2A47"]
["2A44-2A45","R",28,null,"2A48-2A49"]
["2A48-2A49","L",20]
["2A44-2A45","L",18,null,"Milan Kovcin at YouTube, and Mr Excel in Duel #52"]
["2A39-2A40","L",36,null,"Mr Excel & excelisfun Trick 52: Lookup Two Criteria: SUMIFS, DGET, or Array Formula? "]
["2A39-2A40","R",35,null,"https://www.youtube.com/watch?v=JeGzpB5ief4"]
["2A38-2A39","R",36]
["2A38-2A39","L",30]
[]
["Code","L/R?","Machine",null,null,null,"Machine"]
["2A35-2A36","R","PR-23",null,null,"Code","L","R"]
["2A35-2A36","L","CLM-F4",null,null,"2A35-2A36"]
["2A45-2A46","L","CLM-F4",null,null,"2A38-2A39"]
["2A45-2A46","R","CLM-F4",null,null,"2A39-2A40"]
["2A46-2A47","R","CLM-F4",null,null,"2A44-2A45"]
["2A46-2A47","L","CLM-F4",null,null,"2A45-2A46"]
["2A48-2A49","R","PR-23",null,null,"2A46-2A47"]
["2A44-2A45","R","PR-23",null,null,"2A48-2A49"]
["2A48-2A49","L","DD-12"]
["2A44-2A45","L","CLM-F4",null,null,"Text items being retrieved"]
["2A39-2A40","L","PR-23",null,null,"or"]
["2A39-2A40","R","DD-12",null,null,"There were duplicate records"]
["2A38-2A39","R","PR-23"]
["2A38-2A39","L","PR-23"]
["2A38-2A39","L","PR-23"]

{"sheet":"CtrlShiftEnter04.5 (an)","index":1,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Ctrl + Shift + Enter: Excel Array Formulas #04.5: Join Array Operation Second Take"]
[]
["Code","L/R?","Qty",null,null,"Qty"]
["2A35-2A36","R",35,null,"Code","L","R"]
["2A35-2A36","L",30,null,"2A35-2A36",{"$f":"SUMIFS($C$4:$C$17,$A$4:$A$17,$E5,$B$4:$B$17,F$4)","v":30},{"$f":"SUMIFS($C$4:$C$17,$A$4:$A$17,$E5,$B$4:$B$17,G$4)","v":35}]
["2A45-2A46","L",24,null,"2A38-2A39",{"$f":"SUMIFS($C$4:$C$17,$A$4:$A$17,$E6,$B$4:$B$17,F$4)","v":30},36]
["2A45-2A46","R",18,null,"2A39-2A40",36,35]
["2A46-2A47","R",36,null,"2A44-2A45",18,28]
["2A46-2A47","L",30,null,"2A45-2A46",24,18]
["2A48-2A49","R",24,null,"2A46-2A47",30,36]
["2A44-2A45","R",28,null,"2A48-2A49",20,{"$f":"SUMIFS($C$4:$C$17,$A$4:$A$17,$E11,$B$4:$B$17,G$4)","v":24}]
["2A48-2A49","L",20]
["2A44-2A45","L",18,null,"Milan Kovcin at YouTube, and Mr Excel in Duel #52"]
["2A39-2A40","L",36,null,"Mr Excel & excelisfun Trick 52: Lookup Two Criteria: SUMIFS, DGET, or Array Formula? "]
["2A39-2A40","R",35,null,"https://www.youtube.com/watch?v=JeGzpB5ief4"]
["2A38-2A39","R",36]
["2A38-2A39","L",30]
[]
["Code","L/R?","Machine",null,null,null,"Machine"]
["2A35-2A36","R","PR-23",null,null,"Code","L","R"]
["2A35-2A36","L","CLM-F4",null,null,"2A35-2A36",{"$f":"INDEX($C$20:$C$34,MATCH($F21&G$20,$A$20:$A$34&$B$20:$B$34,0))","v":"CLM-F4"},{"$f":"INDEX($C$20:$C$34,MATCH($F21&H$20,$A$20:$A$34&$B$20:$B$34,0))","v":"PR-23"}]
["2A45-2A46","L","CLM-F4",null,null,"2A38-2A39",{"$f":"INDEX($C$20:$C$34,MATCH($F22&G$20,$A$20:$A$34&$B$20:$B$34,0))","v":"PR-23"},{"$f":"INDEX($C$20:$C$34,MATCH($F22&H$20,$A$20:$A$34&$B$20:$B$34,0))","v":"PR-23"}]
["2A45-2A46","R","CLM-F4",null,null,"2A39-2A40",{"$f":"INDEX($C$20:$C$34,MATCH($F23&G$20,$A$20:$A$34&$B$20:$B$34,0))","v":"PR-23"},{"$f":"INDEX($C$20:$C$34,MATCH($F23&H$20,$A$20:$A$34&$B$20:$B$34,0))","v":"DD-12"}]
["2A46-2A47","R","CLM-F4",null,null,"2A44-2A45",{"$f":"INDEX($C$20:$C$34,MATCH($F24&G$20,$A$20:$A$34&$B$20:$B$34,0))","v":"CLM-F4"},{"$f":"INDEX($C$20:$C$34,MATCH($F24&H$20,$A$20:$A$34&$B$20:$B$34,0))","v":"PR-23"}]
["2A46-2A47","L","CLM-F4",null,null,"2A45-2A46",{"$f":"INDEX($C$20:$C$34,MATCH($F25&G$20,$A$20:$A$34&$B$20:$B$34,0))","v":"CLM-F4"},{"$f":"INDEX($C$20:$C$34,MATCH($F25&H$20,$A$20:$A$34&$B$20:$B$34,0))","v":"CLM-F4"}]
["2A48-2A49","R","PR-23",null,null,"2A46-2A47",{"$f":"INDEX($C$20:$C$34,MATCH($F26&G$20,$A$20:$A$34&$B$20:$B$34,0))","v":"CLM-F4"},{"$f":"INDEX($C$20:$C$34,MATCH($F26&H$20,$A$20:$A$34&$B$20:$B$34,0))","v":"CLM-F4"}]
["2A44-2A45","R","PR-23",null,null,"2A48-2A49",{"$f":"INDEX($C$20:$C$34,MATCH($F27&G$20,$A$20:$A$34&$B$20:$B$34,0))","v":"DD-12"},{"$f":"INDEX($C$20:$C$34,MATCH($F27&H$20,$A$20:$A$34&$B$20:$B$34,0))","v":"PR-23"}]
["2A48-2A49","L","DD-12"]
["2A44-2A45","L","CLM-F4",null,null,"Text items being retrieved"]
["2A39-2A40","L","PR-23",null,null,"or"]
["2A39-2A40","R","DD-12",null,null,"There were duplicate records"]
["2A38-2A39","R","PR-23"]
["2A38-2A39","L","PR-23"]
["2A38-2A39","L","PR-23"]