1. what function is suitable to use when the number or value appeared in
column D until column AX.

2. name will call out in column C when the number or value is catched under
child name which is in column D until column AX.

3. every single name is under the mother name like common,agilent,intel,dell

Common Agilent Intel Dell
Item Description Where
Used OCE1060050657 OCE1060048907 OCE1060053119 OCE1060050039 OCE1060050063 OCE1060050079 OCE1060061001 OCE3932910 OCE3932912 OCE1060029664 OCE1060067277 OCE1060067824 OCE3932924 OCE1060017666 OCE3932923 OCE1060017665 OCE1060030244 OCE1060023252 OCE1060023255 OCE1060033399 OCE1060033400 OCE1060022791-LSP OCE1060045570 OCE1060048683-LSP OCE1060053096-LSP OCE1060073822 OCE1060073700 OCE1060073706 OCE1060073688 OCE1060073693 OCE1060073683 OCE1060073680 OCEC26312-H350-B11 OCE1060048237-LSP OCE1060048235-LSP OCE1060034904 OCE1060042035-LSP OCE1060027423 OCE1060053093 OCE1060050056-LSP OCE2986631 OCE1060050075-LSP OCE1060066985 OCE1060066935 OCE1060066934 OCE1060066983 OCE1060067630
FLX05006100 Cartonbox(415x285x347)
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
FLX05006101 Cartonbox(415x285x347)
1 1 1 1
FLX05006102 Cartonbox(415x285x347)
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
FLX05006103 Cartonbox(415x285x347)
1
FLX05006104 Cartonbox(415x285x347)
1 1 1 1 1 1 1
FLX05006105 Cartonbox(415x285x347)
1 1 1 1 1 1 1 1 1 1 1 1 1
FLX05006106 Cartonbox(415x285x347)
1 1 1 1
FLX05006107 Cartonbox(415x285x347)
1 1 1 1 1 1 1 1 1
FLX05006108 Cartonbox(415x285x347)
1