{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["lookup problem","lookup alternative 1","lookup alternative 2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"lookup problem","index":0,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,10,12,11],[13,10,13,11],[14,10,14,11],[9,10,9,11],[0,1,0,7],[8,10,8,11],[10,10,10,11],[11,10,11,11]]}
[null,"Customer Walk-ins - Last 6 weeks (Big Box Store)"]
[]
[]
[null,"2014-09-29","2014-09-30","2014-10-01","2014-10-02","2014-10-03","2014-10-04","2014-10-05",null,null,"Lookup data for any date:",null,null,"Using INDIRECT formula"]
[null,58312,62441,60467,59783,51276,23450,23557,null,null,"Date","2014-10-15",null,"No. of customers",{"$f":"INDIRECT(ADDRESS(SUMPRODUCT((B4:H14=L5)*((ROW(B4:H14))*ISEVEN(ROW(B4:H14))))+1,SUMPRODUCT((B4:H14=L5)*((COLUMN(B4:H14))*ISEVEN(ROW(B4:H14))))))","v":60978}]
[null,"2014-10-06","2014-10-07","2014-10-08","2014-10-09","2014-10-10","2014-10-11","2014-10-12",null,null,"No. of customers",{"$f":"SUMIFS(B5:H15,B4:H14,L5)","v":60978}]
[null,53194,60236,62079,66489,59258,27140,25181]
[null,"2014-10-13","2014-10-14","2014-10-15","2014-10-16","2014-10-17","2014-10-18","2014-10-19"]
[null,56231,62397,60978,60928,52430,24772,25630]
[null,"2014-10-20","2014-10-21","2014-10-22","2014-10-23","2014-10-24","2014-10-25","2014-10-26",null,null,"SUMIFS Formula"]
[null,59968,61044,57305,54357,48704,22318,23605,null,null,"SUMPRODUCT Formula"]
[null,"2014-10-27","2014-10-28","2014-10-29","2014-10-30","2014-10-31","2014-11-01","2014-11-02",null,null,"VLOOKUP Formula"]
[null,56655,62788,62957,64221,52697,25940,27283,null,null,"INDEX + MATCH Formula"]
[null,"2014-11-03","2014-11-04",null,null,null,null,null,null,null,"SUMIF works in 2D too"]
[null,53490,5302,null,null,null,null,null,null,null,"The VLOOKUP Book"]

{"sheet":"lookup alternative 1","index":1,"n_rows":104,"n_cols":18,"rows_kept":104,"cut":false,"hidden":false,"merged":[[13,13,13,14],[14,13,14,14],[8,13,8,14],[9,13,9,14],[10,13,10,14],[11,13,11,14],[12,13,12,14],[0,1,0,11]]}
[null,"Customer Walk-ins - Last 6 weeks (Big Box Store)"]
[]
[null,"Data",null,null,null,null,null,null,null,"Rearranged Data",null,null,null,"Formulas"]
[null,"2014-09-29","2014-09-30","2014-10-01","2014-10-02","2014-10-03","2014-10-04","2014-10-05",null,"#","Date","Value",null,"Lookup data for any date:",null,null,"Using INDIRECT formula"]
[null,58312,62441,60467,59783,51276,23450,23557,null,0,{"$f":"IFERROR(INDEX(data,2*(INT(J5/7))+1,MOD(J5,7)+1),\"\")","v":"2014-09-29"},{"$f":"IFERROR(INDEX(data,2*(INT(J5/7)+1),MOD(J5,7)+1),\"\")","v":58312},null,"Date","2014-10-15",null,"No. of customers",{"$f":"INDIRECT(ADDRESS(SUMPRODUCT((B4:H14=O5)*((ROW(B4:H14))*ISEVEN(ROW(B4:H14))))+1,SUMPRODUCT((B4:H14=O5)*((COLUMN(B4:H14))*ISEVEN(ROW(B4:H14))))))","v":60978}]
[null,"2014-10-06","2014-10-07","2014-10-08","2014-10-09","2014-10-10","2014-10-11","2014-10-12",null,1,"2014-09-30",62441,null,"No. of customers",{"$f":"VLOOKUP(O5,$K$5:$L$104,2,FALSE)","v":60978}]
[null,53194,60236,62079,66489,59258,27140,25181,null,2,"2014-10-01",60467]
[null,"2014-10-13","2014-10-14","2014-10-15","2014-10-16","2014-10-17","2014-10-18","2014-10-19",null,3,"2014-10-02",59783]
[null,56231,62397,60978,60928,52430,24772,25630,null,4,"2014-10-03",51276]
[null,"2014-10-20","2014-10-21","2014-10-22","2014-10-23","2014-10-24","2014-10-25","2014-10-26",null,5,"2014-10-04",23450,null,"SUMIFS Formula"]
[null,59968,61044,57305,54357,48704,22318,23605,null,6,"2014-10-05",23557,null,"SUMPRODUCT Formula"]
[null,"2014-10-27","2014-10-28","2014-10-29","2014-10-30","2014-10-31","2014-11-01","2014-11-02",null,7,"2014-10-06",53194,null,"VLOOKUP Formula"]
[null,56655,62788,62957,64221,52697,25940,27283,null,8,"2014-10-07",60236,null,"INDEX + MATCH Formula"]
[null,"2014-11-03","2014-11-04",null,null,null,null,null,null,9,"2014-10-08",62079,null,"SUMIF works in 2D too"]
[null,53490,5302,null,null,null,null,null,null,10,"2014-10-09",66489,null,"The VLOOKUP Book"]
[null,null,null,null,null,null,null,null,null,11,"2014-10-10",59258]
[null,null,null,null,null,null,null,null,null,12,"2014-10-11",27140]
[null,null,null,null,null,null,null,null,null,13,"2014-10-12",25181]
[null,null,null,null,null,null,null,null,null,14,"2014-10-13",56231]
[null,null,null,null,null,null,null,null,null,15,"2014-10-14",62397]
[null,null,null,null,null,null,null,null,null,16,"2014-10-15",60978]
[null,null,null,null,null,null,null,null,null,17,"2014-10-16",60928]
[null,null,null,null,null,null,null,null,null,18,"2014-10-17",52430]
[null,null,null,null,null,null,null,null,null,19,"2014-10-18",24772]
[null,null,null,null,null,null,null,null,null,20,"2014-10-19",25630]
[null,null,null,null,null,null,null,null,null,21,"2014-10-20",59968]
[null,null,null,null,null,null,null,null,null,22,"2014-10-21",61044]
[null,null,null,null,null,null,null,null,null,23,"2014-10-22",57305]
[null,null,null,null,null,null,null,null,null,24,"2014-10-23",54357]
[null,null,null,null,null,null,null,null,null,25,"2014-10-24",48704]
[null,null,null,null,null,null,null,null,null,26,"2014-10-25",22318]
[null,null,null,null,null,null,null,null,null,27,"2014-10-26",23605]
[null,null,null,null,null,null,null,null,null,28,"2014-10-27",56655]
[null,null,null,null,null,null,null,null,null,29,"2014-10-28",62788]
[null,null,null,null,null,null,null,null,null,30,"2014-10-29",62957]
[null,null,null,null,null,null,null,null,null,31,"2014-10-30",64221]
[null,null,null,null,null,null,null,null,null,32,{"$f":"IFERROR(INDEX(data,2*(INT(J37/7))+1,MOD(J37,7)+1),\"\")","v":"2014-10-31"},{"$f":"IFERROR(INDEX(data,2*(INT(J37/7)+1),MOD(J37,7)+1),\"\")","v":52697}]
[null,null,null,null,null,null,null,null,null,33,"2014-11-01",25940]
[null,null,null,null,null,null,null,null,null,34,"2014-11-02",27283]
[null,null,null,null,null,null,null,null,null,35,"2014-11-03",53490]
[null,null,null,null,null,null,null,null,null,36,"2014-11-04",5302]
[null,null,null,null,null,null,null,null,null,37,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,38,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,39,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,40,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,41,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,42,"",""]
[null,null,null,null,null,null,null,null,null,43,"",""]
[null,null,null,null,null,null,null,null,null,44,"",""]
[null,null,null,null,null,null,null,null,null,45,"",""]
[null,null,null,null,null,null,null,null,null,46,"",""]
[null,null,null,null,null,null,null,null,null,47,"",""]
[null,null,null,null,null,null,null,null,null,48,"",""]
[null,null,null,null,null,null,null,null,null,49,"",""]
[null,null,null,null,null,null,null,null,null,50,"",""]
[null,null,null,null,null,null,null,null,null,51,"",""]
[null,null,null,null,null,null,null,null,null,52,"",""]
[null,null,null,null,null,null,null,null,null,53,"",""]
[null,null,null,null,null,null,null,null,null,54,"",""]
[null,null,null,null,null,null,null,null,null,55,"",""]
[null,null,null,null,null,null,null,null,null,56,"",""]
[null,null,null,null,null,null,null,null,null,57,"",""]
[null,null,null,null,null,null,null,null,null,58,"",""]
[null,null,null,null,null,null,null,null,null,59,"",""]
[null,null,null,null,null,null,null,null,null,60,"",""]
[null,null,null,null,null,null,null,null,null,61,"",""]
[null,null,null,null,null,null,null,null,null,62,"",""]
[null,null,null,null,null,null,null,null,null,63,"",""]
[null,null,null,null,null,null,null,null,null,64,{"$f":"IFERROR(INDEX(data,2*(INT(J69/7))+1,MOD(J69,7)+1),\"\")","v":""},{"$f":"IFERROR(INDEX(data,2*(INT(J69/7)+1),MOD(J69,7)+1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,65,"",""]
[null,null,null,null,null,null,null,null,null,66,"",""]
[null,null,null,null,null,null,null,null,null,67,"",""]
[null,null,null,null,null,null,null,null,null,68,"",""]
[null,null,null,null,null,null,null,null,null,69,"",""]
[null,null,null,null,null,null,null,null,null,70,"",""]
[null,null,null,null,null,null,null,null,null,71,"",""]
[null,null,null,null,null,null,null,null,null,72,"",""]
[null,null,null,null,null,null,null,null,null,73,"",""]
[null,null,null,null,null,null,null,null,null,74,"",""]
[null,null,null,null,null,null,null,null,null,75,"",""]
[null,null,null,null,null,null,null,null,null,76,"",""]
[null,null,null,null,null,null,null,null,null,77,"",""]
[null,null,null,null,null,null,null,null,null,78,"",""]
[null,null,null,null,null,null,null,null,null,79,"",""]
[null,null,null,null,null,null,null,null,null,80,"",""]
[null,null,null,null,null,null,null,null,null,81,"",""]
[null,null,null,null,null,null,null,null,null,82,"",""]
[null,null,null,null,null,null,null,null,null,83,"",""]
[null,null,null,null,null,null,null,null,null,84,"",""]
[null,null,null,null,null,null,null,null,null,85,"",""]
[null,null,null,null,null,null,null,null,null,86,"",""]
[null,null,null,null,null,null,null,null,null,87,"",""]
[null,null,null,null,null,null,null,null,null,88,"",""]
[null,null,null,null,null,null,null,null,null,89,"",""]
[null,null,null,null,null,null,null,null,null,90,"",""]
[null,null,null,null,null,null,null,null,null,91,"",""]
[null,null,null,null,null,null,null,null,null,92,"",""]
[null,null,null,null,null,null,null,null,null,93,"",""]
[null,null,null,null,null,null,null,null,null,94,"",""]
[null,null,null,null,null,null,null,null,null,95,"",""]
[null,null,null,null,null,null,null,null,null,96,{"$f":"IFERROR(INDEX(data,2*(INT(J101/7))+1,MOD(J101,7)+1),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,97,"",""]
[null,null,null,null,null,null,null,null,null,98,"",""]
[null,null,null,null,null,null,null,null,null,99,"",""]

{"sheet":"lookup alternative 2","index":2,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,12,14,13],[15,12,15,13],[0,1,0,7],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[13,12,13,13]]}
[null,"Customer Walk-ins - Last 6 weeks (Big Box Store)"]
[]
[]
[null,"Data",null,null,null,null,null,null,null,"Rearranged Data (with VBA)",null,null,"Formulas"]
[null,"2014-09-29","2014-09-30","2014-10-01","2014-10-02","2014-10-03","2014-10-04","2014-10-05",null,"Date","Value",null,"Lookup data for any date:",null,null,"Using INDIRECT formula"]
[null,58312,62441,60467,59783,51276,23450,23557,null,"2014-09-29",58312,null,"Date","2014-10-15",null,"No. of customers",{"$f":"INDIRECT(ADDRESS(SUMPRODUCT((B5:H15=N6)*((ROW(B5:H15))*ISEVEN(ROW(B5:H15))))+1,SUMPRODUCT((B5:H15=N6)*((COLUMN(B5:H15))*ISEVEN(ROW(B5:H15))))))","v":{"$error":"#VALUE!"}}]
[null,"2014-10-06","2014-10-07","2014-10-08","2014-10-09","2014-10-10","2014-10-11","2014-10-12",null,"2014-09-30",62441,null,"No. of customers",{"$f":"VLOOKUP(N6,$J$6:$K$105,2,FALSE)","v":60978}]
[null,53194,60236,62079,66489,59258,27140,25181,null,"2014-10-01",60467]
[null,"2014-10-13","2014-10-14","2014-10-15","2014-10-16","2014-10-17","2014-10-18","2014-10-19",null,"2014-10-02",59783]
[null,56231,62397,60978,60928,52430,24772,25630,null,"2014-10-03",51276]
[null,"2014-10-20","2014-10-21","2014-10-22","2014-10-23","2014-10-24","2014-10-25","2014-10-26",null,"2014-10-04",23450,null,"SUMIFS Formula"]
[null,59968,61044,57305,54357,48704,22318,23605,null,"2014-10-05",23557,null,"SUMPRODUCT Formula"]
[null,"2014-10-27","2014-10-28","2014-10-29","2014-10-30","2014-10-31","2014-11-01","2014-11-02",null,"2014-10-06",53194,null,"VLOOKUP Formula"]
[null,56655,62788,62957,64221,52697,25940,27283,null,"2014-10-07",60236,null,"INDEX + MATCH Formula"]
[null,"2014-11-03","2014-11-04",null,null,null,null,null,null,"2014-10-08",62079,null,"SUMIF works in 2D too"]
[null,53490,5302,null,null,null,null,null,null,"2014-10-09",66489,null,"The VLOOKUP Book"]
[null,null,null,null,null,null,null,null,null,"2014-10-10",59258]
[null,null,null,null,null,null,null,null,null,"2014-10-11",27140]
[null,null,null,null,null,null,null,null,null,"2014-10-12",25181]
[null,null,null,null,null,null,null,null,null,"2014-10-13",56231]
[null,null,null,null,null,null,null,null,null,"2014-10-14",62397]
[null,null,null,null,null,null,null,null,null,"2014-10-15",60978]
[null,null,null,null,null,null,null,null,null,"2014-10-16",60928]
[null,null,null,null,null,null,null,null,null,"2014-10-17",52430]
[null,null,null,null,null,null,null,null,null,"2014-10-18",24772]
[null,null,null,null,null,null,null,null,null,"2014-10-19",25630]
[null,null,null,null,null,null,null,null,null,"2014-10-20",59968]
[null,null,null,null,null,null,null,null,null,"2014-10-21",61044]
[null,null,null,null,null,null,null,null,null,"2014-10-22",57305]
[null,null,null,null,null,null,null,null,null,"2014-10-23",54357]
[null,null,null,null,null,null,null,null,null,"2014-10-24",48704]
[null,null,null,null,null,null,null,null,null,"2014-10-25",22318]
[null,null,null,null,null,null,null,null,null,"2014-10-26",23605]
[null,null,null,null,null,null,null,null,null,"2014-10-27",56655]
[null,null,null,null,null,null,null,null,null,"2014-10-28",62788]
[null,null,null,null,null,null,null,null,null,"2014-10-29",62957]
[null,null,null,null,null,null,null,null,null,"2014-10-30",64221]
[null,null,null,null,null,null,null,null,null,"2014-10-31",52697]
[null,null,null,null,null,null,null,null,null,"2014-11-01",25940]
[null,null,null,null,null,null,null,null,null,"2014-11-02",27283]
[null,null,null,null,null,null,null,null,null,"2014-11-03",53490]
[null,null,null,null,null,null,null,null,null,"2014-11-04",5302]