dependent drop down lists

Hi everyone, I hope someone can help me figure out what I am missing... I have 3 dependent dropdowns; the first 2 work perfectly, but the 3rd doesn't. I tested the formula outside the validation box, and it works great. The process seems to fall apart when creating the name with the name...

Hi! I am building a document which has several dependent variables. The document is so structured that values are pulled in different cells based on other cell values. While I have been successful in implementing most of the requirements, there is one place I am stuck at. I need to form...

I am having issues trying to get my dependent drop down boxes to work and populate from the data set. I am also trying to get the data to populate to a dashboard. I need Date--> Location,Status ,Time ,Shift Time -->Location--> Alpha--->A Time --->Location --> Bravo --> B...

Hi all, I have a bunch of information copied from the internet in a nice structured table. I am trying to create a separate table that a user can make selections using data validation drop downs. These drop downs will be dependent on what the user has selected previously. I have done...

Hello, Looking for some help with dependent drop down lists. File: https://drive.google.com/file/d/0BzcmD6CWA_HheHVPYUpoTVpNNGc/edit?usp=sharing There are three sheets: the two that matter are Degree Audit, and Sheet1. What I need is a drop down list in 'Degree Audit'!A27 that changes...

Hey Everyone! I am new here and am an intern this semester and have been tasked with something but I don't know if it is actually possible. It seems like it would be but I don't really know how to do it. I found a guide online on how to set up dynamic drop downs generally, but my supervisor is...

Hello Friends, I have two tables in one sheet. first table includes three columns and many rows and the second one also has some rows and columns. In the second table headers are "Product Name", "Price 1" and "Price 2" In first table I want to make a drop down list in first column of a row, in a...

This is my first post so I hope to get some good easy feedback. I am making a document for quoting materials and the first worksheet is quoting, all others will be Material Data Sheets. I want to make a drop down list on the first worksheet that can choose from any of the available materials...

So I have a query regarding automatic updating of dependent data validation lists. I feel like this is the sort of thing many have asked before... The following is inserted into the data validation list dialogue box to provide a drop down menu that varies according the value of Cell D7...

Hello, I have been asked to edit a worksheet for a client, they want me to create a dependent drop list using existing data from three columns. I have created a dynamic named range and used and index to create the drop down list, which seems to work correctly. I run into a problem with I try...

Firstly, thank you for the existence of this forum! I am only posting after having exhausted myself in reading about dependent values for drop-down lists, VLOOKUP, HLOOKUP, INDIRECT, etc., and something simply must not be 'gelling' because I cannot seem to get my order form to work right...

Hi All ! four days I worked to my spreadsheet,now, I am only one step before the end. And how it is, I have problem :) I created dependent drop down lists containing unique distinct values in spreedsheet according to the instructions ( Create dependent drop down lists containing unique...