DataBlake
Well-known Member
- Joined
- Jan 26, 2015
- Messages
- 781
- Office Version
- 2016
- Platform
- Windows
Hello all,
I'd be super glad if someone could help me come up with a way to create multiple part numbers using two qualifiers from a single line
so lets say i have this product which would be the parent on Sheet1
<tbody>
</tbody>
and then i have a on a different sheet (TitleHelper) a list of variation identifiers
<tbody>
</tbody>
and here is where i run into my problem is i need to create a new partnum with "*ID Code" for every time this item matches the pattern and the pattern is within min-max. So something like this:
except for every instance that the pattern matches, and the angle is within the range of min-max it inserts the new part number below the parent part number so Sheet1 would look like
<tbody>
</tbody>
*Note that there are 19 columns of important info to copy down to child partnums not just 10
*Note that I will love you forever if you help me, and if you leave me notes to learn
I'd be super glad if someone could help me come up with a way to create multiple part numbers using two qualifiers from a single line
so lets say i have this product which would be the parent on Sheet1
partnum | brand | style | color | size1 | size2 | size3 | angle | reverse angle | pattern |
D4563 | Trian | Glum | Black | 22 | 39 | 32 | -17 | 3.55 | 6x110 |
<tbody>
</tbody>
and then i have a on a different sheet (TitleHelper) a list of variation identifiers
Pattern | Angle Min | Angle Max | ID1 | IDShort | ID Code |
6x110 | -20 | 0 | Coloris | Col | C1 |
6x110 | -15 | 5 | Floris | Flo | F1 |
6x110 | -30 | -10 | Probis | Pro | P1 |
6x110 | -50 | 100 | Slotis | Slo | S1 |
<tbody>
</tbody>
and here is where i run into my problem is i need to create a new partnum with "*ID Code" for every time this item matches the pattern and the pattern is within min-max. So something like this:
Code:
=IF(AND(J2=TitleHelper!A2,H2<=TitleHelper!C2,H2>=TitleHelper!B2),A2&"*"&TitleHelper!F2)
except for every instance that the pattern matches, and the angle is within the range of min-max it inserts the new part number below the parent part number so Sheet1 would look like
partnum | brand | style | color | size1 | size2 | size3 | angle | reverse angle | Pattern |
D4563 | Trian | Glum | Black | 22 | 39 | 32 | -17 | 3.55 | 6x110 |
D4563*C1 | Trian | Glum | Black | 22 | 39 | 32 | -17 | 3.55 | 6x110 |
D4563*P1 | Trian | Glum | Black | 22 | 39 | 32 | -17 | 3.55 | 6x110 |
D4563*S1 | Trian | Glum | Black | 22 | 39 | 32 | -17 | 3.55 | 6x110 |
<tbody>
</tbody>
*Note that there are 19 columns of important info to copy down to child partnums not just 10
*Note that I will love you forever if you help me, and if you leave me notes to learn