Data Validation Dependent on Other Validation

**CKRebel** · 07-10-2012, 11:17 AM

I'd like to begin by thanking any one who helps me solve this problem, your time is greatly appreciated.

First post on here, let's do this!

Provided on this post is my Excel Sheet. The objective of this sheet is to calculate pressure when a pipe material and grade are selected. I have the data validation in the first cell ask for "Carbon Steel" or "Stainless Steel". The next cell asks for spec/grade. When Carbon Steel is input, I have the next cell ask for certain specs, but when I select the drop-down list, there is a space between the specs. When I choose "Stainless Steel", there are no spaces and the list produces exactly as I need it to. This is rather hard to explain so following along with the sheet may help.

Also, I'd like for the tables to not return errors when I change from "Carbon Steel" to "Stainless Steel" when the specs don't match up. For example: If I choose a Carbon Steel and a Grade, then switch the first cell to "Stainless Steel", the table fills with errors because the Stainless Steel spec doesn't match, until I select the Stainless Steel Spec from the second validation. I know this sounds entirely complicated, but when you view the excel you'll see that it's not too complex.
Pipe Calculations.xlsx

**MarvinP** · 07-10-2012, 11:22 AM

Hi CKRebel and welcome to the forum,

I looked very briefly at your attached file and then remembered we have a great tip at
http://www.excelforum.com/july-compe...t-problem.html
that is very good to do what I think you want.

Please read and study what Jerry suggests to see if it can solve your problem.

**CKRebel** · 07-10-2012, 11:24 AM

Thank you so much Marvin. I greatly appreciate the help, sometimes half of the problem is knowing exactly what to search for what I need help with! Lol

**MarvinP** · 07-10-2012, 11:27 AM

I can tell you are an educated person. I too struggle with the "what do you call that?" search criteria problem.

The topic is called Cascading Validation Lists for other search references.

**CKRebel** · 07-10-2012, 11:53 AM

And the same to you sir. When I'm stuck in that "What do you call it?" stage, rather than making a post, could I PM you and ask for some direction? If it's a bother I'm sure I could hack it out myself somehow, but I hate to make several posts when there's already a help thread.

**MarvinP** · 07-10-2012, 11:56 AM

I do PM but I find my golf and sleep hours sometimes make my response untimely. It is normally better to create a thread so you get the Guru who is online. A PM is appropriate if we are online and answering questions. A thread is really better as it can help others looking for the info later. A PM is not searchable for everyone.