vlookup and drop-box
 

Hi
I would like to have a drop down box which looks at a list on another sheet [list name could be 'spell' OR 'math'] which is dependant upon the value in
another cell. i.e.
A1 has a drop box with values 'spelling' and 'maths'

B1 has a drop box with reference to two tables 'spell' and 'math'

Is this possible or beyond the scop of Excel? The reason I want to have two
lists in B1 is to have less to scroll through [my lists will be quite long].

Note: I have heavily simplified my scenario, I hope it makes sence.

Kind Regards
Tanya

vlookup and drop-box
 

You need dependent data validation. Debra Dalgleish shows how to set
it up he

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

On May 16, 12:23*am, Tanya wrote:
Hi
I would like to have a drop down box which looks at a list on another sheet
[list name could be 'spell' OR 'math'] which is dependant upon the value in
another cell. i.e.
A1 has a drop box with values 'spelling' and 'maths'

B1 has a drop box with reference to two tables 'spell' and 'math'

Is this possible or beyond the scop of Excel? The reason I want to have two
lists in B1 is to have less to scroll through [my lists will be quite long].

Note: I have heavily simplified my scenario, I hope it makes sence.

Kind Regards
Tanya

vlookup and drop-box
 

See Debra Dalgleish's site for creating dependent DV lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP



On Thu, 15 May 2008 16:23:04 -0700, Tanya
wrote:

Hi
I would like to have a drop down box which looks at a list on another sheet
[list name could be 'spell' OR 'math'] which is dependant upon the value in
another cell. i.e.
A1 has a drop box with values 'spelling' and 'maths'

B1 has a drop box with reference to two tables 'spell' and 'math'

Is this possible or beyond the scop of Excel? The reason I want to have two
lists in B1 is to have less to scroll through [my lists will be quite long].

Note: I have heavily simplified my scenario, I hope it makes sence.

Kind Regards
Tanya

vlookup and drop-box
 

Wonderful!! Thank you

"Gord Dibben" wrote:

See Debra Dalgleish's site for creating dependent DV lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP



On Thu, 15 May 2008 16:23:04 -0700, Tanya
wrote:

Hi
I would like to have a drop down box which looks at a list on another sheet
[list name could be 'spell' OR 'math'] which is dependant upon the value in
another cell. i.e.
A1 has a drop box with values 'spelling' and 'maths'

B1 has a drop box with reference to two tables 'spell' and 'math'

Is this possible or beyond the scop of Excel? The reason I want to have two
lists in B1 is to have less to scroll through [my lists will be quite long].

Note: I have heavily simplified my scenario, I hope it makes sence.

Kind Regards
Tanya

vlookup and drop-box
 

Wonderful, Thank you

"Pete_UK" wrote:

You need dependent data validation. Debra Dalgleish shows how to set
it up he

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

On May 16, 12:23 am, Tanya wrote:
Hi
I would like to have a drop down box which looks at a list on another sheet
[list name could be 'spell' OR 'math'] which is dependant upon the value in
another cell. i.e.
A1 has a drop box with values 'spelling' and 'maths'

B1 has a drop box with reference to two tables 'spell' and 'math'

Is this possible or beyond the scop of Excel? The reason I want to have two
lists in B1 is to have less to scroll through [my lists will be quite long].

Note: I have heavily simplified my scenario, I hope it makes sence.

Kind Regards
Tanya

vlookup and drop-box
 

You're welcome - thanks for feeding back.

Pete

On May 16, 2:42*am, Tanya wrote:
Wonderful, Thank you