{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Datasheet","Filter_Option","Product_Code","ISTEXT","Product_Code1","ISNUMBER","Product_Name","FILTER","Product","INDEX-MATCH","Product1","VLOOKUP","Product2","VBA","Product3","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Datasheet","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"\"XYZ\" Company"]
[]
[null,"Product Code","Product","SalesPerson","Selling Price"]
[null,1200967,"Cherry","Michael",1402]
[null,"ASD564X","Orange","Daniel",5935]
[null,13567094,"Cherry","Gabriel",6835]
[null,"ASD675Y","Blackberries","Katherine",7871]
[null,"THJ695Y","Cherry","Jefferson",9496]
[null,"AGH675O","Beet Greens","Emily",1734]
[null,15430984,"Broccoli","Sara",4662]
[null,"YUJ890Y","Cherry","John",4500]

{"sheet":"Filter_Option","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Filter Option"]
[]
[null,"Product Code","Product","SalesPerson","Selling Price"]
[null,1200967,"Cherry","Michael",1402]
[null,"ASD564X","Orange","Daniel",5935]
[null,13567094,"Cherry","Gabriel",6835]
[null,"ASD675Y","Blackberries","Katherine",7871]
[null,"THJ695Y","Cherry","Jefferson",9496]
[null,"AGH675O","Beet Greens","Emily",1734]
[null,15430984,"Broccoli","Sara",4662]
[null,"YUJ890Y","Cherry","John",4500]

{"sheet":"Product_Code","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Filter Option"]
[]
[null,"Product Code","Product","SalesPerson","Selling Price"]
[null,"ASD564X","Orange","Daniel",5935]
[null,"ASD675Y","Blackberries","Katherine",7871]
[null,"THJ695Y","Cherry","Jefferson",9496]
[null,"AGH675O","Beet Greens","Emily",1734]
[null,"YUJ890Y","Cherry","John",4500]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"ISTEXT","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using ISTEXT Function"]
[]
[null,"Product Code","Product","SalesPerson","Selling Price"]
[null,1200967,"Cherry","Michael",1402]
[null,"ASD564X","Orange","Daniel",5935]
[null,13567094,"Cherry","Gabriel",6835]
[null,"ASD675Y","Blackberries","Katherine",7871]
[null,"THJ695Y","Cherry","Jefferson",9496]
[null,"AGH675O","Beet Greens","Emily",1734]
[null,15430984,"Broccoli","Sara",4662]
[null,"YUJ890Y","Cherry","John",4500]

{"sheet":"Product_Code1","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Using ISTEXT Function"]
[]
[null,"Product Code"]
[null,{"$f":"IF(ISTEXT(ISTEXT!B4),ISTEXT!B4,\"\")","v":""}]
[null,{"$f":"IF(ISTEXT(ISTEXT!B5),ISTEXT!B5,\"\")","v":"ASD564X"}]
[null,{"$f":"IF(ISTEXT(ISTEXT!B6),ISTEXT!B6,\"\")","v":""}]
[null,{"$f":"IF(ISTEXT(ISTEXT!B7),ISTEXT!B7,\"\")","v":"ASD675Y"}]
[null,{"$f":"IF(ISTEXT(ISTEXT!B8),ISTEXT!B8,\"\")","v":"THJ695Y"}]
[null,{"$f":"IF(ISTEXT(ISTEXT!B9),ISTEXT!B9,\"\")","v":"AGH675O"}]
[null,{"$f":"IF(ISTEXT(ISTEXT!B10),ISTEXT!B10,\"\")","v":""}]
[null,{"$f":"IF(ISTEXT(ISTEXT!B11),ISTEXT!B11,\"\")","v":"YUJ890Y"}]
[]
[]
[null,null,null,null,null,null,null,null,""]

{"sheet":"ISNUMBER","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using ISNUMBER & SEARCH Function"]
[]
[null,"Product","SalesPerson","Selling Price"]
[null,"Cherry","Michael",1402]
[null,"Orange","Daniel",5935]
[null,"Cherry","Gabriel",6835]
[null,"Blackberries","Katherine",7871]
[null,"Cherry","Jefferson",9496]
[null,"Beet Greens","Emily",1734]
[null,"Broccoli","Sara",4662]
[null,"Cherry","John",4500]

