Hello everyone
I need little help for solving a small problem. below worksheet is out of our Bill of Material formula, if we want to produce a Product '55500' we will need input 500,510,520,530,7600.
7600 is our WIP which also has input 10,20,30,40. i need a formula in next column which add OUTPUT number like in column TEST
<tbody>
</tbody>
I need little help for solving a small problem. below worksheet is out of our Bill of Material formula, if we want to produce a Product '55500' we will need input 500,510,520,530,7600.
7600 is our WIP which also has input 10,20,30,40. i need a formula in next column which add OUTPUT number like in column TEST
| OUTPUT | INPUT | TEST |
| 55500 | 500 | 7600 |
| 55500 | 510 | 7600 |
| 55500 | 520 | 7600 |
| 55500 | 530 | 7600 |
| 55500 | 7600 | 7600 |
| 7600 | 10 | 55500 |
| 7600 | 20 | 55500 |
| 7600 | 30 | 55500 |
| 7600 | 40 | 55500 |
<tbody>
</tbody>
