{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Dataset","VlookupforMultipleMatches(1.1.)","VlookupforMultipleMatches(1.2.)","VlookupforMultipleMatches(1.3.)","UserDefinedFunction(2.1.)","UserDefinedFunction(2.2.)","using Vlookup formula","VlookupFormulaMultipleCriteria"],"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":"Sample Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Rep Name","Item","Units"]
[null,"Jones","Pencil",53]
[null,"Kivell","Desk",89]
[null,"Jardine","Highlighter ",56]
[null,"Gill","Pen",62]
[null,"Sorvino","Pen Set",57]
[null,"Thompson","Binder",59]
[null,"Andrews","Marker",83]
[null,"Jardine","Eraser",99]
[null,"Thompson","Stapler",83]
[null,"Jones","Sharpener",71]

{"sheet":"VlookupforMultipleMatches(1.1.)","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,2,15,3],[16,2,16,3]]}
[]
[null,"Vlookup for Multiple Matches with Separators"]
[]
[null,"Rep Name","Item","Units"]
[null,"Jones","Pencil",53]
[null,"Kivell","Desk",89]
[null,"Jardine","Highlighter ",56]
[null,"Gill","Pen",62]
[null,"Sorvino","Pen Set",57]
[null,"Thompson","Binder",59]
[null,"Andrews","Marker",83]
[null,"Jardine","Eraser",99]
[null,"Thompson","Stapler",83]
[null,"Jones","Sharpener",71]
[]
[null,"Rep Name","Item"]
[null,"Jones","Pencil, Sharpener"]

{"sheet":"VlookupforMultipleMatches(1.2.)","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Vlookup for Multiple Matches in Separate Cells Vertically"]
[]
[null,"Rep Name","Item","Units",null,"Rep Name","Item"]
[null,"Jones","Pencil",53,null,"Jones","Pencil"]
[null,"Kivell","Desk",89,null,null,"Sharpener"]
[null,"Jardine","Highlighter ",56]
[null,"Gill","Pen",62]
[null,"Sorvino","Pen Set",57]
[null,"Thompson","Binder",59]
[null,"Andrews","Marker",83]
[null,"Jardine","Eraser",99]
[null,"Thompson","Stapler",83]
[null,"Jones","Sharpener",71]

{"sheet":"VlookupforMultipleMatches(1.3.)","index":3,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,2,15,3]]}
[]
[null,"Vlookup for Multiple Matches in Separate Cells Horizontally"]
[]
[null,"Rep Name","Item","Units"]
[null,"Jones","Pencil",53]
[null,"Kivell","Desk",89]
[null,"Jardine","Highlighter ",56]
[null,"Gill","Pen",62]
[null,"Sorvino","Pen Set",57]
[null,"Thompson","Binder",59]
[null,"Andrews","Marker",83]
[null,"Jardine","Eraser",99]
[null,"Thompson","Stapler",83]
[null,"Jones","Sharpener",71]
[]
[null,"Rep Name","Item"]
[null,"Jones","Pencil","Sharpener"]

