List values based on different values selected
If "State:" is in A1 and your data is in A12:F17, put this in B2:
=INDEX($A$12:$F$17,COLUMN()-COLUMN($B$1)+2,
MATCH($B$1&ROW()-ROW($B$1),$A$12:$F$12,0))
Copy across and and down as far as F4
HTH
Steve D.
"maniarasan" wrote in message
...
State :
Type1 :
Type2 :
Type3 :
Alaska Arizona
Type1 Alaska1 Type1 Arizona1
Type2 Alaska2 Type2 Arizona2
Type3 Alaska3 Type3 Arizona3
Alaska1 Alaska2 Alaska3 Arizona1 Arizona2 Arizona3
1.1 2.1 3.1 11.1 12.1 13.1
1.2 2.2 3.2 11.2 12.2 13.2
1.3 2.3 3.3 11.3 12.3 13.3
1.4 2.4 3.4 11.4 12.4
1.5 2.5 3.5 11.5 12.5
Above is the worksheet which i'm trying to solve.
When state "Alaska" is selected, Type 1 should list the values 1.1 -
1.5; Type 2 should list the values 2.1 - 2.5, so on
When State "Arizona" is selected, type 1 should list the values 11.1 -
11.5 and so on
Please help me on this.....
|