Hi,
I could use some help here..
I have a worksheet (worksheet A) with a dropdown list of choices (ie; food, drinks, sides).
On another worksheet (worksheet B), I have a few tables (ie; food--> hot dog, burger; drinks-->pepsi, coke; sides-->fries, rings, etc. etc.)
So if someone chooses 'food' from worksheet A, I want to be able that the next column will show all the 'food' choices in worksheet B that relate to 'food'. I know that I can do this with the indirect function, but I do not know how to make that function work for all cells in the column..
Is there another method?
Thanks!!
Bookmarks