Hi folks,
I am familiar with creating named ranges, drop down lists and dependant drop down lists, but what differs in this example is that I want a choice of 4 different lists depending on a specific number being entered rather than a word.
It isn't working because I am unable to name a range of cells with a number - it has to be a word, therefore unless use some sort of lookup then I can't get this working.
I guess the question is therefore: can you cause the dependant list to choose the correct data if entering a value that isn't the same as the named range?
Any advice greatly appreciated.
Bookmarks