drop-down cells-making them appear by Lookup possible?
Posted by Connie on July 30, 2001 9:01 AM
I have a drop-down cell with a list (dog,cat,bird).
I have a table "animals" which has dog in A1 and a drop-down list of dog breeds in B1 (Pug,Yorki,Collie).
Is it possible to get my drop-down list of breeds to show up if the user chooses "dog" from the original drop-down cell? I tried using Vlookup, and it just returned whatever the breed name was that had been chosen last in the table, ie Pug. It didn't paste/transfer my drop-down cell of breeds. Is this possible without VBA? Just wondering.