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.

2 Dependent lists based on the same list
 

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.

2 Dependent lists based on the same list
 

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.