Forum Discussion
data validation dependant on previous data
Have a look at this example from Debra Dalgleish. She has a detailed article on how to accomplish the task you require. The article has step by step instructions as well as a number of example files for different dependent drop down scenarios:
http://www.contextures.com/xlDataVal02.html
I have looked at this in the past and it does answer part of my question, but is there a easier way of accomplishing the end result?(searching for the tool and spitting out a drawer and tool name). i have a complete list in the link with all the tools and the associated data, i just want to input that data on a separate page and it search the sheet that contains all the data to find the drawer and tool name. otherwise i have to create a named range for every possible combination of them
