{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Contents","Introduction VLOOKUP","Exact Match","Basic Example","Shift","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":[]}
["VLOOKUP Function"]
[null,"automateexcel.com/functions/vlookup-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,"Shift"]
[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":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,5,5,7],[6,5,6,7]]}
[]
[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","Price","Stock"]
[null,"Apples",8,121,null,"Fruit"]
[null,"Bananas",5,130,null,"Pears"]
[null,"Lemons",6,132]
[null,"Oranges",5,146,null,"Price",null,"Stock"]
[null,"Pears",8,124,null,{"$f":"VLOOKUP(F7,B5:D12,2,FALSE)","v":8},null,{"$f":"VLOOKUP(F7,B5:D12,3,FALSE)","v":124}]
[null,"Almonds",4,146]
[null,"Cashews",9,139]
[]
[null,"automateexcel.com/functions/vlookup-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/vlookup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

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

{"sheet":"Shift","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Name","Class","Grade",null,"Shifted"]
["Dan","Writing","A+",null,{"$f":"VLOOKUP(\"Science\",B2:C5,2,FALSE)","v":"A-"}]
["Bob","Reading","B-"]
["Adam","History","C"]
["Frank","Science","A-"]
[]
[null,"automateexcel.com/functions/vlookup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

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

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

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