{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Examples Section","Balance Sheet Solution","Two Dim INDEX Example","MATCH Example","Case Sensitive MATCH Example","Multiple Criteria Example","Grading Example"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":35,"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":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"SumProduct"}]
[null,null,{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Some basic illustrations of how INDEX and MATCH may be used."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[]
[]
[null,1,"Table of Contents"]
[]
[null,null,null,null,null,"Cover"]
[null,null,null,null,null,"Style Guide"]
[null,null,null,null,null,"Model Parameters"]
[null,null,null,null,null,"Examples Section"]
[null,null,null,null,null,"Balance Sheet Solution"]
[null,null,null,null,null,"Two Dim INDEX Example"]
[null,null,null,null,null,"MATCH Example"]
[null,null,null,null,null,"Case Sensitive MATCH Example"]
[null,null,null,null,null,"Multiple Criteria Example"]
[null,null,null,null,null,"Grading Example"]

{"sheet":"Style Guide","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[16,2,16,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Style Guide"}]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Formatting of Headers / Dividers"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Sheet Title",null,null,null,null,null,{"$f":"C10","v":"Sheet Title"},null,"Sheet Title"]
[null,null,"Model Name",null,null,null,null,null,{"$f":"C11","v":"Model Name"},null,"Model Name"]
[]
[null,null,"Header 1",null,null,null,null,null,{"$f":"C13","v":"Header 1"},null,"Header 1"]
[null,null,"Header 2",null,null,null,null,null,{"$f":"C14","v":"Header 2"},null,"Header 2"]
[null,null,"Header 3",null,null,null,null,null,{"$f":"C15","v":"Header 3"},null,"Header 3"]
[null,null,"Header 4",null,null,null,null,null,{"$f":"C16","v":"Header 4"},null,"Header 4"]
[]
[null,null,"Notes",null,null,null,null,null,{"$f":"C18","v":"Notes"},null,"Notes"]
[]
[null,null,"Table Heading",null,null,null,null,null,{"$f":"C20","v":"Table Heading"},null,"Table Heading"]
[]
[]
[null,{"$f":"MAX($B$5:$B22)+1","v":2},"Individual Cell Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Assumption",null,null,null,null,null,"Assumption",null,{"$f":"C27","v":"Assumption"}]
[]
[null,null,"Constraint",null,null,null,null,null,{"$f":"C29","v":"Constraint"},null,{"$f":"C29","v":"Constraint"}]
[]
[null,null,"Empty",null,null,null,null,null,null,null,{"$f":"C31","v":"Empty"}]
[]
[null,null,"Error Check",null,null,null,null,null,0,null,{"$f":"C33","v":"Error Check"}]
[]
[null,null,"Hyperlink",null,null,null,null,null,"Hyperlink",null,{"$f":"C35","v":"Hyperlink"}]
[]
[null,null,"Internal Reference",null,null,null,null,null,{"$f":"'Model Parameters'!E31","v":"Thousand"},null,{"$f":"C37","v":"Internal Reference"}]
[]
[null,null,"Line Calculation",null,null,null,null,null,77,null,"Line Calc"]
[]
[null,null,"Line Total",null,null,null,null,null,{"$f":"I39","v":77},null,{"$f":"C41","v":"Line Total"}]
[]
[null,null,"Parameter",null,null,null,null,null,365,null,{"$f":"C43","v":"Parameter"}]
[]
[null,null,"Range Name Description",null,null,null,null,null,"Not_Named",null,{"$f":"C45","v":"Range Name Description"}]
[]
[null,null,"Row Reference",null,null,null,null,null,{"$f":"ROW(C47)","v":47},null,"Row Ref"]
[]
[null,null,"Row Summary",null,null,null,null,null,{"$f":"I41","v":77},null,{"$f":"C49","v":"Row Summary"}]
[]
[null,null,"Units",null,null,null,null,null,"A$",null,{"$f":"C51","v":"Units"}]
[]
[null,null,"WIP",null,null,null,null,null,null,null,{"$f":"C53","v":"WIP"}]
[]
[]
[null,{"$f":"MAX($B$5:$B55)+1","v":3},"Numerical Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Comma",null,null,null,null,null,123456.789,null,{"$f":"C60","v":"Comma"}]
[]
[null,null,"Comma [0]",null,null,null,null,null,-123456.789,null,"Comma [0]"]
[]
[null,null,"Currency",null,null,null,null,null,123456.789,null,"Currency"]
[]
[null,null,"Currency [0]",null,null,null,null,null,123456.789,null,"Currency [0]"]
[]
[null,null,"Date",null,null,null,null,null,{"$f":"TODAY()","v":"2018-05-16"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2018-05-16"},null,{"$f":"C70","v":"Date Heading"}]
[]
[null,null,"Numbers 0",null,null,null,null,null,-123456.789,null,{"$f":"C72","v":"Numbers 0"}]
[]
[null,null,"Percent",null,null,null,null,null,0.5,null,{"$f":"C74","v":"Percent"}]

{"sheet":"Model Parameters","index":3,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,9,0,10],[10,6,10,13],[11,6,11,13]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Model Parameters"}]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"General"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[null,null,null,null,"Model Name",null,{"$f":"IF(ISERROR(OR(FIND(\"[\",CELL(\"filename\",A1)),FIND(\"]\",CELL(\"filename\",A1)))),\"\",MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1))","v":"SP INDEX MATCH Examples.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct"]
[]
[]
[null,{"$f":"MAX($B$5:$B14)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365]
[null,null,null,null,"Months in Month",null,1]
[null,null,null,null,"Months in Quarter",null,3]
[null,null,null,null,"Months in Half Yr",null,6]
[null,null,null,null,"Months in Year",null,12]
[null,null,null,null,"Quarters in Year",null,4]
[]
[null,null,null,null,"Rounding Accuracy",null,5]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98]
[null,null,null,null,"Very Small Number",null,1E-8]
[]
[null,null,null,null,"Thousand",null,1000]

{"sheet":"Examples Section","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[]
[]
[]
[]
[null,null,"Various INDEX MATCH Examples"]
[null,null,"Section 1."]
[null,null,{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
[]
[]
[null,null,"General Cover Notes:"]
[null,null,"Various illustrations of INDEX MATCH"]

{"sheet":"Balance Sheet Solution","index":5,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,6,16,7]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Balance Sheet Solution"}]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[null,"Month Ending",null,null,null,null,null,null,null,{"$f":"IF(J$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(I$5,1))","v":"2019-01-31"},{"$f":"IF(K$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(J$5,1))","v":"2019-02-28"},{"$f":"IF(L$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(K$5,1))","v":"2019-03-31"},{"$f":"IF(M$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(L$5,1))","v":"2019-04-30"},{"$f":"IF(N$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(M$5,1))","v":"2019-05-31"},{"$f":"IF(O$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(N$5,1))","v":"2019-06-30"},{"$f":"IF(P$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(O$5,1))","v":"2019-07-31"},{"$f":"IF(Q$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(P$5,1))","v":"2019-08-31"},{"$f":"IF(R$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(Q$5,1))","v":"2019-09-30"},{"$f":"IF(S$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(R$5,1))","v":"2019-10-31"},{"$f":"IF(T$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(S$5,1))","v":"2019-11-30"},{"$f":"IF(U$6=1,DATE(YEAR(TODAY())+1,1,31),EOMONTH(T$5,1))","v":"2019-12-31"}]
[null,"Counter",null,null,null,null,null,null,null,{"$f":"N(I6)+1","v":1},{"$f":"N(J6)+1","v":2},3,4,5,6,7,8,9,10,11,12]
[]
[]
[null,{"$f":"MAX($B$8:$B8)+1","v":1},"Balance Sheet Summary"]
[]
[null,null,null,"Net Assets",null,null,null,null,null,100,110,120,130,137.80000000000001,150,160,170,179.9,190,200,210]
[]
[null,null,null,"Total Equity",null,null,null,null,null,100,110,120,130,140,150,160,170,180,190,200.1,210]
[]
[null,null,null,null,"Balance Check:",null,null,null,null,{"$f":"(ROUND(J11-J13,5)<>0)*1","v":0},{"$f":"(ROUND(K11-K13,5)<>0)*1","v":0},0,0,{"$f":"(ROUND(N11-N13,5)<>0)*1","v":1},0,0,0,1,0,1,0]
[]
[null,null,"Error Message:",null,null,null,{"$f":"IF(SUM(J15:U15)=0,\"OK\",\nIF(SUM(J15:U15)>1,\"First \",\"\")&\n\"Error in \"&\nTEXT(INDEX(J5:U5,MATCH(1,J15:U15,0)),\"Mmm-yy\"))","v":"First Error in May-19"}]
[]
[]
[]
[null,"Error Reporting Options"]
[]
[null,null,"INDEX MATCH",null,null,null,{"$f":"INDEX(J5:U5,MATCH(1,J15:U15,0))","v":"2019-05-31"},{"$f":"IF(ISERROR(G23),\"Ä\",IF(G23=$G$23,\"Ö\",\"Ä\"))","v":"Ö"}]
[null,null,"LOOKUP",null,null,null,{"$f":"LOOKUP(1,J15:U15,J5:U5)","v":"2019-09-30"},{"$f":"IF(ISERROR(G24),\"Ä\",IF(G24=$G$23,\"Ö\",\"Ä\"))","v":"Ä"}]
[null,null,"HLOOKUP",null,null,null,{"$f":"HLOOKUP(1,J15:U15,-11)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(G25),\"Ä\",IF(G25=$G$23,\"Ö\",\"Ä\"))","v":"Ä"}]

{"sheet":"Two Dim INDEX Example","index":6,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Two Dim INDEX Example"}]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Two Dimensional INDEX Example"]
[]
[]
[null,null,null,null,null,null,{"$f":"N(F9)+1","v":1},{"$f":"N(G9)+1","v":2},3,4,5,6,7]
[null,null,null,null,null,null,{"$f":"LEFT(ADDRESS(ROW(G10),COLUMN(G10),2),FIND(\"$\",ADDRESS(ROW(G10),COLUMN(G10),2))-1)","v":"G"},"H","I","J","K","L","M"]
[null,null,null,null,{"$f":"N(E10)+1","v":1},{"$f":"ROW(F11)","v":11},1,2,3,4,5,6,7]
[null,null,null,null,{"$f":"N(E11)+1","v":2},{"$f":"ROW(F12)","v":12},8,9,10,11,12,13,14]
[null,null,null,null,3,13,15,16,17,18,19,20,21]
[null,null,null,null,4,14,22,23,24,25,26,27,28]
[null,null,null,null,5,15,29,30,31,32,33,34,35]
[null,null,null,null,6,16,36,37,38,39,40,41,42]
[null,null,null,null,7,17,43,44,45,46,47,48,49]
[null,null,null,null,8,18,50,51,52,53,54,55,56]
[null,null,null,null,9,19,57,58,59,60,61,62,63]
[null,null,null,null,10,20,64,65,66,67,68,69,70]
[null,null,null,null,11,21,71,72,73,74,75,76,77]
[]
[]
[null,null,"INDEX Assumptions"]
[]
[null,null,null,null,"Row",null,2]
[null,null,null,null,"Column",null,4]
[]
[null,null,null,"INDEX",null,null,{"$f":"INDEX(G11:M21,G26,G27)","v":11}]

{"sheet":"MATCH Example","index":7,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"MATCH Example"}]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"MATCH Example"]
[]
[null,null,"Lookup Array"]
[]
[null,null,null,null,{"$f":"LEFT(ADDRESS(ROW(E10),COLUMN(E10),2),FIND(\"$\",ADDRESS(ROW(E10),COLUMN(E10),2))-1)","v":"E"},{"$f":"LEFT(ADDRESS(ROW(F10),COLUMN(F10),2),FIND(\"$\",ADDRESS(ROW(F10),COLUMN(F10),2))-1)","v":"F"}]
[null,null,null,{"$f":"ROW(D11)","v":11},{"$f":"N(E9)+1","v":1},"a"]
[null,null,null,{"$f":"ROW(D12)","v":12},{"$f":"N(E11)+1","v":2},"b"]
[null,null,null,13,3,"a"]
[null,null,null,14,4,"c"]
[null,null,null,15,5,"b"]
[null,null,null,16,6,"d"]
[null,null,null,17,7,"d"]
[null,null,null,18,8,"e"]
[null,null,null,19,9,"f"]
[null,null,null,20,10,"a"]
[null,null,null,21,11,"c"]
[]
[]
[null,null,"Lookup Value"]
[]
[null,null,null,null,null,"d"]
[]
[]
[null,null,"Match Type"]
[]
[null,null,null,null,null,0]
[]
[]
[null,null,"MATCH",null,null,{"$f":"MATCH(F26,F11:F21,F31)","v":6}]

{"sheet":"Case Sensitive MATCH Example","index":8,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Case Sensitive MATCH Example"}]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Case Sensitive MATCH Example"]
[]
[null,null,"Data"]
[]
[null,null,null,null,null,"Word","Value"]
[null,null,null,null,null,"aicpa",{"$f":"N(G10)+1","v":1}]
[null,null,null,null,null,"Aicpa",{"$f":"N(G11)+1","v":2}]
[null,null,null,null,null,"aIcpa",3]
[null,null,null,null,null,"aiCpa",4]
[null,null,null,null,null,"aicPa",5]
[null,null,null,null,null,"aicpA",{"$f":"N(G15)+1","v":6}]
[null,null,null,null,null,"AIcpa",7]
[null,null,null,null,null,"aiCPA",8]
[null,null,null,null,null,"AICPA",9]
[null,null,null,null,null,"AiCpA",10]
[null,null,null,null,null,"aIcPa",11]
[]
[]
[null,null,"Lookup Value"]
[]
[null,null,null,null,null,"AICPA",{"$f":"INDEX(G11:G21,MATCH(TRUE,EXACT(F26,F11:F21),0))","v":9},null,"Formula is an array function, i.e. CTRL + SHIFT + ENTER in Windows, COMMAND + RETURN for Macintosh"]

{"sheet":"Multiple Criteria Example","index":9,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Multiple Criteria Example"}]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Multiple Criteria INDEX MATCH Example"]
[]
[null,null,"Data"]
[]
[null,null,null,null,null,"Month","Car","Colour","Code"]
[null,null,null,null,null,"January","Holden","Red","ABC001"]
[null,null,null,null,null,"January","Holden","Blue","ABC002"]
[null,null,null,null,null,"January","Ford","Red","ABC003"]
[null,null,null,null,null,"January","Ford","Blue","ABC004"]
[null,null,null,null,null,"January","Toyota","Red","ABC005"]
[null,null,null,null,null,"January","Toyota","Blue","ABC006"]
[null,null,null,null,null,"February","Holden","Red","ABC007"]
[null,null,null,null,null,"February","Holden","Blue","ABC008"]
[null,null,null,null,null,"February","Ford","Red","ABC009"]
[null,null,null,null,null,"February","Ford","Blue","ABC010"]
[null,null,null,null,null,"February","Toyota","Red","ABC011"]
[null,null,null,null,null,"February","Toyota","Blue","ABC012"]
[]
[]
[null,null,"Lookup Information"]
[]
[null,null,null,{"$f":"F10&\":\"","v":"Month:"},null,"January"]
[null,null,null,{"$f":"G10&\":\"","v":"Car:"},null,"Toyota"]
[null,null,null,{"$f":"H10&\":\"","v":"Colour:"},null,"Red"]
[]
[]
[null,null,"Code"]
[]
[null,null,null,null,null,"MULTIPLE CRITERIA:",null,{"$f":"INDEX(I11:I22,MATCH(F27&F28&F29,F11:F22&G11:G22&H11:H22,0))","v":"ABC005"},null,"Formula is an array function, i.e. CTRL + SHIFT + ENTER in Windows, COMMAND + RETURN for Macintosh"]

{"sheet":"Grading Example","index":10,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Grading Example"}]
[{"$f":"Model_Name","v":"SP INDEX MATCH Examples.xlsm"}]
["Navigator"]
[]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Traffic Light Reporting: Grading Example"]
[]
[null,null,null,"Data Required"]
[]
[null,null,null,null,null,null,"Score","Grade"]
[null,null,null,null,null,null,0,"Red"]
[null,null,null,null,null,null,50,"Amber"]
[null,null,null,null,null,null,100,"Green"]
[]
[]
[null,null,"Result and Reporting"]
[]
[null,null,null,null,"Actual Result",null,null,77]
[]
[null,null,null,null,{"$f":"UPPER(H10)","v":"GRADE"},null,null,{"$f":"INDEX(H11:H13,MATCH(H18,G11:G13))","v":"Amber"},null,"Uses match_type 1 implicitly"]