mobilesuit818
New Member
- Joined
- Sep 13, 2006
- Messages
- 48
Hello,
First, I am going to post my data.
This is the table where the data in fed into.
Let me try to explain. The green cell in A2:B2 is the variable. There are going to 5 choices as the variable, but I have only shown 4 which are Plastic, Metal, Wire, Apparel, etc
I would like to get a hlookup so that when that variable changes in (A2:B2), that indexes in A6:A7:A8:A9:A10:A11 will also change according the other yellow indexes catergorized under that variable.
This is one of my first post, and I am new to lookup formulas. Please advise.
First, I am going to post my data.
This is the table where the data in fed into.
| spec sheet template new test.xls | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Finished Product Standards | ||||||||
| 2 | Product Type | ||||||||
| 3 | Metal | Plastic | Metal | Wire | Apparel | ||||
| 4 | Product Composition | Weight | Weight | Weight | Weight(oz) | ||||
| 5 | Height | Height | Height | Weight(gm) | |||||
| 6 | Color | Depth | Depth | Depth | Construction | ||||
| 7 | Texture | Top Width | Tops Width | Top Width | Content | ||||
| 8 | Weight | Bottom Width | Bottom Width | Bottom Width | Finishing | ||||
| 9 | Height | Thickeness/Gauge | Thickness/Gauge | Thickness/Gauge | Color | ||||
| 10 | Diameter | Color | Color | Color | |||||
| 11 | Gauge | Texture | Finishing | ||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
Sheet3 | |||||||||
Let me try to explain. The green cell in A2:B2 is the variable. There are going to 5 choices as the variable, but I have only shown 4 which are Plastic, Metal, Wire, Apparel, etc
I would like to get a hlookup so that when that variable changes in (A2:B2), that indexes in A6:A7:A8:A9:A10:A11 will also change according the other yellow indexes catergorized under that variable.
This is one of my first post, and I am new to lookup formulas. Please advise.
