Forum Discussion
data validation dependant on previous data
Im trying to create a data validation(drop down list) that is dependant on previous data validations. https://docs.google.com/spreadsheets/d/1Hq_T9PO1tkF2L6wbp6iP-5fER-bo1C8F879NKXccMOA/edit?usp=sharing is my spreadsheet and im trying to create a page that you can type in the parameters and it slowly narrows down your options. in my situation i need it to start with what type of cutting tool, then based on that cutting tool it provides a diameter then based on that diameter it provides a radius.... eventually it will shoot out the tool name and drawer that it can be found in
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:
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
