If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
List values based on different values selected
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..... |
Thread Tools | |
Display Modes | |
|
|