{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["XLOOKUP","LOOKUP","INDEX-MATCH","MAX,IF,ROW,INDEX","VBA Code","Sheet6"],"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":"XLOOKUP","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Product List",null,null,null,"XLOOKUP Function"]
[null,"Month","Item ","Price",null,"Item","Egg"]
[null,"Janury","Soap",120,null,"Last Occurrence Price ",{"$f":"_xlfn.XLOOKUP(G3,C4:C11,D4:D11,,,-1)","v":180}]
[null,"February","Milk",100]
[null,"March","Egg",200]
[null,"April","Bread",130]
[null,"May","Milk",220]
[null,"June","soup",250]
[null,"July","Egg",180]
[null,"August","Bread",160]

{"sheet":"LOOKUP","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Product List",null,null,null,"LOOKUP Function"]
[null,"Month","Item ","Price",null,"Item","Egg"]
[null,"Janury","Soap",120,null,"Last Occurrence Price ",{"$f":"LOOKUP(2,1/($C$4:$C$11=$G$3),$D$4:$D$11)","v":180}]
[null,"February","Milk",100]
[null,"March","Egg",200]
[null,"April","Bread",130]
[null,"May","Milk",220]
[null,"June","soup",250]
[null,"July","Egg",180]
[null,"August","Bread",160]

{"sheet":"INDEX-MATCH","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Product List",null,null,null,"INDEX-MATCH Function"]
[null,"Month","Item ","Price",null,"Item","Egg"]
[null,"Janury","Soap",120,null,"Last Occurrence Price ",{"$f":"INDEX($D$4:$D$11,MATCH(2,1/(C4:C11=G3)))","v":180}]
[null,"February","Milk",100]
[null,"March","Egg",200]
[null,"April","Bread",130]
[null,"May","Milk",220]
[null,"June","soup",250]
[null,"July","Egg",180]
[null,"August","Bread",160]

{"sheet":"MAX,IF,ROW,INDEX","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Product List",null,null,null,"MAX, IF, ROW, INDEX Function"]
[null,"Month","Item ","Price",null,"Item","Egg"]
[null,"Janury","Soap",120,null,"Last Occurrence Position",{"$f":"MAX(IF(C4:C11=\"Egg\", ROW(C4:C11)-ROW(INDEX(C4:C11,1,1))+1))","v":7}]
[null,"February","Milk",100]
[null,"March","Egg",200]
[null,"April","Bread",130]
[null,"May","Milk",220]
[null,"June","soup",250]
[null,"July","Egg",180]
[null,"August","Bread",160]

{"sheet":"VBA Code","index":4,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Product List"]
[null,"Month","Item ","Price",null,"Item ","Last Occurrence Price "]
[null,"Janury","Soap",120,null,"Bread",{"$f":"lastOccur(F4,C4:D11,2)","v":160}]
[null,"February","Milk",100]
[null,"March","Egg",200]
[null,"April","Bread",130]
[null,"May","Milk",220]
[null,"June","soup",250]
[null,"July","Egg",180]
[null,"August","Bread",160]

{"sheet":"Sheet6","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Soap"]
[null,"Milk"]
[null,"Egg"]
[null,"Bread"]
[null,"soup"]