A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

List values based on different values selected



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 11:10 AM posted to microsoft.public.excel.misc
maniarasan
external usenet poster
 
Posts: 4
Default 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.....
  #2  
Old June 4th, 2010, 11:24 AM posted to microsoft.public.excel.misc
steve
external usenet poster
 
Posts: 28
Default List values based on different values selected

What exactly do you mean by "selected" where does this selection take place,
and where should the list then show up.

Regards
Steve
"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.....



  #3  
Old June 4th, 2010, 11:53 AM posted to microsoft.public.excel.misc
maniarasan
external usenet poster
 
Posts: 4
Default List values based on different values selected

On Jun 4, 3:24*pm, "steve" wrote:
What exactly do you mean by "selected" where does this selection take place,
and where should the list then show up.

Regards
* Steve"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.....- Hide quoted text -


- Show quoted text -


The selection will be made from the dropdown list "State", such that
the values should be listed in type1, type2, type3 as dropdown list
based on state selected.

  #4  
Old June 4th, 2010, 11:59 AM posted to microsoft.public.excel.misc
maniarasan
external usenet poster
 
Posts: 4
Default List values based on different values selected

On Jun 4, 3:53*pm, maniarasan wrote:
On Jun 4, 3:24*pm, "steve" wrote:





What exactly do you mean by "selected" where does this selection take place,
and where should the list then show up.


Regards
* Steve"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.....- Hide quoted text -


- Show quoted text -


The selection will be made from the dropdown list "State", such that
the values should be listed in type1, type2, type3 as dropdown list
based on state selected.- Hide quoted text -

- Show quoted text -


I tried with INDIRECT function but it doesn't worked out completely,
any suggestins would be appreciated
  #5  
Old June 4th, 2010, 12:22 PM posted to microsoft.public.excel.misc
steve
external usenet poster
 
Posts: 28
Default List values based on different values selected

I think I am starting to understand, as you have access to the news groups
could you try looking in "microsoft.public.excel.programming". I think that
the thread started by "Michael Hudston" about an hour ago, might answer your
question.

Regards
Steve
"maniarasan" wrote in message
...
On Jun 4, 3:53 pm, maniarasan wrote:
On Jun 4, 3:24 pm, "steve" wrote:





What exactly do you mean by "selected" where does this selection take
place,
and where should the list then show up.


Regards
Steve"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.....- Hide quoted text -


- Show quoted text -


The selection will be made from the dropdown list "State", such that
the values should be listed in type1, type2, type3 as dropdown list
based on state selected.- Hide quoted text -

- Show quoted text -


I tried with INDIRECT function but it doesn't worked out completely,
any suggestins would be appreciated


  #6  
Old June 4th, 2010, 01:06 PM posted to microsoft.public.excel.misc
maniarasan
external usenet poster
 
Posts: 4
Default List values based on different values selected

On Jun 4, 4:22*pm, "steve" wrote:
I think I am starting to understand, as you have access to the news groups
could you try looking in "microsoft.public.excel.programming". I think that
the thread started by "Michael Hudston" about an hour ago, might answer your
question.

Regards
* Steve"maniarasan" wrote in message

...
On Jun 4, 3:53 pm, maniarasan wrote:





On Jun 4, 3:24 pm, "steve" wrote:


What exactly do you mean by "selected" where does this selection take
place,
and where should the list then show up.


Regards
Steve"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.....- Hide quoted text -


- Show quoted text -


The selection will be made from the dropdown list "State", such that
the values should be listed in type1, type2, type3 as dropdown list
based on state selected.- Hide quoted text -


- Show quoted text -


I tried with INDIRECT function but it doesn't worked out completely,
any suggestins would be appreciated- Hide quoted text -

- Show quoted text -


It doesn't works out as i need to list all the three types with the
single selection (i.e. state)
  #7  
Old June 4th, 2010, 01:39 PM posted to microsoft.public.excel.misc
Steve Dunn
external usenet poster
 
Posts: 192
Default 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.....


  #8  
Old June 4th, 2010, 02:12 PM posted to microsoft.public.excel.misc
steve
external usenet poster
 
Posts: 28
Default List values based on different values selected

Hi maniarasan,

The answer is easy, but the hard part is the question, could you be more
specific.
Is State: a named range and is that used as data validation in a cell which
you select
And are Type1:, Type2: & Type3: also named ranges which you would like to
have the contents change depending on the selection of State:
Should Type!: etc also form a drop down list in a cell with data
validation.

Could you tell me which cells contain the drop down lists and how you have
(done/want to do) this.

Stick with it we will get there.

Regards
Steve

"maniarasan" wrote in message
...
On Jun 4, 4:22 pm, "steve" wrote:
I think I am starting to understand, as you have access to the news groups
could you try looking in "microsoft.public.excel.programming". I think
that
the thread started by "Michael Hudston" about an hour ago, might answer
your
question.

Regards
Steve"maniarasan" wrote in message

...
On Jun 4, 3:53 pm, maniarasan wrote:





On Jun 4, 3:24 pm, "steve" wrote:


What exactly do you mean by "selected" where does this selection take
place,
and where should the list then show up.


Regards
Steve"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.....- Hide quoted text -


- Show quoted text -


The selection will be made from the dropdown list "State", such that
the values should be listed in type1, type2, type3 as dropdown list
based on state selected.- Hide quoted text -


- Show quoted text -


I tried with INDIRECT function but it doesn't worked out completely,
any suggestins would be appreciated- Hide quoted text -

- Show quoted text -


It doesn't works out as i need to list all the three types with the
single selection (i.e. state)


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.