2 Dependent lists based on the same list

E

EZ

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.
 
E

EZ

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top