{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Sheet1","Sheet1 (2)","Sheet1 (3)","Dataset","Output Data","Sheet1 (4)","Sheet1 (5)","Sheet1 (6)","Sheet1 (7)","LastMatch","LastMatch (2)","Find Range Matching Value","Find Range Matching Value (2)","Find Specific header"],"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":"Sheet1","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Sheet1 (2)","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Match Function to Find One Matching Value in Column"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Order Id","Model"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,"A-156","Iphone 12"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Sheet1 (3)","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Match Function to Find Multiple Matching Values in Column"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Order Id","Model"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,"A-156","Iphone 12"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234",null,"S-234","Galaxy Note 10"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235",null,"O-345","One Plus 6"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Dataset","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Matching Value in Column in Another Worksheet\n"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Output Data","index":4,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Order Id","Model"]
[null,"A-156","Iphone 12"]

{"sheet":"Sheet1 (4)","index":5,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Matching Value in Column Using Find Function"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Order Id","Model"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,"A-156","Iphone 12"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Sheet1 (5)","index":6,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Value from Table’s Column"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Order Id","Model"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,"A-156","Iphone 12"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Sheet1 (6)","index":7,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Find String With Partial Match in VBA"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Partial Matching String","Full String"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Sheet1 (7)","index":8,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding First Matching Value in Column"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null," Unit Price","Model"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,1200,"Iphone 13"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"LastMatch","index":9,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Last Matching Value in Column"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Unit Price","Model"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,900,"Iphone 11"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"LastMatch (2)","index":10,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Last Match Column Value in VBA"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Last 4 digit of ID","Model"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,1230,"Galaxy Note 10"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Find Range Matching Value","index":11,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Finding Range of the Matching Value "]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Product Id","Range"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,"Aple-2211","$B$11"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Find Range Matching Value (2)","index":12,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Finding Range of Blank Cell"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Blank Cell Range"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,"$E$10"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",null,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]

{"sheet":"Find Specific header","index":13,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Finding Specific Column of Specific Header"]
[]
[null,"Product ID","Company","Model","Unit Price","Order ID",null,"Specific Header","Column Range"]
[null,"Aple-1124","Apple","Iphone 13",1200,"A-665",null,"Order ID","$F$4:$F$12"]
[null,"SMSNG-1230","Samsung","Galaxy Note 10",750,"S-234"]
[null,"SMSNG-1232","Samsung","Galaxy Note 10 Ultra",1000,"S235"]
[null,"Mi-44","Xioami","Mi 15 Pro",1200,"M-014"]
[null,"OneP-2230","One Plus","One Plus 8",800,"O-023"]
[null,"OneP-1882","One Plus","One Plus 6",900,"O-345"]
[null,"Aple-2211","Apple","Iphone 12",1200,"A-156"]
[null,"Aple-2200","Apple","Iphone 11",900,"A-116"]