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.