Spreadsheet: 679618d1590522312-list-of-values-where-one-value-is-replaced-by-another-one-a32650-v3-adsako-
Sheet: Bill Of Materials

 | Master Part No | BOM Name | Part BOM to Use | Child Part No | Seq No | [NAME] | [NAME] | Mster Prt? | Replace | rows | Total rows | Raw Criteria | Final output |  |  | criteria: | a32650
 | A32650 | STANDARD | STANDARD | A32651 | 1 | 1
 | A32650 | STANDARD | STANDARD | A32653 | 2 | 1
 | A32650 | STANDARD | STANDARD | [NAME] | 3 | 1 |  |  |  |  |  |  |  |  |  |  | I need to replace this part number with parts A32654/A32655/A32656 as those parts are child parts to [NAME] and then also return first level part number (raw material). There is the same logic for other part numbers.
 | A32650 | STANDARD | STANDARD | [NAME] | 4 | 1
 | A32650 | STANDARD | STANDARD | A32662 | 5 | 1
 | A32650 | STANDARD | STANDARD | A32665 | 6 | 1
 | A32650 | STANDARD | STANDARD | A32668 | 7 | 1
 | A32650 | STANDARD | STANDARD | A32669 | 8 | 1
 | A32650 | STANDARD | STANDARD | EB/53/M5 | 9 | 1
 | A32650 | STANDARD | STANDARD | EB/52/M5 | 10 | 1
 | A32651 | A32651_NO TEST PIECES_SUB CON | A32651_NO TEST PIECES_SUB CON | BS2S130_CON-D_RD_BR_D10 | 1 | 1
 | A32651 | A32651_SUB CON Mc | A32651_NO TEST PIECES_SUB CON | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | A32651 | A32651_SUB CON Mc | A32651_NO TEST PIECES_SUB CON | ASK1676_A32651 | 2 | 1
 | A32651 | STANDARD | A32651_NO TEST PIECES_SUB CON | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3 |  |  |  |  |  |  |  |  |  | NOTE: parts where replacement is needed are marked in yellow
 | A32651 | STANDARD | A32651_NO TEST PIECES_SUB CON | ASK1676_A32651 | 2 | 1
 | A32652 | A32652_SUBCON_Mc | A32652_SUBCON_Mc_NO TEST PIECES | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | A32652 | A32652_SUBCON_Mc | A32652_SUBCON_Mc_NO TEST PIECES | ASK1676_A32652 | 2 | 3
 | A32652 | A32652_SUBCON_Mc_NO TEST PIECES | A32652_SUBCON_Mc_NO TEST PIECES | BS2S130_CON-D_RD_BR_D10 | 1 | 1
 | A32652 | STANDARD | A32652_SUBCON_Mc_NO TEST PIECES | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | A32653 | A32653=FROM BAR STOCK | A32653=FROM BLANK APS10074 | BS2S130_CON-D_RD_BR_D76 | 1 | 1
 | A32653 | A32653=FROM BLANK APS10074 | A32653=FROM BLANK APS10074 | APS10074 | 1 | 1
 | A32653 | STANDARD | A32653=FROM BLANK APS10074 | BS2S130_CON-D_RD_BR_D76 | 1 | 1
 | A32654 | STANDARD | STANDARD | BS2S130_CON-D_RD_BR_D22 | 1 | 1
 | A32655 | STANDARD | STANDARD | BS2S130_CON-D_RD_BR_D22 | 1 | 1
 | A32656 | A32656_SUBCON_Mc | A32656_SUBCON_Mc NO TEST BAR | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | A32656 | A32656_SUBCON_Mc | A32656_SUBCON_Mc NO TEST BAR | ASK1676_A32656 | 2 | 3
 | A32656 | A32656_SUBCON_Mc NO TEST BAR | A32656_SUBCON_Mc NO TEST BAR | BS2S130_CON-D_RD_BR_D10 | 1 | 1
 | A32656 | STANDARD | A32656_SUBCON_Mc NO TEST BAR | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | A32656 | STANDARD | A32656_SUBCON_Mc NO TEST BAR | ASK1676_A32656 | 2 | 3
 | [NAME] | STANDARD | STANDARD | A32654 | 1 | 1
 | [NAME] | STANDARD | STANDARD | A32655 | 2 | 1
 | [NAME] | STANDARD | STANDARD | A32656 | 3 | 1
 | A32658 | STANDARD | STANDARD | HIDURON_130_RD_BR_D19 | 1 | 1
 | A32659 | STANDARD | STANDARD | HIDURON_130_RD_BR_D19 | 1 | 1
 | [NAME] | STANDARD | STANDARD | A32652 | 1 | 1
 | [NAME] | STANDARD | STANDARD | A32658 | 2 | 1
 | [NAME] | STANDARD | STANDARD | A32659 | 3 | 1
 | A32661 | A32661_SUBCON_Mc | A32661_SUBCON_Mc_NO TEST P | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | A32661 | A32661_SUBCON_Mc | A32661_SUBCON_Mc_NO TEST P | ASK1676_A32661 | 2 | 1
 | A32661 | A32661_SUBCON_Mc_NO TEST P | A32661_SUBCON_Mc_NO TEST P | BS2S130_CON-D_RD_BR_D10 | 1 | 1
 | A32661 | STANDARD | A32661_SUBCON_Mc_NO TEST P | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | A32662 | A32662=FROM BAR STOCK | A32662=FROM BLANK APS10074 | BS2S130_CON-D_RD_BR_D76 | 1 | 1
 | A32662 | A32662=FROM BLANK APS10074 | A32662=FROM BLANK APS10074 | APS10074 | 1 | 1
 | A32662 | A32662=FROM RAW CUT BLANK | A32662=FROM BLANK APS10074 | BS2S130_CON-D_RD_BR_D76XL33 | 1 | 1
 | A32662 | STANDARD | A32662=FROM BLANK APS10074 | BS2S130_CON-D_RD_BR_D76 | 1 | 1
 | A32663 | A32663_FREE ISSUE_MAT | STANDARD | BS2S130_EN3487_CON-D_RD_BR_D22 | 1 | 3
 | A32663 | STANDARD | STANDARD | BS2S130_CON-D_RD_BR_D22 | 1 | 1
 | A32664 | A32664_ACNIS_MAT | A32664_ACNIS_MAT | ASTM F1537_ISO5832-12_D22 | 1 | 1
 | A32664 | [NAME] | A32664_ACNIS_MAT | ASTM F799-82_RD_BR_D22 | 1 | 1
 | A32664 | STANDARD | A32664_ACNIS_MAT | ASTM F799-82_RD_BR_D22 | 1 | 1
 | A32665 | STANDARD | STANDARD | A32663 | 1 | 1
 | A32665 | STANDARD | STANDARD | A32664 | 2 | 1
 | A32666 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | 1 | 1
 | A32666 | BS2S130_CON-D_RD_BR_D22 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D22 | 1 | 1
 | A32666 | STANDARD | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | 1 | 1
 | A32667 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | 1 | 1
 | A32667 | BS2S130_CON-D_RD_BR_D22 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D22 | 1 | 1
 | A32667 | STANDARD | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | 1 | 1
 | A32668 | STANDARD | STANDARD | A32661 | 1 | 1
 | A32668 | STANDARD | STANDARD | A32666 | 2 | 1
 | A32668 | STANDARD | STANDARD | A32667 | 3 | 1
 | A32669 | STANDARD | STANDARD | BS2S130_CON-D_RD_BR_D6 | 1 | 1
 | APS10074 | APS10074_CUT BILLET Ø76xL34 mm | APS10074_CUT BILLET Ø76xL34 mm | BS2S130_CON-D_RD_BR_D76XL33 | 1 | 1
 | APS10074 | STANDARD | APS10074_CUT BILLET Ø76xL34 mm | BS2S130_CON-D_RD_BR_D76XL33 | 1 | 1
 | ASK1676_A32651 | STANDARD | STANDARD | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | ASK1676_A32661 | STANDARD | STANDARD | BS2S130_EN3487_CON-D_RD_BR_D10 | 1 | 3
 | EB/52/M5 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | 1 | 1
 | EB/52/M5 | BS2S130_CON-D_RD_BR_D22 | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D22 | 1 | 1
 | EB/52/M5 | STANDARD | BS2S130_CON-D_RD_BR_D19 | BS2S130_CON-D_RD_BR_D19 | 1 | 1
 | EB/53/M5 | STANDARD | STANDARD | BS2S130_CON-D_RD_BR_D6 | 1 | 1