{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contents","Introduction INDEX","Basic Example","Multiplication Table","Multiplication Table Month","Match Example"],"not_rendered":{"charts":0,"images":2,"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":[]}
["INDEX Function"]
[null,"automateexcel.com/functions/index-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction INDEX",null,null,null,"Excel Formulas w/Examples"]
[null,"Basic Example",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Multiplication Table",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Multiplication Table Month"]
[null,"Match Example"]
[]
[]
[]
[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 INDEX","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,5,7,6],[8,5,8,6]]}
[]
[null,"INDEX",null,"=INDEX (array, row_num, [col_num], [area_num])"]
[null,"The Excel INDEX function returns the value at a given position in a range or array."]
[]
[null,"Fruit","Price","Count",null,"Row","Column"]
[null,"Apples",8,121,null,5,3]
[null,"Bananas",5,130]
[null,"Lemons",6,132,null,"Result"]
[null,"Oranges",5,146,null,{"$f":"INDEX(B6:D12,F6,G6)","v":124}]
[null,"Pears",8,124]
[null,"Almonds",4,146]
[null,"Cashews",9,139]
[]
[null,"automateexcel.com/functions/index-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Basic Example","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Fruits",null,"Search for:",3]
["Banana",null,"Result:",{"$f":"INDEX(A2:A5,D1)","v":"Pineapple"}]
["Apple"]
["Pineapple"]
["Orange"]
[]
[null,"automateexcel.com/functions/index-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Multiplication Table","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,1,2,3,4,null,"Result:"]
[1,1,2,3,4,null,{"$f":"INDEX(B2:E5, 3, 4)","v":12}]
[2,2,4,6,8]
[3,3,6,9,12]
[4,4,8,12,16]
[]
[null,"automateexcel.com/functions/index-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Multiplication Table Month","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,1,2,3,null,"Result:"]
[1,"Jan","Feb","Mar",null,{"$f":"INDEX(B2:D5, 3, 2)","v":"Aug"}]
[2,"Apr","May","Jun"]
[3,"Jul","Aug","Sep"]
[4,"Oct","Nov","Dec"]
[]
[null,"automateexcel.com/functions/index-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Match Example","index":5,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Grade book","Adam","Bob","Charlie","Dan",null,"Subject:","Reading"]
["Math",97,91,88,86,null,"Student:","Bob"]
["Science",98,99,96,91,null,"Formula:",{"$f":"INDEX(B2:E5,MATCH(H1,A2:A5,0),MATCH(H2,B1:E1,0))","v":89}]
["Reading",93,89,97,98]
["Writing",95,90,90,91]
[]
[null,"automateexcel.com/functions/index-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]