2 Dependent lists based on the same list

How can I have a 2nd dependent list based on the same main list. I have my
main
'category' list, then I created my 1st dependent list 'Products' both are
working great. Now I need to add a 2nd dependent list, but is not based on
'Products' rather on dependent on 'category'. I have tried:
=Indirect(substitute(B3," ",""))
=Indirect(Vlookup(B3,CategoryLoc,2,0))
but both didn't work. Both Products and Locations are dependent of
'Category'. I have a range for all my categories, 15 ranges for my 'products'
and about 15 ranges for my locations. What's it that i'm missing?

Thanks.

Try looking under Data Validation on this site:
http://www.contextures.com/tiptech.html

"EZ" wrote:

How can I have a 2nd dependent list based on the same main list. I have my
main
'category' list, then I created my 1st dependent list 'Products' both are
working great. Now I need to add a 2nd dependent list, but is not based on
'Products' rather on dependent on 'category'. I have tried:
=Indirect(substitute(B3," ",""))
=Indirect(Vlookup(B3,CategoryLoc,2,0))
but both didn't work. Both Products and Locations are dependent of
'Category'. I have a range for all my categories, 15 ranges for my 'products'
and about 15 ranges for my locations. What's it that i'm missing?

Thanks.

I have visited the site you have mentioned, but there's no any example of
having two lists dependent on the SAME primary list. But I figured it out.
It's all has to do with range naming (1stSelection_2ndSelection).

Thanks.


--
when u change the way u look @ things, the things u look at change.


"Ron@Buy" wrote:

Try looking under Data Validation on this site:
http://www.contextures.com/tiptech.html

"EZ" wrote:

How can I have a 2nd dependent list based on the same main list. I have my
main
'category' list, then I created my 1st dependent list 'Products' both are
working great. Now I need to add a 2nd dependent list, but is not based on
'Products' rather on dependent on 'category'. I have tried:
=Indirect(substitute(B3," ",""))
=Indirect(Vlookup(B3,CategoryLoc,2,0))
but both didn't work. Both Products and Locations are dependent of
'Category'. I have a range for all my categories, 15 ranges for my 'products'
and about 15 ranges for my locations. What's it that i'm missing?

Thanks.