{"sheet":"UserDefinedFunction(2.1.)","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6],[15,1,15,6]]}
[]
[null,"User Defined Function to Vlookup for Multiple Matches "]
[]
[null,"Rep Name","Item","Units",null,"Rep Name","Item"]
[null,"Jones","Pencil",53,null,"Jones",{"$f":"Vlookup_Multimatch(F5,B4:C14,2)","v":"Pencil, Sharpener"}]
[null,"Kivell","Desk",89,null,"Kivell",{"$f":"Vlookup_Multimatch(F6,B5:C15,2)","v":"Desk, Pen Set"}]
[null,"Jardine","Highlighter ",56,null,"Jardine",{"$f":"Vlookup_Multimatch(F7,B6:C16,2)","v":"Highlighter , Eraser"}]
[null,"Gill","Pen",62,null,"Gill",{"$f":"Vlookup_Multimatch(F8,B7:C17,2)","v":"Pen"}]
[null,"Kivell","Pen Set",57,null,"Thompson",{"$f":"Vlookup_Multimatch(F9,B8:C18,2)","v":"Binder, Stapler"}]
[null,"Thompson","Binder",59,null,"Andrews",{"$f":"Vlookup_Multimatch(F10,B9:C19,2)","v":"Marker"}]
[null,"Andrews","Marker",83]
[null,"Jardine","Eraser",99]
[null,"Thompson","Stapler",83]
[null,"Jones","Sharpener",71]
[]
[null,"User Defined Function Vlookup_Multimatch Syntax"]
[null," =Vlookup_Multimatch(Lookup_Value,Cell_Range, Column_Index)"]

{"sheet":"UserDefinedFunction(2.2.)","index":5,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,1,15,6],[1,1,1,6]]}
[]
[null,"User Defined Function to Vlookup for Multiple Matches Without Repetition"]
[]
[null,"Rep Name","Item","Units",null,"Rep Name","Item"]
[null,"Jones","Pencil",53,null,"Jones",{"$f":"Vlookup_Multimatch_NoRept(F5,B4:C14,2)","v":" Pencil"}]
[null,"Kivell","Desk",89,null,"Kivell",{"$f":"Vlookup_Multimatch_NoRept(F6,B5:C15,2)","v":" Desk, Pen Set"}]
[null,"Jardine","Highlighter ",56,null,"Jardine",{"$f":"Vlookup_Multimatch_NoRept(F7,B6:C16,2)","v":" Highlighter , Eraser"}]
[null,"Gill","Pen",62,null,"Gill",{"$f":"Vlookup_Multimatch_NoRept(F8,B7:C17,2)","v":" Pen"}]
[null,"Kivell","Pen Set",57,null,"Thompson",{"$f":"Vlookup_Multimatch_NoRept(F9,B8:C18,2)","v":" Binder, Stapler"}]
[null,"Thompson","Binder",59,null,"Andrews",{"$f":"Vlookup_Multimatch_NoRept(F10,B9:C19,2)","v":" Marker"}]
[null,"Andrews","Marker",83]
[null,"Jardine","Eraser",99]
[null,"Thompson","Stapler",83]
[null,"Jones","Pencil",71]
[]
[null,"User Defined Function Vlookup_Multimatch_NoRept Syntax"]
[null," =Vlookup_Multimatch_NoRept(Lookup_Value,Cell_Range, Column_Index)"]

{"sheet":"using Vlookup formula","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[8,5,8,10],[9,5,9,10]]}
[]
[null,"Vlookup for Multiple Matches with Formula"]
[]
[null,"Rep Name","Item","Units",null,"Rep Name","Item"]
[null,"Jones","Pencil",53,null,"Thompson",{"$f":"_xlfn._xlws.FILTER($C$5:$C$14,$B$5:$B$14=$F$5)","v":"Binder"}]
[null,"Kivell","Desk",89,null,null,"Stapler"]
[null,"Jardine","Highlighter ",56]
[null,"Gill","Pen",62]
[null,"Sorvino","Pen Set",57,null," Filter Function Syntax"]
[null,"Thompson","Binder",59,null," =FILTER(array, include, [if_empty])"]
[null,"Andrews","Marker",83]
[null,"Jardine","Eraser",99]
[null,"Thompson","Stapler",83]
[null,"Jones","Sharpener",71]

{"sheet":"VlookupFormulaMultipleCriteria","index":7,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[8,5,8,10],[9,5,10,12]]}
[]
[null,"Vlookup for Multiple Matches with Formula"]
[]
[null,"Rep Name","Item","Units",null,"Rep Name","Item","Units"]
[null,"Jones","Pencil",53,null,"Thompson","Stapler",{"$f":"VLOOKUP(F5, IF(C5:C14=G5, B5:D14, \"\"), 3, FALSE)","v":83}]
[null,"Kivell","Desk",89]
[null,"Jardine","Highlighter ",56]
[null,"Gill","Pen",62]
[null,"Sorvino","Pen Set",57,null,"VLOOKUP Function Syntax"]
[null,"Thompson","Binder",59,null," =VLOOKUP(lookup_value, table_array,                                                 column_index_num, [range_lookup])"]
[null,"Andrews","Marker",83]
[null,"Jardine","Eraser",99]
[null,"Thompson","Stapler",83]
[null,"Jones","Sharpener",71]