Hi
I am familiar with the normal "data validation - list" I have several named lists. I want the correct list to appear as drop down in the cell D3 depending of the value of cell C3
Example if you choose: drink in cell D3 you get the drop down list ;water;coffee....
But if you choose meal in D3 you get burger, hot-dog....
Have a long list and want to restrict the values depending on the first choice.
Bookmarks