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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,118,706
Messages
5,573,720
Members
412,548
Latest member
wallisonlac
Top