{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Title","Data","Jan 2018","Feb 2018","Mar 2018","Apr 2018","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":0,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2173]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: JuliaBoldt / Pixabay"]

{"sheet":"Data","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Product","Date","Price","Formula"]
["Lime","2018-01-15",{"$f":"VLOOKUP(A2,INDIRECT(\"'\"&TEXT(B2,\"mmm yyyyy\")&\"'!A1:G13\"),7,FALSE)","v":113},{"$f":"_xlfn.FORMULATEXT(C2)","v":"=VLOOKUP(A2,INDIRECT(\"'\"&TEXT(B2,\"mmm yyyyy\")&\"'!A1:G13\"),7,FALSE)"}]
["Elderberry","2018-02-14",{"$f":"VLOOKUP(A3,INDIRECT(\"'\"&TEXT(B3,\"mmm yyyyy\")&\"'!A1:G13\"),7,FALSE)","v":206}]
["Banana","2018-02-17",203]
["Banana","2018-04-15",403]
["Banana","2018-01-10",103]
["Banana","2018-02-07",203]
["Honeydew","2018-02-09",209]
["Lime","2018-03-16",313]
["Kiwi","2018-01-15",112]
["Cherry","2018-03-28",304]
["Jackfruit","2018-03-15",311]
["Fig","2018-02-16",207]
["Jackfruit","2018-03-12",311]
["Date","2018-03-07",305]
["Iceberg","2018-04-21",410]
["Banana","2018-02-28",203]
["Iceberg","2018-01-07",110]
["Kiwi","2018-02-07",212]
["Lime","2018-04-16",413]
["Lime","2018-01-30",113]
["Honeydew","2018-01-22",109]
["Jackfruit","2018-02-25",211]
["Apple","2018-03-27",302]
["Iceberg","2018-04-02",410]
["Jackfruit","2018-04-22",411]
["Lime","2018-02-26",213]
["Honeydew","2018-04-15",409]
["Guava","2018-03-28",308]

{"sheet":"Jan 2018","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Product","Data","Data","Data","Data","Data","Price"]
["Apple","Data","Data","Data","Data","Data",{"$f":"100+ROW()","v":102}]
["Banana","Data","Data","Data","Data","Data",{"$f":"100+ROW()","v":103}]
["Cherry","Data","Data","Data","Data","Data",104]
["Date","Data","Data","Data","Data","Data",105]
["Elderberry","Data","Data","Data","Data","Data",106]
["Fig","Data","Data","Data","Data","Data",107]
["Guava","Data","Data","Data","Data","Data",108]
["Honeydew","Data","Data","Data","Data","Data",109]
["Iceberg","Data","Data","Data","Data","Data",110]
["Jackfruit","Data","Data","Data","Data","Data",111]
["Kiwi","Data","Data","Data","Data","Data",112]
["Lime","Data","Data","Data","Data","Data",113]

{"sheet":"Feb 2018","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Product","Data","Data","Data","Data","Data","Price"]
["Apple","Data","Data","Data","Data","Data",{"$f":"200+ROW()","v":202}]
["Banana","Data","Data","Data","Data","Data",203]
["Cherry","Data","Data","Data","Data","Data",204]
["Date","Data","Data","Data","Data","Data",205]
["Elderberry","Data","Data","Data","Data","Data",206]
["Fig","Data","Data","Data","Data","Data",207]
["Guava","Data","Data","Data","Data","Data",208]
["Honeydew","Data","Data","Data","Data","Data",209]
["Iceberg","Data","Data","Data","Data","Data",210]
["Jackfruit","Data","Data","Data","Data","Data",211]
["Kiwi","Data","Data","Data","Data","Data",212]
["Lime","Data","Data","Data","Data","Data",213]

{"sheet":"Mar 2018","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Product","Data","Data","Data","Data","Data","Price"]
["Apple","Data","Data","Data","Data","Data",{"$f":"300+ROW()","v":302}]
["Banana","Data","Data","Data","Data","Data",303]
["Cherry","Data","Data","Data","Data","Data",304]
["Date","Data","Data","Data","Data","Data",305]
["Elderberry","Data","Data","Data","Data","Data",306]
["Fig","Data","Data","Data","Data","Data",307]
["Guava","Data","Data","Data","Data","Data",308]
["Honeydew","Data","Data","Data","Data","Data",309]
["Iceberg","Data","Data","Data","Data","Data",310]
["Jackfruit","Data","Data","Data","Data","Data",311]
["Kiwi","Data","Data","Data","Data","Data",312]
["Lime","Data","Data","Data","Data","Data",313]

{"sheet":"Apr 2018","index":5,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Product","Data","Data","Data","Data","Data","Price"]
["Apple","Data","Data","Data","Data","Data",{"$f":"400+ROW()","v":402}]
["Banana","Data","Data","Data","Data","Data",403]
["Cherry","Data","Data","Data","Data","Data",404]
["Date","Data","Data","Data","Data","Data",405]
["Elderberry","Data","Data","Data","Data","Data",406]
["Fig","Data","Data","Data","Data","Data",407]
["Guava","Data","Data","Data","Data","Data",408]
["Honeydew","Data","Data","Data","Data","Data",409]
["Iceberg","Data","Data","Data","Data","Data",410]
["Jackfruit","Data","Data","Data","Data","Data",411]
["Kiwi","Data","Data","Data","Data","Data",412]
["Lime","Data","Data","Data","Data","Data",413]

{"sheet":"Wrap Up","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Rhonda from Cincinnati: How to look up both row and worksheet?"]
[null,"Use the Date column to figure out which sheet to use"]
[null,"Step 1: Build a regular VLOOKUP and use FORMULATEXT to see what the reference should look like"]
[null,"Step 2: Use Concatenation and the TEXT function to build a reference that looks like the table array reference in the formula"]
[null,"Step 3: Build your VLOOKUP, but for the table array, use INDIRECT( results from step 2)"]
[null,"Step 4: Copy the formula from Step 2 (without the equals sign) and paste in to the formula from step 3"]