{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Horisontal","Approximate match","Hor & Vert lookup","INDEX + MATCH","Search multiple tables","VBA Example"],"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":"Horisontal","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column","Item",null,{"$f":"HLOOKUP(C2,B5:E14,C3,FALSE)","v":"DD"}]
[null,"Row",4]
[]
[null,"Invoice","Item","Size","Amount"]
[null,190,"CC","Small",168.26]
[null,131,"BB","Small",155.09]
[null,181,"DD","Small",221.33]
[null,141,"AA","Small",269.93]
[null,165,"HH","Large",408.5]
[null,182,"DD","Small",109.3]
[null,183,"BB","Small",302.82]
[null,177,"BB","Large",103.6]
[null,126,"DD","Medium",375.06]

{"sheet":"Approximate match","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Weight",189]
[null,"Cost",{"$f":"HLOOKUP(C2,C5:F6,2,TRUE)","v":12.1}]
[]
[null,"Weight",0,100,250,500]
[null,"Cost",4.33,12.1,29.72,45.76]

{"sheet":"Hor & Vert lookup","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column","Item",null,{"$f":"HLOOKUP(C2,Table13[#All],MATCH(C3,Table13[[#All],[Invoice]],0),FALSE)","v":"AA"}]
[null,"Invoice",141]
[]
[null,"Invoice","Item","Size","Amount"]
[null,190,"CC","Small",168.26]
[null,131,"BB","Small",155.09]
[null,181,"DD","Small",221.33]
[null,141,"AA","Small",269.93]
[null,165,"HH","Large",408.5]
[null,182,"DD","Small",109.3]
[null,183,"BB","Small",302.82]
[null,177,"BB","Large",103.6]
[null,126,"DD","Medium",375.06]

{"sheet":"INDEX + MATCH","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column","Amount",null,{"$f":"INDEX(B6:E14,C3,MATCH(C2,B5:E5,0))","v":155.09}]
[null,"Row",2]
[]
[null,"Invoice","Item","Size","Amount"]
[null,190,"CC","Small",168.26]
[null,131,"BB","Small",155.09]
[null,181,"DD","Small",221.33]
[null,141,"AA","Small",269.93]
[null,165,"HH","Large",408.5]
[null,182,"DD","Small",109.3]
[null,183,"BB","Small",302.82]
[null,177,"BB","Large",103.6]
[null,126,"DD","Medium",375.06]

{"sheet":"Search multiple tables","index":4,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,1,13,4],[1,1,1,4]]}
[]
[null,"Table50"]
[null,"Invoice","Item","Size","Amount",null,"Table","Column","Row","Formula"]
[null,190,"CC","Small",168.26,null,"Table50[#All]","Size",6,{"$f":"HLOOKUP(H4,INDIRECT(G4),I4,FALSE)","v":"Large"}]
[null,131,"BB","Small",155.09,null,"Table51[#All]","Invoice",4,{"$f":"HLOOKUP(H5,INDIRECT(G5),I5,FALSE)","v":255}]
[null,181,"DD","Small",221.33,null,"Table51[#All]","Item",3,"BB"]
[null,141,"AA","Small",269.93,null,"Table50[#All]","Amount",5,269.93]
[null,165,"HH","Large",408.5]
[null,182,"DD","Small",109.3]
[null,183,"BB","Small",302.82]
[null,177,"BB","Large",103.6]
[null,126,"DD","Medium",375.06]
[]
[null,"Table51"]
[null,"Invoice","Item","Size","Amount"]
[null,298,"AA","Small",34.24]
[null,270,"BB","Small",47.84]
[null,255,"BB","Small",43.76]
[null,245,"BB","Large",19.309999999999999]
[null,242,"CC","Small",20.77]
[null,256,"DD","Small",42.47]
[null,299,"DD","Small",35]
[null,295,"DD","Medium",30.12]
[null,224,"HH","Large",40.17]

{"sheet":"VBA Example","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column","Item"]
[null,"Row",4]
[]
[null,"Invoice","Item","Size","Amount"]
[null,190,"CC","Small",168.26]
[null,131,"BB","Small",155.09]
[null,181,"DD","Small",221.33]
[null,141,"AA","Small",269.93]
[null,165,"HH","Large",408.5]
[null,182,"DD","Small",109.3]
[null,183,"BB","Small",302.82]
[null,177,"BB","Large",103.6]
[null,126,"DD","Medium",375.06]