Hlook Help with indexes

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.
spec sheet template new test.xls
ABCDEFG
1Finished Product Standards
2Product Type
3MetalPlasticMetalWireApparel
4Product CompositionWeightWeightWeightWeight(oz)
5HeightHeightHeightWeight(gm)
6ColorDepthDepthDepthConstruction
7TextureTop WidthTops WidthTop WidthContent
8WeightBottom WidthBottom WidthBottom WidthFinishing
9HeightThickeness/GaugeThickness/GaugeThickness/GaugeColor
10DiameterColorColorColor
11GaugeTextureFinishing
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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,112,885
Messages
5,543,028
Members
410,583
Latest member
gazz57
Top