{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Contents","Introduction VLOOKUP","Exact Match","Basic Example","Shifted","Wildcard","Non-exact","Dynamic column"],"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":[]}
["HLOOKUP Function"]
[null,"automateexcel.com/functions/hlookup-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction VLOOKUP",null,null,null,"Excel Formulas w/Examples"]
[null,"Exact Match",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Basic Example",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Shifted"]
[null,"Wildcard"]
[null,"Non-exact"]
[null,"Dynamic column"]
[]
[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 VLOOKUP","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,2,10,3],[11,2,11,3]]}
[]
[null,"VLOOKUP",null,"=VLOOKUP (value, table, col_index, [range_lookup])"]
[null,"VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table."]
[]
[]
[null,"Fruit","Apples","Bananas","Lemons","Oranges","Pears","Almonds","Cashews"]
[null,"Price",8,5,6,5,8,4,9]
[null,"Stock",121,130,132,146,124,146,139]
[]
[]
[null,null,"Fruit",null,null,"Price",null,"Stock"]
[null,null,"Pears",null,null,{"$f":"HLOOKUP(C12,C6:I8,2,FALSE)","v":8},null,{"$f":"HLOOKUP(C12,C6:I8,3,FALSE)","v":124}]
[]
[null,"automateexcel.com/functions/hlookup-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",null,{"$f":"MATCH(D1,A2:A5,0)","v":2}]
["Pineapple"]
["Orange"]
[]
[null,"automateexcel.com/functions/hlookup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Basic Example","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Dan","Bob","Adam","Frank",null,"Basic",null,"Shifted",null,"Wildcard"]
["Class","Writing","Reading","History","Science",null,{"$f":"HLOOKUP(\"Bob\",A1:E3,2,FALSE)","v":"Reading"},null,{"$f":"HLOOKUP(\"Science\", A2:E3, 2, FALSE)","v":"A-"},null,{"$f":"HLOOKUP(\"F*\", A1:E3, 2, FALSE)","v":"Science"}]
["Grade","A+","B-","C","A-"]
[]
[null,"automateexcel.com/functions/hlookup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Shifted","index":4,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Dan","Bob","Adam","Frank",null,"Shifted",null,"Wildcard"]
["Class","Writing","Reading","History","Science",null,{"$f":"HLOOKUP(\"Science\", A2:E3, 2, FALSE)","v":"A-"},null,{"$f":"HLOOKUP(\"F*\", A1:E3, 2, FALSE)","v":"Science"}]
["Grade","A+","B-","C","A-"]
[]
[null,"automateexcel.com/functions/hlookup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Wildcard","index":5,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Dan","Bob","Adam","Frank",null,"Wildcard"]
["Class","Writing","Reading","History","Science",null,{"$f":"HLOOKUP(\"F*\", A1:E3, 2, FALSE)","v":"Science"}]
["Grade","A+","B-","C","A-"]
[]
[null,"automateexcel.com/functions/hlookup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Non-exact","index":6,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Income",0,10000,25000,50000,100000,null,"Your income"]
["Tax Rate",0,0.05,0.15,0.2,0.25,null,45000]
[null,null,null,null,null,null,null,"Tax rate"]
[null,null,null,null,null,null,null,{"$f":"HLOOKUP(H2, A1:F2, 2, TRUE)","v":0.15}]
[]
[null,"automateexcel.com/functions/hlookup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Dynamic column","index":7,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Name","Dan","Bob","Adam","Frank",null,"Data to return"]
["Class","Writing","Reading","History","Science",null,"Grade"]
["Grade","A+","B-","C","A-",null,"Name"]
[null,null,null,null,null,null,"Adam"]
[null,null,null,null,null,null,"Result"]
[null,null,null,null,null,null,{"$f":"HLOOKUP(G4,A1:E3,MATCH(G2,A1:A3,0),0)","v":"C"}]
[]
[null,"automateexcel.com/functions/hlookup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]