{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["FUZZYMATCH","FuzzyLookup_AddIn_Undo_Sheet","Add in","Wildcards","Wildvards 2"],"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":"FUZZYMATCH","index":0,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,3,10,3],[1,1,1,4]]}
[]
[null,"Fuzzy Match Using VBA"]
[]
[null,"Name of the Books",null,"Another Book","Fuzzy Matches"]
[null,"A Tale of Two Cities",null,"The History of India During the World War",{"$f":"FUZZYMATCH(D5,B5:B22)","v":"The History of the Second World War"}]
[null,"The History of the Second World War",null,null,"History of the Ancient Greece"]
[null,"Harry Potter and the Goblet of Fire",null,null,"World War: Causes and Effects"]
[null,"History of the Ancient Greece",null,null,"The Indus Civilization: An Ancient History"]
[null,"World War: Causes and Effects",null,null,"India Wins Freedom"]
[null,"Ode to the West Wind",null,null,"Adlof Hitler: Before and After the World War"]
[null,"Mother",null,null,"The Discovery of India"]
[null,"Pride and Prejudice"]
[null,"The Indus Civilization: An Ancient History"]
[null,"Great Expectations"]
[null,"India Wins Freedom"]
[null,"Crime and Punishment"]
[null,"The Mayor of Casterbridge"]
[null,"Adlof Hitler: Before and After the World War"]
[null,"Romeo and Juliet"]
[null,"The Notebook"]
[null,"David Copperfield"]
[null,"The Discovery of India"]

{"sheet":"FuzzyLookup_AddIn_Undo_Sheet","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Using Fuzzy Lookup Add-in"]
[]
["Books from Robert Bookshop",null,"Books from Marting Bookshop"]
["A Tale of Two Cities",null,"The City of Sunflower"]
["A Study of the Indian Civilization",null,"Sind: The Ultimate Birthplace of Civilization"]
["Harry Potter and the Goblet of Fire",null,"Harry Potter and the Half Blood Prince"]
["History of the Ancient Greece",null,"A Journey through the Ancient Egypt"]
["World War: Causes and Effects",null,"An Investigation for the Deadly Wars"]
["Ode to the West Wind",null,"Ode to a Nightingale"]
["Mother",null,"Mother Teresa: An Icon of Humanity"]
["Pride and Prejudice",null,"Vanity Fair"]
["The Indus Civilization: An Ancient History",null,"The History of World War-2"]
["Great Expectations",null,"Oliver Twist"]
["India Wins Freedom",null,"Road to Freedom"]
["Crime and Punishment",null,"The House of the Dead"]
["The Mayor of Casterbridge",null,"Time Machine"]
["Adlof Hitler: Before and After the World War",null,"Mein Kamp: Autobiography of Adlof Hitler"]
["Romeo and Juliet",null,"Hamlet"]
["The Notebook",null,"Letter to Juliet"]
["David Copperfield",null,"Martin Chuzzulet"]
["The Discovery of India",null,"India on the Rise"]

{"sheet":"Add in","index":2,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Fuzzy Lookup Add-in"]
[]
[null,"Books from Robert Bookshop",null,"Books from Robert Bookshop","Books from Marting Bookshop","Similarity"]
[null,"A Tale of Two Cities",null,"A Tale of Two Cities",null,0]
[null,"A Study of the Indian Civilization",null,"A Study of the Indian Civilization",null,0]
[null,"Harry Potter and the Goblet of Fire",null,"Harry Potter and the Goblet of Fire",null,0]
[null,"History of the Ancient Greece",null,"History of the Ancient Greece",null,0]
[null,"World War: Causes and Effects",null,"World War: Causes and Effects",null,0]
[null,"Ode to the West Wind",null,"Ode to the West Wind",null,0]
[null,"Mother",null,"Mother","Mother Teresa: An Icon of Humanity",0.84000000000000008]
[null,"Pride and Prejudice",null,"Pride and Prejudice",null,0]
[null,"The Indus Civilization: An Ancient History",null,"The Indus Civilization: An Ancient History",null,0]
[null,"Great Expectations",null,"Great Expectations",null,0]
[null,"India Wins Freedom",null,"India Wins Freedom",null,0]
[null,"Crime and Punishment",null,"Crime and Punishment",null,0]
[null,"The Mayor of Casterbridge",null,"The Mayor of Casterbridge",null,0]
[null,"Adlof Hitler: Before and After the World War",null,"Adlof Hitler: Before and After the World War",null,0]
[null,"Romeo and Juliet",null,"Romeo and Juliet",null,0]
[null,"The Notebook",null,"The Notebook",null,0]
[null,"David Copperfield",null,"David Copperfield",null,0]
[null,"The Discovery of India",null,"The Discovery of India",null,0]

{"sheet":"Wildcards","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VLOOKUP Fuzzy Match Using Wildcards"]
[]
[null,"Name of the Books",null,"Lookup Value","Matching Output"]
[null,"A Tale of Two Cities",null," Second World War",{"$f":"VLOOKUP(\"*Second World War*\",B5:B22,1,FALSE)","v":"The History of the Second World War"}]
[null,"The History of the Second World War"]
[null,"Harry Potter and the Goblet of Fire"]
[null,"History of the Ancient Greece"]
[null,"World War: Causes and Effects"]
[null,"Ode to the West Wind"]
[null,"Mother"]
[null,"Pride and Prejudice"]
[null,"The Indus Civilization: An Ancient History"]
[null,"Great Expectations"]
[null,"India Wins Freedom"]
[null,"Crime and Punishment"]
[null,"The Mayor of Casterbridge"]
[null,"Adlof Hitler: Before and After the World War"]
[null,"Romeo and Juliet"]
[null,"The Notebook"]
[null,"David Copperfield"]
[null,"The Discovery of India"]

{"sheet":"Wildvards 2","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VLOOKUP Fuzzy Match Using Wildcards"]
[]
[null,"Name of the Books",null,"Lookup Value","Matching Output"]
[null,"A Tale of Two Cities",null," Second World War",{"$f":"VLOOKUP(\"*\"&D5&\"*\",B5:B22,1,FALSE)","v":"The History of the Second World War"}]
[null,"The History of the Second World War"]
[null,"Harry Potter and the Goblet of Fire"]
[null,"History of the Ancient Greece"]
[null,"World War: Causes and Effects"]
[null,"Ode to the West Wind"]
[null,"Mother"]
[null,"Pride and Prejudice"]
[null,"The Indus Civilization: An Ancient History"]
[null,"Great Expectations"]
[null,"India Wins Freedom"]
[null,"Crime and Punishment"]
[null,"The Mayor of Casterbridge"]
[null,"Adlof Hitler: Before and After the World War"]
[null,"Romeo and Juliet"]
[null,"The Notebook"]
[null,"David Copperfield"]
[null,"The Discovery of India"]