{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Contents","Introduction Match","Exact Match","Sorted List Fruit","Sorted List","Descending list","Wildcard match","INDEX MATCH"],"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":[]}
["MATCH Function"]
[null,"automateexcel.com/functions/match-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction Match",null,null,null,"Excel Formulas w/Examples"]
[null,"Exact Match",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Sorted List Fruit",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Sorted List"]
[null,"Descending list"]
[null,"Wildcard match"]
[null,"INDEX MATCH"]
[]
[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 Match","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,4,4,5],[5,4,5,5],[7,4,7,5],[8,4,8,5]]}
[]
[null,"MATCH","=MATCH (lookup_value, lookup_array, [match_type])"]
[null,"Use the MATCH function to get the position of a value in an array."]
[]
[null,"Fruit","ROW Number",null,"Fruit"]
[null,"Apples",1,null,"Lemons"]
[null,"Bananas",2]
[null,"Lemons",3,null,"Count"]
[null,"Oranges",4,null,{"$f":"MATCH(E6,B6:B12,0)","v":3}]
[null,"Pears",5]
[null,"Almonds",6]
[null,"Cashews",7]
[]
[null,"automateexcel.com/functions/match-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Exact Match","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Fruits",null,"Search for:","Apple"]
["Banana",null,"Result:"]
["Apple"]
["Pineapple"]
["Orange"]
[]
[null,"automateexcel.com/functions/match-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sorted List Fruit","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["List",null,"Search for:","Orange"]
["Apple pie",null,"Result:",{"$f":"MATCH(D1,A2:A5,1)","v":2}]
["Banana Bread"]
["Orange Juice"]
["Pineapple Cake"]
[]
[null,"automateexcel.com/functions/match-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sorted List","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["List",null,"Search for:",34]
[10,null,"Result:",{"$f":"MATCH(D1,A2:A5,1)","v":3}]
[20]
[30]
[40]
[]
[null,"automateexcel.com/functions/match-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Descending list","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Container size",null,"Search for:",496]
[1500,null,"Result:",{"$f":"MATCH(D1,A2:A5,-1)","v":2}]
[500]
[250]
[50]
[]
[null,"automateexcel.com/functions/match-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Wildcard match","index":6,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["List",null,"Search for:","Orange*"]
["Apple pie",null,"Result:",{"$f":"MATCH(D1,A2:A5,0)","v":3}]
["Banana Bread"]
["Orange Juice"]
["Pineapple Cake"]
[]
[null,"automateexcel.com/functions/match-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"INDEX MATCH","index":7,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Cost","Fruits",null,"Search for:","Apple"]
[1,"Banana",null,"Result:",{"$f":"INDEX(A2:A5,MATCH(E1,B2:B5,0))","v":2}]
[2,"Apple"]
[5,"Pineapple"]
[4,"Orange"]
[]
[null,"automateexcel.com/functions/match-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]