I have a list a of part numbers that I am trying to match all possible substitutions for. I have manually gone through and listed possible substitutions part numbers for a master list of part numbers.
<tbody>
</tbody>
If X=A, B, C and A= B, C, E What formula can I use to end up with the result X = A, B, C, E and A= B, C, E, X?
I may have missed assigning a sub part number to a specific master part number (X) but placed it as a sub part number for (A). But since X = A, I need to make sure that the sub number gets added to X because it is on A.
Make sense?
Any suggestions
Master Part No. | Sub Part No. | Sub Part No. | Sub Part No. |
X | A | B | C |
A | B | C | E |
B | A | X | E |
C | A | E | X |
<tbody>
</tbody>
If X=A, B, C and A= B, C, E What formula can I use to end up with the result X = A, B, C, E and A= B, C, E, X?
I may have missed assigning a sub part number to a specific master part number (X) but placed it as a sub part number for (A). But since X = A, I need to make sure that the sub number gets added to X because it is on A.
Make sense?
Any suggestions