{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Overview","Approximate match","Related tables","Dynamic arguments","INDEX + MATCH","VLOOKUP error","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Overview","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Lookup value","Returned value"]
[null,"AA-1611",{"$f":"VLOOKUP(B3,Table1[],4,FALSE)","v":30}]
[]
[null,"Item","Description","Color","Amount"]
[null,"AA-1219","Large","Black",29]
[null,"AA-1423","Small","Blue",22]
[null,"AA-1847","Large","White",27]
[null,"AA-1300","Large","Green",25]
[null,"AA-1534","Small","Green",21]
[null,"AA-1309","Medium","Gray",15]
[null,"AA-1269","Medium","Blue",10]
[null,"AA-1964","Medium","Black",14]
[null,"AA-1583","Large","White",24]
[null,"AA-1934","Large","Brown",25]
[null,"AA-1611","Large","Green",30]
[null,"AA-1307","Large","Blue",17]
[null,"AA-1845","Small","Blue",11]

{"sheet":"Approximate match","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Weight","Amount"]
[null,158,{"$f":"VLOOKUP(Table11[Weight],Table12[],2,TRUE)","v":15}]
[]
[null,"Weight","Amount"]
[null,0,10]
[null,100,15]
[null,200,25]
[null,500,70]
[null,1000,90]
[null,5000,150]
[null,10000,249]

{"sheet":"Related tables","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Invoice","Product","Amount","Company","Region"]
[null,109,"AA-1219",29,{"$f":"VLOOKUP($B3, $B$18:$D$30, COLUMN(B2),FALSE)","v":"AA"},{"$f":"VLOOKUP($B3, $B$18:$D$30, COLUMN(C2),FALSE)","v":"East"}]
[null,117,"AA-1423",22,"BB","East"]
[null,149,"AA-1847",27,"CC","North"]
[null,108,"AA-1300",25,"DD","North"]
[null,147,"AA-1534",21,"EE","East"]
[null,118,"AA-1309",15,"FF","East"]
[null,111,"AA-1269",10,"GG","West"]
[null,114,"AA-1964",14,"HH","South"]
[null,134,"AA-1583",24,"II","West"]
[null,105,"AA-1934",25,"JJ","South"]
[null,112,"AA-1611",30,"KK","South"]
[null,123,"AA-1307",17,"LL","North"]
[null,124,"AA-1845",11,"MM","East"]
[]
[null,"Invoice","Company","Region"]
[null,147,"EE","East"]
[null,118,"FF","East"]
[null,108,"DD","North"]
[null,149,"CC","North"]
[null,105,"JJ","South"]
[null,117,"BB","East"]
[null,114,"HH","South"]
[null,109,"AA","East"]
[null,112,"KK","South"]
[null,134,"II","West"]
[null,124,"MM","East"]
[null,111,"GG","West"]
[null,123,"LL","North"]

{"sheet":"Dynamic arguments","index":3,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,1,5,4],[21,1,21,4]]}
[]
[null,"Lookup value","table_array","col_index_num","Returned value"]
[null,"AA-1611","table10",3,{"$f":"VLOOKUP(B3,INDIRECT(C3),D3,FALSE)","v":"Green"}]
[null,"AA-1219","table20",4,{"$f":"VLOOKUP(B4,INDIRECT(C4),D4,FALSE)","v":93}]
[]
[null,"table10"]
[null,"Item","Description","Color","Amount"]
[null,"AA-1219","Large","Black",29]
[null,"AA-1423","Small","Blue",22]
[null,"AA-1847","Large","White",27]
[null,"AA-1300","Large","Green",25]
[null,"AA-1534","Small","Green",21]
[null,"AA-1309","Medium","Gray",15]
[null,"AA-1269","Medium","Blue",10]
[null,"AA-1964","Medium","Black",14]
[null,"AA-1583","Large","White",24]
[null,"AA-1934","Large","Brown",25]
[null,"AA-1611","Large","Green",30]
[null,"AA-1307","Large","Blue",17]
[null,"AA-1845","Small","Blue",11]
[]
[null,"table20"]
[null,"Item","Description","Color","Amount"]
[null,"AA-1219","Large","Green",93]
[null,"AA-1423","Small","Green",72]
[null,"AA-1847","Small","Brown",10]
[null,"AA-1300","Large","Black",63]
[null,"AA-1534","Small","Blue",95]
[null,"AA-1309","Large","Blue",40]
[null,"AA-1269","Medium","White",13]
[null,"AA-1964","Medium","Black",12]
[null,"AA-1583","Large","White",45]
[null,"AA-1934","Large","Green",89]
[null,"AA-1611","Large","Blue",95]
[null,"AA-1307","Medium","Gray",74]
[null,"AA-1845","Large","Blue",66]

{"sheet":"INDEX + MATCH","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Lookup value","Returned value"]
[null,null,null,"AA-1611",{"$f":"INDEX(Table5[Amount],MATCH(D3,Table5[Item],0))","v":30}]
[]
[null,"Row",null,"Description","Item","Color","Amount"]
[null,1,null,"Large","AA-1219","Black",29]
[null,2,null,"Small","AA-1423","Blue",22]
[null,3,null,"Large","AA-1847","White",27]
[null,4,null,"Large","AA-1300","Green",25]
[null,5,null,"Small","AA-1534","Green",21]
[null,6,null,"Medium","AA-1309","Gray",15]
[null,7,null,"Medium","AA-1269","Blue",10]
[null,8,null,"Medium","AA-1964","Black",14]
[null,9,null,"Large","AA-1583","White",24]
[null,10,null,"Large","AA-1934","Brown",25]
[null,11,null,"Large","AA-1611","Green",30]
[null,12,null,"Large","AA-1307","Blue",17]
[null,13,null,"Small","AA-1845","Blue",11]

{"sheet":"VLOOKUP error","index":5,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Lookup value","Returned value"]
[null,"AA-1629",{"$f":"IFERROR(VLOOKUP(B3,Table116[],4,FALSE),\"NOT FOUND!\")","v":"NOT FOUND!"}]
[]
[null,"Item","Description","Color","Amount"]
[null,"AA-1219","Large","Black",29]
[null,"AA-1423","Small","Blue",22]
[null,"AA-1847","Large","White",27]
[null,"AA-1300","Large","Green",25]
[null,"AA-1534","Small","Green",21]
[null,"AA-1309","Medium","Gray",15]
[null,"AA-1269","Medium","Blue",10]
[null,"AA-1964","Medium","Black",14]
[null,"AA-1583","Large","White",24]
[null,"AA-1934","Large","Brown",25]
[null,"AA-1611","Large","Green",30]
[null,"AA-1307","Large","Blue",17]
[null,"AA-1845","Small","Blue",11]

{"sheet":"VBA","index":6,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Lookup value","AA-1611"]
[]
[]
[null,"Item","Description","Color","Amount"]
[null,"AA-1219","Large","Black",29]
[null,"AA-1423","Small","Blue",22]
[null,"AA-1847","Large","White",27]
[null,"AA-1300","Large","Green",25]
[null,"AA-1534","Small","Green",21]
[null,"AA-1309","Medium","Gray",15]
[null,"AA-1269","Medium","Blue",10]
[null,"AA-1964","Medium","Black",14]
[null,"AA-1583","Large","White",24]
[null,"AA-1934","Large","Brown",25]
[null,"AA-1611","Large","Green",30]
[null,"AA-1307","Large","Blue",17]
[null,"AA-1845","Small","Blue",11]