Do the first cell following Debra's instructions.

Then do the second cell following the same instructions.

I don't understand why that wouldn't work.

Michael wrote:

Hey Dave,

Thanks for your reply. I have already looked at that particular example
posted on the website. However, it does not say anything about muliple lists
that depends on the first selection. The examples on the website talks
mainly about just one list dependent on the first choice, using the indirect
function in data validation.

I have two different cells that are dependent on what is selected in the
first cell...I hope i am being clear.

"Dave Peterson" wrote:

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Michael wrote:

Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.

I hope someone can help. Thanks in advance.

--

Dave Peterson


--

Dave Peterson