{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Datasheet","COUNTIF","IF & COUNTIF","Partial Match","ISNUMBER&MATCH","IF, ISNA, VLOOKUP","IF, ISNA, MATCH","Conditional Formatting","VBA","Practice"],"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":"Datasheet","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"\"XYZ\" Company"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Apple",4629,null,"Green Apple"]
[null,"Broccoli",3257,null,"Berry"]
[null,"Tomato",2091,null,"Banana"]
[null,"Banana",2125,null,"Orange"]
[null,"Strawberry",2167,null,"Lemon"]
[null,"Lemon",4568]
[null,"Blackberry",4247]

{"sheet":"COUNTIF","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using COUNTIF Function"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Apple",4629,null,"Green Apple",{"$f":"COUNTIF($B$4:$B$10,E4)>0","v":false}]
[null,"Broccoli",3257,null,"Berry",{"$f":"COUNTIF($B$4:$B$10,E5)>0","v":false}]
[null,"Tomato",2091,null,"Banana",true]
[null,"Banana",2125,null,"Orange",false]
[null,"Strawberry",2167,null,"Lemon",true]
[null,"Lemon",4568]
[null,"Blackberry",4247]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"IF & COUNTIF","index":2,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using IF Function & COUNTIF Function"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Apple",4629,null,"Green Apple",{"$f":"IF(COUNTIF($B$4:$B$10,E4)>0,\"Exist\",\"Does not Exist\")","v":"Does not Exist"}]
[null,"Broccoli",3257,null,"Berry",{"$f":"IF(COUNTIF($B$4:$B$10,E5)>0,\"Exist\",\"Does not Exist\")","v":"Does not Exist"}]
[null,"Tomato",2091,null,"Banana","Exist"]
[null,"Banana",2125,null,"Orange","Does not Exist"]
[null,"Strawberry",2167,null,"Lemon","Exist"]
[null,"Lemon",4568]
[null,"Blackberry",4247]
[]
[]
[]
[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":"Partial Match","index":3,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Partial Match"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Green Apple",4629,null,"Apple",{"$f":"COUNTIF($B$4:$B$10,\"*\"&E4&\"*\")>0","v":true}]
[null,"Broccoli",3257,null,"Berry",{"$f":"COUNTIF($B$4:$B$10,\"*\"&E5&\"*\")>0","v":true}]
[null,"Tomato",2091,null,"Banana",true]
[null,"Banana",2125,null,"Orange",false]
[null,"Strawberry",2167,null,"Lemon",true]
[null,"Lemon",4568]
[null,"Blackberry",4247]
[]
[]
[]
[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":"ISNUMBER&MATCH","index":4,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using ISNUMBER Function & MATCH Function"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Apple",4629,null,"Green Apple",{"$f":"ISNUMBER(MATCH(E4,$B$4:$B$10,0))","v":false}]
[null,"Broccoli",3257,null,"Berry",{"$f":"ISNUMBER(MATCH(E5,$B$4:$B$10,0))","v":false}]
[null,"Tomato",2091,null,"Banana",true]
[null,"Banana",2125,null,"Orange",false]
[null,"Strawberry",2167,null,"Lemon",true]
[null,"Lemon",4568]
[null,"Blackberry",4247]
[]
[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":"IF, ISNA, VLOOKUP","index":5,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using IF, ISNA, VLOOKUP Function"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Apple",4629,null,"Green Apple",{"$f":"IF(ISNA(VLOOKUP(E4,$B$4:$B$10,1,FALSE)),\"Does Not Exist\",\"Exists\")","v":"Does Not Exist"}]
[null,"Broccoli",3257,null,"Berry",{"$f":"IF(ISNA(VLOOKUP(E5,$B$4:$B$10,1,FALSE)),\"Does Not Exist\",\"Exists\")","v":"Does Not Exist"}]
[null,"Tomato",2091,null,"Banana","Exists"]
[null,"Banana",2125,null,"Orange","Does Not Exist"]
[null,"Strawberry",2167,null,"Lemon","Exists"]
[null,"Lemon",4568]
[null,"Blackberry",4247]
[]
[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":"IF, ISNA, MATCH","index":6,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using IF, ISNA, MATCH Function"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Apple",4629,null,"Green Apple",{"$f":"IF(ISNA(MATCH(E4,$B$4:$B$10,0)),\"Does Not Exist\",\"Exists\")","v":"Does Not Exist"}]
[null,"Broccoli",3257,null,"Berry",{"$f":"IF(ISNA(MATCH(E5,$B$4:$B$10,0)),\"Does Not Exist\",\"Exists\")","v":"Does Not Exist"}]
[null,"Tomato",2091,null,"Banana","Exists"]
[null,"Banana",2125,null,"Orange","Does Not Exist"]
[null,"Strawberry",2167,null,"Lemon","Exists"]
[null,"Lemon",4568]
[null,"Blackberry",4247]
[]
[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":"Conditional Formatting","index":7,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Conditional Formatting"]
[]
[null,"Product List","Cost Price",null,"Order List"]
[null,"Apple",4629,null,"Green Apple"]
[null,"Broccoli",3257,null,"Berry"]
[null,"Tomato",2091,null,"Banana"]
[null,"Banana",2125,null,"Orange"]
[null,"Strawberry",2167,null,"Lemon"]
[null,"Lemon",4568]
[null,"Blackberry",4247]
[]
[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":8,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using VBA Code"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Apple",4629,null,"Green Apple","Does not exist"]
[null,"Broccoli",3257,null,"Berry","Does not exist"]
[null,"Tomato",2091,null,"Banana","Exists"]
[null,"Banana",2125,null,"Orange","Does not exist"]
[null,"Strawberry",2167,null,"Lemon","Exists"]
[null,"Lemon",4568]
[null,"Blackberry",4247]
[]
[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":"Practice","index":9,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Practice"]
[]
[null,"Product List","Cost Price",null,"Order List","Status"]
[null,"Apple",4629,null,"Green Apple"]
[null,"Broccoli",3257,null,"Berry"]
[null,"Tomato",2091,null,"Banana"]
[null,"Banana",2125,null,"Orange"]
[null,"Strawberry",2167,null,"Lemon"]
[null,"Lemon",4568]
[null,"Blackberry",4247]