{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contents","Introduction INDIRECT","Sheet Name","Workbook Name","Dynamic range","Data Validation"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["INDIRECT Function"]
[null,"automateexcel.com/functions/indirect-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction INDIRECT",null,null,null,"Excel Formulas w/Examples"]
[null,"Sheet Name",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Workbook Name",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Dynamic range"]
[null,"Data Validation"]
[]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction INDIRECT","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INDIRECT",null,"=INDIRECT (ref_text, [a1])"]
[null,"The Excel INDIRECT function returns a valid reference from a given text string"]
[]
[null,"Sheet","Detail"]
[null,"Sheet A",{"$f":"INDIRECT(\"'\"&B6&\"'\"&\"!A1\")","v":{"$error":"#REF!"}}]
[null,"Sheet B",{"$f":"INDIRECT(\"'\"&B7&\"'\"&\"!A1\")","v":{"$error":"#REF!"}}]
[null,"Sheet C",{"$f":"INDIRECT(\"'\"&B8&\"'\"&\"!A1\")","v":{"$error":"#REF!"}}]
[null,"Sheet D",{"$f":"INDIRECT(\"'\"&B9&\"'\"&\"!A1\")","v":{"$error":"#REF!"}}]
[null,"Sheet E",{"$f":"INDIRECT(\"'\"&B10&\"'\"&\"!A1\")","v":{"$error":"#REF!"}}]
[]
[null,"automateexcel.com/functions/indirect-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sheet Name","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Sheet","Column","Row"]
["Sheet2","B",5,null,"=INDIRECT(\"'\" & A2 & \"'!\" & B2 & C2)"]
[]
[null,"automateexcel.com/functions/indirect-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Workbook Name","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Workbook","Sheet"]
["Sample.xlsx","Summary",null," =INDIRECT(\"'[\" & A2 & \"]\" & B2 & \"'!C7\")"]
[]
[null,"automateexcel.com/functions/indirect-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Dynamic range","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Sales",null,"Count of items"]
[5,null,{"$f":"COUNTA(A:A)","v":5}]
[10]
[20]
[25]
[]
[null,"automateexcel.com/functions/indirect-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Data Validation","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["First Choice","Next Choice",null,"Fruits","Vegetables","Meats"]
["Fruits","Banana",null,"Apple","Green beans","Pork"]
["Meats","Beef",null,"Banana","Peas","Chicken"]
["Vegetables",null,null,"Oranges","Broccoli","Beef"]
[null,null,null,"Pineapple",null,"Fish"]
[]
[null,"automateexcel.com/functions/indirect-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]