With IF condition in DATA VALIDATION

[IDRIS86]

Hi,

I tried to include a if condition in data validation. But it doesn't accept. please advise. Below the screen shot. My requirement is If the cell Q28 selected with option YES in the dropdown then R28 to be provided with dropdown of table SLEEVETYPE.

Ruskin Quotation with different formula for data valid.xlsx
	Q	R
26	SLEEVE	SLEEVE TYPE
27
28	NO	9 IN 16 GA
DAMPER

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
Q28:Q34	Cell Value	contains "NO"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
Q28:Q89	List	=List!$U$5:$U$6
R28	List	=SLEEVETYPE

Ruskin Quotation with different formula for data valid.xlsx
	W
4	SLEEVE TYPE
5	9 IN 16 GA
6	9 IN 18 GA
7	9 IN 20 GA
8	12 IN 16 GA
9	12 IN 18 GA
10	12 IN 20 GA
11	14 IN 16 GA
12	14 IN 18 GA
13	14 IN 20 GA
14	16 IN 16 GA
15	16 IN 18 GA
16	16 IN 20 GA
17	20 IN 16 GA
18	20 IN 18 GA
19	20 IN 20 GA
20	24 IN 16 GA
21	24 IN 18 GA
22	24 IN 20 GA
List

 

[mart37]

When you change the name of SLEEVETYP in YES. Then you can use as validation list: =INDIRECT(Q28)

 

[IDRIS86]

Hi, Would you help me in writing the formula.

When you change the name of SLEEVETYP in YES. Then you can use as validation list: =INDIRECT(Q28

 

[JamesCanale]

I'm not sure I understand you problem exactly, but if you have a named range called SleeveRange, then this worked for me:

MrExcelPlayground.xlsm
	B	C	D
3	SLEEVE TYPE	Yes	14 IN 18 GA
4	9 IN 16 GA	No
5	9 IN 18 GA	Yes	12 IN 16 GA
6	9 IN 20 GA	Yes	12 IN 18 GA
7	12 IN 16 GA	No
8	12 IN 18 GA	Yes	14 IN 16 GA
9	12 IN 20 GA	No
10	14 IN 16 GA	Yes	14 IN 16 GA
11	14 IN 18 GA	No
12	14 IN 20 GA	Yes
13	16 IN 16 GA	No
14	16 IN 18 GA	No
15	16 IN 20 GA
16	20 IN 16 GA
17	20 IN 18 GA
18	20 IN 20 GA
19	24 IN 16 GA
20	24 IN 18 GA
21	24 IN 20 GA
Sheet40

Cells with Data Validation
Cell	Allow	Criteria
D3:D14	List	=IF(C3="Yes",SleeveRange,"")

 

[IDRIS86]

I need this as below,