{"sheet":"Product_Name","index":6,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using ISNUMBER & SEARCH Function"]
[]
[null,"Product ","SalesPerson","Selling Price"]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B4)),ISNUMBER!B4,\"\")","v":"Cherry"},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B4)),ISNUMBER!C4,\"\")","v":"Michael"},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B4)),ISNUMBER!D4,\"\")","v":1402}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B5)),ISNUMBER!B5,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B5)),ISNUMBER!C5,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B5)),ISNUMBER!D5,\"\")","v":""}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B6)),ISNUMBER!B6,\"\")","v":"Cherry"},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B6)),ISNUMBER!C6,\"\")","v":"Gabriel"},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B6)),ISNUMBER!D6,\"\")","v":6835}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B7)),ISNUMBER!B7,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B7)),ISNUMBER!C7,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B7)),ISNUMBER!D7,\"\")","v":""}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B8)),ISNUMBER!B8,\"\")","v":"Cherry"},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B8)),ISNUMBER!C8,\"\")","v":"Jefferson"},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B8)),ISNUMBER!D8,\"\")","v":9496}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B9)),ISNUMBER!B9,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B9)),ISNUMBER!C9,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B9)),ISNUMBER!D9,\"\")","v":""}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B10)),ISNUMBER!B10,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B10)),ISNUMBER!C10,\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B10)),ISNUMBER!D10,\"\")","v":""}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B11)),ISNUMBER!B11,\"\")","v":"Cherry"},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B11)),ISNUMBER!C11,\"\")","v":"John"},{"$f":"IF(ISNUMBER(SEARCH(\"Cherry\",ISNUMBER!B11)),ISNUMBER!D11,\"\")","v":4500}]
[]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"FILTER","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using FILTER Function"]
[]
[null,"Product","SalesPerson","Selling Price"]
[null,"Cherry","Michael",1402]
[null,"Orange","Daniel",5935]
[null,"Cherry","Gabriel",6835]
[null,"Blackberries","Katherine",7871]
[null,"Cherry","Jefferson",9496]
[null,"Beet Greens","Emily",1734]
[null,"Broccoli","Sara",4662]
[null,"Cherry","John",4500]

