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.
 

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

Similar Threads

Dependent List (via Data Validation) Error 2
Drop Down with dynamic named range offsheet source list 14
How do I change contents of a cell based on drop down list selecte 2
Data Validation - Conditional List 3
stumped on creating dependent data validation lists 1
Data Validation & Dependent Lists -from same list? 5
If, vlookup, data validation & dependent list 6
DEPENDENT DROP DOWN LIST 1

Top