Data Validation Question. (oops...sorry)
 

I have data validation set up for a few cells in my spreadsheet. What
I am trying to do is create a secondary list based on the selection
from the first cell.

EXAMPLE.

Category
Fruit
Vegetable

Fruit
Apple
Pear
Grape

Vegetable
Potato
Snow Pea
Squash

In the first cell containing data validation (Say A10) you chose Fruit
or Vegetable. In cell B10 your drop down options are based on what is
entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape,
whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or
Squash.

I have checked out http://www.contextures.on.ca/xlDataVal02.html and
can't seem to figure it out. Can anyone help?

Thanks!

Data Validation Question. (oops...sorry)
 

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ChuckF" wrote in message
oups.com...
I have data validation set up for a few cells in my spreadsheet. What
I am trying to do is create a secondary list based on the selection
from the first cell.

EXAMPLE.

Category
Fruit
Vegetable

Fruit
Apple
Pear
Grape

Vegetable
Potato
Snow Pea
Squash

In the first cell containing data validation (Say A10) you chose Fruit
or Vegetable. In cell B10 your drop down options are based on what is
entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape,
whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or
Squash.

I have checked out http://www.contextures.on.ca/xlDataVal02.html and
can't seem to figure it out. Can anyone help?

Thanks!

Data Validation Question. (oops...sorry)
 

Chuck

I doubt if you will get a better explanation than you get at Debra's site.

What part(s) don't you understand?

The range naming or the INDIRECT?

Read it over a few times and I think you can get it figured out.

Debra also has some sample workbooks for download.

See this site........ http://www.contextures.on.ca/excelfiles.html#DataVal



Gord Dibben MS Excel MVP


On 11 Sep 2006 10:35:15 -0700, "ChuckF" wrote:

I have data validation set up for a few cells in my spreadsheet. What
I am trying to do is create a secondary list based on the selection
from the first cell.

EXAMPLE.

Category
Fruit
Vegetable

Fruit
Apple
Pear
Grape

Vegetable
Potato
Snow Pea
Squash

In the first cell containing data validation (Say A10) you chose Fruit
or Vegetable. In cell B10 your drop down options are based on what is
entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape,
whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or
Squash.

I have checked out http://www.contextures.on.ca/xlDataVal02.html and
can't seem to figure it out. Can anyone help?

Thanks!

Data Validation Question. (oops...sorry)
 

Hi Chuck

If you have followed Debra's instructions and defined your named ranges
correctly, then with Data Validation set up in cell B10 as List, with
source =INDIRECT(A10) then it should work.

What happens when you do it?

--
Regards

Roger Govier


"ChuckF" wrote in message
oups.com...
I have data validation set up for a few cells in my spreadsheet. What
I am trying to do is create a secondary list based on the selection
from the first cell.

EXAMPLE.

Category
Fruit
Vegetable

Fruit
Apple
Pear
Grape

Vegetable
Potato
Snow Pea
Squash

In the first cell containing data validation (Say A10) you chose Fruit
or Vegetable. In cell B10 your drop down options are based on what is
entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape,
whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or
Squash.

I have checked out http://www.contextures.on.ca/xlDataVal02.html and
can't seem to figure it out. Can anyone help?

Thanks!

Data Validation Question. (oops...sorry)
 

oops, didn't follow it to the end and see that he had already seen it :-(

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Chuck

I doubt if you will get a better explanation than you get at Debra's site.

What part(s) don't you understand?

The range naming or the INDIRECT?

Read it over a few times and I think you can get it figured out.

Debra also has some sample workbooks for download.

See this site........ http://www.contextures.on.ca/excelfiles.html#DataVal



Gord Dibben MS Excel MVP


On 11 Sep 2006 10:35:15 -0700, "ChuckF" wrote:

I have data validation set up for a few cells in my spreadsheet. What
I am trying to do is create a secondary list based on the selection
from the first cell.

EXAMPLE.

Category
Fruit
Vegetable

Fruit
Apple
Pear
Grape

Vegetable
Potato
Snow Pea
Squash

In the first cell containing data validation (Say A10) you chose Fruit
or Vegetable. In cell B10 your drop down options are based on what is
entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape,
whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or
Squash.

I have checked out http://www.contextures.on.ca/xlDataVal02.html and
can't seem to figure it out. Can anyone help?

Thanks!