{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Part num","Part num (UDF)","Vehicle applications"],"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":"Part num","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,0,8,2],[9,0,9,2]]}
["Part num","Description","Related vehicle applications"]
[1,"Capacitor 1",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IFERROR(IF(SEARCH(A2,'Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"),\"\"))","v":"speedometer,tachometer,odometer"}]
[2,"Capacitor 2",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IFERROR(IF(SEARCH(A3,'Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"),\"\"))","v":"speedometer,tachometer,odometer,fuel gauge"}]
[3,"Capacitor 3",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IFERROR(IF(SEARCH(A4,'Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"),\"\"))","v":"speedometer,fuel gauge"}]
[4,"Capacitor 4",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IFERROR(IF(SEARCH(A5,'Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"),\"\"))","v":"odometer,fuel gauge"}]
[5,"Capacitor 5",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IFERROR(IF(SEARCH(A6,'Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"),\"\"))","v":"odometer"}]
[]
[]
["Is there anyway to get it to ignore duplicates entries?"]
["so that each 'vehicle application' is listed once in the 'related vehicle applications' no matter how many times it appears in the 'vehicle application' list?"]

{"sheet":"Part num (UDF)","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,0,8,2],[9,0,9,2]]}
["Part num","Description","Related vehicle applications"]
[1,"Capacitor 1",{"$f":"Lookup_concat(A2,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"speedometer tachometer odometer"}]
[2,"Capacitor 2",{"$f":"Lookup_concat(A3,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"speedometer tachometer odometer fuel gauge"}]
[3,"Capacitor 3",{"$f":"Lookup_concat(A4,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"speedometer fuel gauge"}]
[4,"Capacitor 4",{"$f":"Lookup_concat(A5,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"odometer fuel gauge"}]
[5,"Capacitor 5",{"$f":"Lookup_concat(A6,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"odometer"}]
[]
[]
["Is there anyway to get it to ignore duplicates entries?"]
["so that each 'vehicle application' is listed once in the 'related vehicle applications' no matter how many times it appears in the 'vehicle application' list?"]

{"sheet":"Vehicle applications","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Vehicle application","Part description","Part num"]
["speedometer","Capacitor 1","A1"]
["speedometer","Capacitor 2","A2"]
["speedometer","Capacitor 3","A3"]
["tachometer","Capacitor 1","A1"]
["tachometer","Capacitor 2","A2"]
["odometer","Capacitor 1","A1"]
["odometer","Capacitor 2","A2"]
["odometer","Capacitor 4","A4"]
["odometer","Capacitor 5","A5"]
["fuel gauge","Capacitor 1","A4"]
["fuel gauge","Capacitor 2","A2"]
["fuel gauge","Capacitor 3","A3"]