i have data in 3 areas
1. Store_Category. This has 4 items in it.
2. Style. This is the style of the 4 items in Store_Category, each item has multiple choices.
3. Sleeve. This is sleeve of the style in Style, most items have multiple choices, one has the choice of 0.
I can get the indirect function to work on the first 2, but I get stuck trying to make the third set of data (Sleeve) show up correctly. I have 2 people telling me to do either a VLOOKUP or an INDIRECT(SUBSTITUTE). I am not sure how to do the indirect substitute, or the VLOOKUP properly.
Hers is my data:
<tbody>
</tbody>
1. Store_Category. This has 4 items in it.
2. Style. This is the style of the 4 items in Store_Category, each item has multiple choices.
3. Sleeve. This is sleeve of the style in Style, most items have multiple choices, one has the choice of 0.
I can get the indirect function to work on the first 2, but I get stuck trying to make the third set of data (Sleeve) show up correctly. I have 2 people telling me to do either a VLOOKUP or an INDIRECT(SUBSTITUTE). I am not sure how to do the indirect substitute, or the VLOOKUP properly.
Hers is my data:
Store Category | Style | Sleeve | ||||||||
Store_Category | Sweaters | Sweats_Hoodies | T_Shirts | Tops_Blouses | SweatersSleeve | Sweats_HoodiesSleeve | T_ShirtsSleeve | Tops_BlousesSleeve | ||
Sweaters | 1/2 Zip | Hoodie | Basic Tee | Blouse | 0 | Sleeveless | Sleeveless | 3/4 Sleeve | ||
Sweats_Hoodies | Boat Neck | Sweatshirt, Crew | Embellished Tee | Button Down Shirt | Short Sleeve | Cap Sleeve | Batwing, Dolman | |||
T_Shirts | Cardigan | Track Jacket | Graphic Tee | Halter | Long Sleeve | Short Sleeve | Cap Sleeve | |||
Tops_Blouses | Collared | Personalized Tee | Knit Top | 3/4 Sleeve | Kimono Sleeve | |||||
Cowl Neck | Polo Shirt | Long Sleeve | Long Sleeve | |||||||
Crewneck | Tank, Cami | Off-Shoulder | ||||||||
Full Zip | Tunic | One Shoulder | ||||||||
Henley | Turtle Neck | Short Sleeve | ||||||||
Hooded | Western | Sleeveless | ||||||||
Keyhole | Wrap | Spaghetti Strap | ||||||||
Kimono | Strapless | |||||||||
Poncho | ||||||||||
Scoop Neck | ||||||||||
Shrug | ||||||||||
Sweatercoat | ||||||||||
Tunic | ||||||||||
Turtleneck, Mock | ||||||||||
Twinset | ||||||||||
Vest, Sleeveless | ||||||||||
V-Neck | ||||||||||
Wrap, Swing |
<tbody>
</tbody>