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.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,117
Messages
5,857,482
Members
431,882
Latest member
saaaaaaaaaaaaaaaaaaaaaa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top