I'm not sure how to explain what I need so hopefully the cells below explain. I have created some dummy data similar to what I need.
I'm trying to create a formula to go into the parent column (G) that will return the value from the part number column (B) of the parent above. All parents are a level 5. I have completed Column G to show you what I would like the end result to be
Any help would be really appreciated as I have been trying with index match using the level (Column D) as a reference and nothing I try works.
The solution can be in VB or a regular formula as this is an automated sheet which will all be coded eventually.
Thank You
Cat
<tbody>
</tbody>
I'm trying to create a formula to go into the parent column (G) that will return the value from the part number column (B) of the parent above. All parents are a level 5. I have completed Column G to show you what I would like the end result to be
Any help would be really appreciated as I have been trying with index match using the level (Column D) as a reference and nothing I try works.
The solution can be in VB or a regular formula as this is an automated sheet which will all be coded eventually.
Thank You
Cat
| B | C | D | E | F | G |
| Part Number | Revision | Level | Qty | Description | Parent |
| Parent 1 | 1 | 5 | 1 | Assembly | Parent 1 |
| 1 | 2 | 6 | 1 | Part of Above | Parent 1 |
| 2 | 1 | 6 | 2 | Assembly | Parent 1 |
| 3 | 2 | 7 | 1 | Part of Above | Parent 1 |
| Parent 2 | 2 | 5 | 1 | Assembly | Parent 2 |
| 4 | 1 | 6 | 4 | Part of Above | Parent 2 |
| 5 | 1 | 6 | 8 | Part of Above | Parent 2 |
| Parent 3 | 1 | 5 | 1 | Assembly | Parent 3 |
| 6 | 1 | 6 | 2 | Part of Above | Parent 3 |
| 7 | 1 | 6 | 4 | Part of Above | Parent 3 |
<tbody>
</tbody>
Last edited:
