Data Validation when type Yes drop down come 1,2,3

See attached
farhangul yes no 123 ABC.xlsx

Look here....

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

Solution already supplied works: change A1 from "Yes" to "No" and you will get a new drop down but you will need to click on dropdown in B1 to invoke changed list..

Thank you John for the verification.

farhangul, I did what you asked, I just put it in row one instead of row 2...my bad.

See the reply from "gmr4evr1" in post #2 and my comment in #4..

Here's another way.

If you have many selections available in the top level drop down you wouldn't necessarily want to use a long nested IF formula as the source for the dependent drop down.

Create a list of the selections and their corresponding items...

On Sheet2:

Data Range

	A	B
1	Yes	1
2	Yes	2
3	Yes	3
4	No	A
5	No	B
6	No	C
7	------	------

Then, if the top level drop down is in A1 on Sheet1...

Create the dependent drop down in cell B1 on Sheet1.

As the source use this formula:

=OFFSET(Sheet2!B$1,MATCH(A1,Sheet2!A$1:A$6,0)-1,,COUNTIF(Sheet2!A$1:A$6,A1))

Note that if you make a selection in B1 then change the selection in A1 cell B1 will still show the original selection which may be an invalid selection relating to the selection in A1.