{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Using MATCH Function","Applying IFERROR  and MATCH","Employing Array Formula","Using MATCH and ROW Functions","Applying INDEX, MATCH & ROW","Use of TEXTJOIN Function","Employing VBA"],"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":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Finding String and Returning Row Number"]
[]
[null,"Sales Person","Sales"]
[null,"Jane",200]
[null,"Veronica",150]
[null,"Julian",130]
[null,"Kelvin",180]
[null,"Bert",160]

{"sheet":"Using MATCH Function","index":1,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using MATCH Function",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Sales Person","Sales",null,"Sales Person","Row Number",null,null,"Sales Person","Sales",null,"Sales Person","Row Number"]
[null,"Jane",200,null,"Veronica",{"$f":"MATCH(E5,B:B,0)","v":6},null,null,"Jane",200,null,"Veronica"]
[null,"Veronica",150,null,null,null,null,null,"Veronica",150]
[null,"Julian",130,null,null,null,null,null,"Julian",130]
[null,"Kelvin",180,null,null,null,null,null,"Kelvin",180]
[null,"Bert",160,null,null,null,null,null,"Bert",160]

{"sheet":"Applying IFERROR  and MATCH","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Applying IFERROR  and MATCH Functions",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Sales Person","Sales",null,"Sales Person","Row Number",null,null,"Sales Person","Sales",null,"Sales Person","Row Number"]
[null,"Jane",200,null,"Kelvin",{"$f":"IFERROR(INDEX(ROW($B$5:$B$9),MATCH(E5,$B$5:$B$9,0)),\"No Match\")","v":8},null,null,"Jane",200,null,"Kelvin"]
[null,"Veronica",150,null,"Susan",{"$f":"IFERROR(INDEX(ROW($B$5:$B$9),MATCH(E6,$B$5:$B$9,0)),\"No Match\")","v":"No Match"},null,null,"Veronica",150,null,"Susan"]
[null,"Julian",130,null,null,null,null,null,"Julian",130]
[null,"Kelvin",180,null,null,null,null,null,"Kelvin",180]
[null,"Bert",160,null,null,null,null,null,"Bert",160]

{"sheet":"Employing Array Formula","index":3,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Employing Array Formula",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Sales Person","Sales",null,"Sales Person","Row Number",null,null,"Sales Person","Sales",null,"Sales Person","Row Number"]
[null,"Jane",200,null,"Julian",{"$f":"MAX((B5:B9=E5)*ROW(B5:B9))","v":7},null,null,"Jane",200,null,"Julian"]
[null,"Veronica",150,null,null,null,null,null,"Veronica",150]
[null,"Julian",130,null,null,null,null,null,"Julian",130]
[null,"Kelvin",180,null,null,null,null,null,"Kelvin",180]
[null,"Bert",160,null,null,null,null,null,"Bert",160]

{"sheet":"Using MATCH and ROW Functions","index":4,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using MATCH and ROW Functions",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Sales Person","Sales",null,"Sales Person","Row Number",null,null,"Sales Person","Sales",null,"Sales Person","Row Number"]
[null,"Jane",200,null,"Bert",{"$f":"MATCH(E5,B5:B9,0)+ROW(B5:B9)-1","v":9},null,null,"Jane",200,null,"Bert"]
[null,"Veronica",150,null,null,null,null,null,"Veronica",150]
[null,"Julian",130,null,null,null,null,null,"Julian",130]
[null,"Kelvin",180,null,null,null,null,null,"Kelvin",180]
[null,"Bert",160,null,null,null,null,null,"Bert",160]

{"sheet":"Applying INDEX, MATCH & ROW","index":5,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Applying INDEX, MATCH & ROW Functions",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Sales Person","Sales",null,"Sales Person","Row Number",null,null,"Sales Person","Sales",null,"Sales Person","Row Number"]
[null,"Jane",200,null,"Jane",{"$f":"ROW(INDEX(B4:B9,MATCH(E5,B4:B9,0)))","v":5},null,null,"Jane",200,null,"Jane"]
[null,"Veronica",150,null,null,null,null,null,"Veronica",150]
[null,"Julian",130,null,null,null,null,null,"Julian",130]
[null,"Kelvin",180,null,null,null,null,null,"Kelvin",180]
[null,"Bert",160,null,null,null,null,null,"Bert",160]

{"sheet":"Use of TEXTJOIN Function","index":6,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Use of TEXTJOIN Function",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Sales Person","State",null,"State","Row Number",null,null,"Sales Person","State",null,"State","Row Number"]
[null,"Jane","Texas",null,"Texas",{"$f":"_xlfn.TEXTJOIN(\",\",,IF(C4:C9=E5,ROW(C4:C9),\"\"))","v":"5,7,8"},null,null,"Jane","Texas",null,"New York"]
[null,"Veronica","New York",null,null,null,null,null,"Veronica","New York"]
[null,"Julian","Texas",null,null,null,null,null,"Julian","Texas"]
[null,"Kelvin","Texas",null,null,null,null,null,"Kelvin","Texas"]
[null,"Bert","New York",null,null,null,null,null,"Bert","New York"]

{"sheet":"Employing VBA","index":7,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Employing VBA",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Sales Person","Sales",null,"Sales Person",null,null,"Sales Person","Sales",null,"Sales Person"]
[null,"Jane",200,null,"Kelvin",null,null,"Jane",200,null,"Kelvin"]
[null,"Veronica",150,null,null,null,null,"Veronica",150]
[null,"Julian",130,null,null,null,null,"Julian",130]
[null,"Kelvin",180,null,null,null,null,"Kelvin",180]
[null,"Bert",160,null,null,null,null,"Bert",160]