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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,118,296
Messages
5,571,396
Members
412,386
Latest member
Yasaman
Top