Data Validation List Dependent on Another Data Validation List

[mblander]

I have a dataset in five columns (Let's call the headers "Claim Stage 1, Claim Stage 2, Claim Stage 3, Claim Stage 4, Claim Stage 5"). Under each header, I have 100 data options to choose from. What I'd like to do is have two drop-down data validation lists where the second is dependent on the first.

I have my first dropdown which allows me to select any of the Claim Stages. Now, for example, I choose "Claim Stage 3". What I would like to do is to do a vlookup within the next data validation list where it would give me only the data from the "Claim Stage 3" column.

Suggestions?

 

[jim may]

Check out the tutorial.....

http://www.contextures.com/xlDataVal02.html

 

[mblander]

Worked perfect! Thank you so much!!!

 

[Tybudd]

I have a question that somewhat relates to the one the OP had.

I have 3 columns of data.

Name of Film - Film Length - Film Width


Those are the column names and the data is filled in accordingly, but instead of having 70 rolls showing for each film, I'd like to put a drop down in the first column. And once the film is selected, in the next 2 cells it fills in the Length and Width accordingly. How is this possible.


Lamans terms are never seen as an insult when it comes to Excel

Thanks in advance

 

[jim may]

What you need (to do) here is create a simple data table like so in Range A1:D6

From within Cell F1 goto Data Validation
Under Allow: Select List
In Source enter $B$2:$B$6
OK out Cell F1 should have Drop-down arrow to right afterwards

Enter Formulas in Cell Hi and I1

Select from F1 Drop down --- Done

 

[jim may]

opps, forgot to post,,,,,,,,,,,,

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Film#	FilmName	FilmLength	FilmWidth		FilmName3		300	40
2	10	FilmName1	100	20
3	20	FilmName2	200	30
4	30	FilmName3	300	40
5	40	FilmName4	400	50
6	50	FilmName5	500	60
Sheet1

Excel 2007

Cell Formulas
Range	Formula
H1	=VLOOKUP($F1,$B$2:$D$6,2,FALSE)
I1	=VLOOKUP($F1,$B$2:$D$6,3,FALSE)

 

[Tybudd]

That worked out perfectly, thanks!!