{"sheet":"Product","index":8,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using FILTER Function"]
[]
[null,"Product ","SalesPerson","Selling Price"]
[null,{"$f":"_xlfn._xlws.FILTER(FILTER!B4:D11,FILTER!B4:B11=\"Cherry\",\"\")","v":"Cherry"},"Michael",1402]
[null,"Cherry","Gabriel",6835]
[null,"Cherry","Jefferson",9496]
[null,"Cherry","John",4500]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"INDEX-MATCH","index":9,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using INDEX-MATCH Function"]
[]
[null,"Helper","Product","SalesPerson","Selling Price"]
[null,{"$f":"SUBTOTAL(3,C$4:C4)","v":1},"Cherry","Michael",1402]
[null,{"$f":"SUBTOTAL(3,C$4:C5)","v":1},"Orange","Daniel",5935]
[null,{"$f":"SUBTOTAL(3,C$4:C6)","v":2},"Cherry","Gabriel",6835]
[null,{"$f":"SUBTOTAL(3,C$4:C7)","v":2},"Blackberries","Katherine",7871]
[null,{"$f":"SUBTOTAL(3,C$4:C8)","v":3},"Cherry","Jefferson",9496]
[null,{"$f":"SUBTOTAL(3,C$4:C9)","v":3},"Beet Greens","Emily",1734]
[null,{"$f":"SUBTOTAL(3,C$4:C10)","v":3},"Broccoli","Sara",4662]
[null,{"$f":"SUBTOTAL(3,C$4:C11)","v":4},"Cherry","John",4500]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Product1","index":10,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using INDEX-MATCH Function"]
[]
[null,"Serial No.","Product ","SalesPerson","Selling Price"]
[null,1,{"$f":"INDEX('INDEX-MATCH'!$C$4:$C$11,MATCH($B4,'INDEX-MATCH'!$B$4:$B$11,0))","v":"Cherry"},{"$f":"INDEX('INDEX-MATCH'!$D$4:$D$11,MATCH($B4,'INDEX-MATCH'!$B$4:$B$11,0))","v":"Michael"},{"$f":"INDEX('INDEX-MATCH'!$E$4:$E$11,MATCH($B4,'INDEX-MATCH'!$B$4:$B$11,0))","v":1402}]
[null,2,{"$f":"INDEX('INDEX-MATCH'!$C$4:$C$11,MATCH($B5,'INDEX-MATCH'!$B$4:$B$11,0))","v":"Cherry"},{"$f":"INDEX('INDEX-MATCH'!$D$4:$D$11,MATCH($B5,'INDEX-MATCH'!$B$4:$B$11,0))","v":"Gabriel"},{"$f":"INDEX('INDEX-MATCH'!$E$4:$E$11,MATCH($B5,'INDEX-MATCH'!$B$4:$B$11,0))","v":6835}]
[null,3,{"$f":"INDEX('INDEX-MATCH'!$C$4:$C$11,MATCH($B6,'INDEX-MATCH'!$B$4:$B$11,0))","v":"Cherry"},{"$f":"INDEX('INDEX-MATCH'!$D$4:$D$11,MATCH($B6,'INDEX-MATCH'!$B$4:$B$11,0))","v":"Jefferson"},{"$f":"INDEX('INDEX-MATCH'!$E$4:$E$11,MATCH($B6,'INDEX-MATCH'!$B$4:$B$11,0))","v":9496}]
[null,4,{"$f":"INDEX('INDEX-MATCH'!$C$4:$C$11,MATCH($B7,'INDEX-MATCH'!$B$4:$B$11,0))","v":"Cherry"},{"$f":"INDEX('INDEX-MATCH'!$D$4:$D$11,MATCH($B7,'INDEX-MATCH'!$B$4:$B$11,0))","v":"John"},{"$f":"INDEX('INDEX-MATCH'!$E$4:$E$11,MATCH($B7,'INDEX-MATCH'!$B$4:$B$11,0))","v":4500}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VLOOKUP","index":11,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using VLOOKUP Function"]
[]
[null,"Helper","Product","SalesPerson","Selling Price"]
[null,{"$f":"SUBTOTAL(3,C$4:C4)","v":1},"Cherry","Michael",1402]
[null,{"$f":"SUBTOTAL(3,C$4:C5)","v":1},"Orange","Daniel",5935]
[null,{"$f":"SUBTOTAL(3,C$4:C6)","v":2},"Cherry","Gabriel",6835]
[null,{"$f":"SUBTOTAL(3,C$4:C7)","v":2},"Blackberries","Katherine",7871]
[null,{"$f":"SUBTOTAL(3,C$4:C8)","v":3},"Cherry","Jefferson",9496]
[null,{"$f":"SUBTOTAL(3,C$4:C9)","v":3},"Beet Greens","Emily",1734]
[null,{"$f":"SUBTOTAL(3,C$4:C10)","v":3},"Broccoli","Sara",4662]
[null,{"$f":"SUBTOTAL(3,C$4:C11)","v":4},"Cherry","John",4500]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Product2","index":12,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using VLOOKUP Function"]
[]
[null,"Serial No.","Product ","SalesPerson","Selling Price"]
[null,1,{"$f":"VLOOKUP(B4,VLOOKUP!$B$4:$E$11,2,FALSE)","v":"Cherry"},{"$f":"VLOOKUP(B4,VLOOKUP!$B$4:$E$11,3,FALSE)","v":"Michael"},{"$f":"VLOOKUP(B4,VLOOKUP!$B$4:$E$11,4,FALSE)","v":1402}]
[null,2,{"$f":"VLOOKUP(B5,VLOOKUP!$B$4:$E$11,2,FALSE)","v":"Cherry"},{"$f":"VLOOKUP(B5,VLOOKUP!$B$4:$E$11,3,FALSE)","v":"Gabriel"},{"$f":"VLOOKUP(B5,VLOOKUP!$B$4:$E$11,4,FALSE)","v":6835}]
[null,3,{"$f":"VLOOKUP(B6,VLOOKUP!$B$4:$E$11,2,FALSE)","v":"Cherry"},{"$f":"VLOOKUP(B6,VLOOKUP!$B$4:$E$11,3,FALSE)","v":"Jefferson"},{"$f":"VLOOKUP(B6,VLOOKUP!$B$4:$E$11,4,FALSE)","v":9496}]
[null,4,{"$f":"VLOOKUP(B7,VLOOKUP!$B$4:$E$11,2,FALSE)","v":"Cherry"},{"$f":"VLOOKUP(B7,VLOOKUP!$B$4:$E$11,3,FALSE)","v":"John"},{"$f":"VLOOKUP(B7,VLOOKUP!$B$4:$E$11,4,FALSE)","v":4500}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":13,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using VBA Code"]
[]
[null,"Product","SalesPerson","Selling Price"]
[null,"Cherry","Michael",1402]
[null,"Orange","Daniel",5935]
[null,"Cherry","Gabriel",6835]
[null,"Blackberries","Katherine",7871]
[null,"Cherry","Jefferson",9496]
[null,"Beet Greens","Emily",1734]
[null,"Broccoli","Sara",4662]
[null,"Cherry","John",4500]

{"sheet":"Product3","index":14,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using VBA Code"]
[]
[null,"Product","SalesPerson","Selling Price"]
[null,"Cherry","Michael",1402]
[]
[null,"Cherry","Gabriel",6835]
[]
[null,"Cherry","Jefferson",9496]
[]
[]
[null,"Cherry","John",4500]

{"sheet":"Practice","index":15,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Practice"]
[]
[null,"Product Code","Product","SalesPerson","Selling Price"]
[null,1200967,"Cherry","Michael",1402]
[null,"ASD564X","Orange","Daniel",5935]
[null,13567094,"Cherry","Gabriel",6835]
[null,"ASD675Y","Blackberries","Katherine",7871]
[null,"THJ695Y","Cherry","Jefferson",9496]
[null,"AGH675O","Beet Greens","Emily",1734]
[null,15430984,"Broccoli","Sara",4662]
[null,"YUJ890Y","Cherry","John",4500]